Ahh, but that's the thing, none of the usual SPs or INFORMATION_SCHEMA items report an incorrect size. And none of the usuall DBCC items report any issues.

Also, some Events do not seem to work against the filters so you will get anything that happens.

If the column name is the same for all tables then

EXEC sp_msforeachtable 'delete * from where ulame=''sqldummy'''

will do it.

But be carefull not to accidently delete stuff...

This is interesting, looks like there is a hidden piece to allocations.

This forums thread should be of help

http://dbforums.com/arch/7/2002/3/331663

I am pretty srue there is a proper conversion however I cannot seem to find it right off. But here is a way that will work

DECLARE @s-2 as VARCHAR(2)

SET @s-2...

Also, have you checked the load on the server to see how bad it may be. If you have a bottlenecked system you may see timeouts on any complicate query...

I believe you are thinking of rthe /3GB siwtch vambati which should not be needed here.

Pomalis, oes the OS see the 2GBs and has the machien been pushed to see...

Look for the sql.log file in the temp directory. The install writes out a lot of information to it's logfile and the answer may be in there.

There is an article out on the MS KB site (sorry don't have the number) about losing the Server Registrations in EM on XP with regards to the same machine....

MarkusB is right. Just remember to attach using sp_attach_single_file_db to accomplish without an LDF. Also, make sure the version is compatible 7 or 2000 for 2000 but only 7 with...

There have also been folks and an article (sorry don't remember the number) where File and Print sharing had to be enabled to get the install to complete. Check on...

You can also audit your logins with either Profiler to capture connections or if you right click the Server in question in EM and choose properties you will find Audit...

If you use

SET SHOWPLAN_TEXT ON

GO

the your query, you will get a text version of the execution plan which you can print out.

When you say you see these, where do you mean you see this? Each is a demonstrative Alert to provide examples of Serverity based alerts but if your server is...