Data Analytics and Data Management

Read through for comprehensive resources on data analytics and data management.

Enter your email above to receive messages about offerings by Informa, its brands, affiliates and/or third-party partners, consistent with Informa's Privacy Policy.

Leave this field blank

Why would I get a message "Retrying row fetch:rowoffset entry n out of range (pg% obj%, db %)" from SQL Server?

Jul 27, 1999

A. You may also see :- "spid % Getrow: rowoffset entry %(%) out of range (pg% obj%, db %)"...

Why do I get an error in sqlsspi.c?

Jul 27, 1999

A. Full message is :...

Why can't I use RCMD.EXE via xp_cmdshell from SQL Server?

Jul 27, 1999

A. For any access to "network resources" you need to run SQL Server under a user account and not the default LocalSystem account. You can check what userid that MSSQLSERVER is running under by looking at control panel/services highlighting...

Why am I seeing entries in sysindexes (or sp_helpindex) for indexes I have not created?

Jul 27, 1999

A. A. sysindexes contains rows per object as follows :...

Where can I get the ANSI92 SQL information from. - 28 Jul 1999

Jul 27, 1999

A. This is information is only available from ANSI themselves and as far as I know is only available on paper (to discourage piracy). They charge for the information - they have to have some form of income stream after all...

Where can I get SQL 7.0 SP1?

Jul 27, 1999

A. SQL 7 SP1 is now released and available at :-

ftp://ftp.microsoft.com/bussys/sql/public/fixes/usa/SQL70/Sp1

What happened to the gui for column level permissions in SQL 7?

Jul 27, 1999

A. It got missed out. It will re-appear in a future SQL version/serice-pack.

For now you can use standard TSQL commands/sp's. See the SQL Books Online (BOL) for details.

What does sp_sdidebug do?

Jul 27, 1999

A. It is used to turn on or off TSQL debugging. There is no user interface for it and no documentation.

Why is SQL Server better/worse than Oracle?

Jul 27, 1999

A. This is as much a "religious" debate as a technical one. Both products are good (as are others such as DB/2, Informix, Sybase...). My advice would be to stick with whatever you have the technical skills/experience with, and don't change for...

Why can't I shrink my database any smaller than xxx Mb?

Jul 27, 1999

A. The probable reason for this is that you're still on 6.5 and below. With this setup you can only shrink a database back to the last portion of log. So if you defined a database as 400Mb data, 100Mb log you can never shrink it. ...