Yes to be more specific we need the error message after that. However the severity is 0 which usually is an informational message only 17 and above warrant major concern....

More actually that it prevents all data changes.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

There are a lot of possibilities and I don't know why I did not see the error message previously.

Check out

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224996

"Don't roll your eyes at me. I will tape them in...

Also post the full error message. Usually there is a number and details with the error that make finding your problem easier.

"Don't roll your eyes at me. I will tape...

You may also need to truncate the log before doing the shrink to kill the virtual logs internal to the file.

"Don't roll your eyes at me. I will tape them...

Check out this KB article

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q310834

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I am not sure that you can change during the upgrade but if you have a spare box around you can install SQL 7 to and put the DB on...

One method you can use is compartmentlize the procedure into component procedures.

Ex.

I have a database with a tables yyy

CREATE PROC ip_test1

AS

SELECT * FROM xxx --Does not exist

CREATE PROC ip_test2

AS

SELECT *...

Trace is your best option and your only true option with SELECT queries. If however there are UPDATE and INSERT and DELETE queries you can use triggers instead to generate...

Yes when dropping indexes especially in a hurry then drop the non-clustered first then the clustered. Every time a clustered index is altered all non-clustered indexes are rebuilt automatically and...

In fact you just have to set either SQLStmt:Begin or Complete to get the sql statements that are run. You can also setup traces with profiler output by using xp_trace......

What error does QA return when you run the query? Also have you set up a linked server and what parameters did you use?

"Don't roll your eyes at me. I...

In Eterprise Manager you can drill thru to management of a server and you will find a listing for SQL Server Logs. Also many major items will be posted to...

ALthough a primary key is not absolutely needed it is best to have one as you need to ensure data entities as opposed to possible duplications. Although you may not...

The basic problem here is that timein is not understood at this level. By replacing timein with the same calulation code it will work. Or you can change you query...