You might not even need to do that - depending on how long ago the changes were made and how much data is kept in the default trace.

You can run...

Is this stored procedure called by different users? And, are all objects referenced in the stored procedure at least schema qualified?

This could be a case where the procedure is...

Is SQL Server Agent running under the same service account? Was that account added separately to SQL Server and granted sysadmin, or are you relying on group membership?

Do you...

I probably would have just set the format on the text box itself, instead of using an expression. The formula would be the same.

The way you implement parameters will be slightly different, depending on where the code for the report sits. If the code is embedded in the report - then you...

Geoff A (4/29/2011)

---

be careful if you are running that mirror with a witness server. I have seen mirrors fail over during such routines. re-index is extremely log intensive. if your...

QQ-485619 (4/29/2011)

---

The script task is more of something that I am looking for. However, I got an error when I am testing it:

Error 30002: Type 'DirectoryInfo' is not...

You can add additional filtering to the statement after the cte. In your case, you need to identify the criteria that determines that you have reached the appropriate management...

You can use a script task in SSIS and use something like the following:

' Microsoft SQL Server Integration Services Script Task

' Write scripts using Microsoft Visual Basic

' The ScriptMain class...

SQLMyFriend (4/26/2011)

---

Jeff, not sure I understand this, when you say:

"I would probably not do that - instead, I would use proxy accounts to grant the appropriate rights needed for each...

Just to be clear - if that...

Review this article: http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/

I would also recommend that you review the discussion that follows that article.

This is usually an indication of a bad execution plan for the parameters being run from the application. Recompiling the procedure and then running with the same parameters generates...

I prefer using ALTER DATABASE ... MODIFY FILE to move database files. This method preserves the database ownership and does not require a detach/attach of the database.

The first step...

It sounds like you may have hyper-threading enabled on those cores. If so, try disabling the hyper-threading and see if that helps performance.

The reason I say this is that...