Did you change this stored procedure after applying SP4? If so, it is not surprising.

Did you have a lot of changes in your data after applying SP4? If so, did...

I cannot see any syntax error in your code. What I suspect is that the UM_DIV column does not exist.

Here is a code snippet. I tested and worked.

CREATE TABLE #1...

Use the CHAR function. I think it is CHAR(9). Please check it.

I believe the original question is the effect of two instances on the same server. It is a good idea to limit the number of connections to the dev instance....

It depends on how you set your audit. You can use the SQL Server Profiler to trrace any change of accounts.

It seems no one knows. See my post, "How to get all accounts with sa privilege?" One way to get the same results may be to use text output rather...

How about use the filter in the SQL Profiler?

Based on my experiences, the service pack and hot fix may affect your recovery, in particular, when you recover a system database.

Colin:

Could you kindly describe it in more detail?

Many thanks in advance.

You can use an UPDATE trigger, and send the update event to your SQL errorlog.

It is an interesting question. Rows are not treated as objects in SQL Server. I really doubt we can find the number of connections to a row. Please correct me...

You can also use:

DBCC SHRINKFILE (<FileName>, <TargetSize&gt

It likely happened after you modified your account.

Some links may be helpful.

http://dbforums.com/archive/index.php/t-353973.html

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

Here is a link for you.

http://www.softwaretipsandtricks.com/windowsxp/articles/581/1/The-difference-between-64-and-32-bit-processors

Right-click your database;

Choose Shrink Database ...from All Tasks;

Click Files ...

Choose ..._Log from the Database file dropdown box;

Choose Shrink file to;

Give a desired value;

Click OK;