I'm surprised that this is even a topic for the daily Editorial. Even though there are a few DBAs who make their living from consulting / websites / podcasts, and...

I'm confused by something; you said you were successfully running 2000 and 2005 clients simultaneously, but when you reinstalled 2000, you gave it an explicit instancename. So, you reinstalled the...

The default segment is where your data resides, as opposed to the log segment. Techinically, you can have non-defaut data segments, but this is not common.

Anyway, you can 'clear' the...

Actually, the error occurred when I was using a DTS package to copy the table to another database. Others here have added columns to the table, and if it raised...

OK, I just found a 'trick' that may be well-known: In EM, go into Design Table, position the cursor in the grid, right-click and choose Select All. You can...

Thanks, guarddata and Johnathan. I ran both of your scripts against my table, and they both returned 7903 for the row size. But, SQL Server in the error message returned...

Thanks much! I had to try automating this, and I think this is it. (Sorry, I don't know how to keep the code indented in this window to make it...

If you set SQL Server memory to be dynamically allocated, shouldn't it automatically leave memory for the O/S, etc.? Also, I've noticed that the memory tab in SQL Server Properties...

Take a look at 'Execute Package Task' in Books Online.

There is a good faq on this site:

http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp

I think modifying the tables directly is the only way for what you want to do; there's no stored proc, etc. that I know of. Where is it you want...

DBCC DROPCLEANBUFFERS is supposed to do it, but I haven't tested it.

This is a good site for version numbers; it doesn't list 8.00.780 but that's not to say it doesn't exist:

http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4

Looks like this is an issue relating to MS03-031. Check out http://support.microsoft.com/?kbid=826161

I don't think so. There is 'remote query timeout' and 'query wait' in sp_configure, and of course query governor cost limit. I've also looked for this feature and didn't find...