What happens when someone executes that proc outside of his web page? Does he still want to capture errors?

You can do a try...catch block in your stored procedure. In the catch you can log the errors in a table, use raiserror to return the error to the...

From the looks of it...the sp_executesql will do nothing other than return that recordset.

You're also trying to use variables in dynamic sql but you're not telling sp_executesql what they are....

Depends on your requirements what might be the best approach, but from the looks of it, you could script a backup from server a and restore with replace and move...

Wow, this just saved me a ton of time. In the process of moving data centers and have several accounts/profiles to move over.

Thanks Lowell!!

I was thinking it's the GETDATE()-730 part. That's non-deterministic and might explain the different results as it's part of your where clause.

I would look into SQL Search by Redgate and see if that does what you're looking for. It's a free plugin for SSMS. If that doesn't work there...

You could just use a CTE with a row number and order asc or desc based on "top" or "bottom". This would also give you the flexibility of returning...

Never seen it...looks completely pointless if you ask me.

Are you grouping by job ref?

Have you checked log_reuse_wait to see what it the log reuse is waiting on? If it's nothing I don't see why the shrinkfile wouldn't work.

SELECT log_reuse_wait_desc

FROM sys.databases

WHERE name =...

Are you on SQL Server 2005? Truncate_only was taken out in 2008, for good reason. If you are certain your log file is larger than it needs to...

I am by no means a replication expert but I've seen similar issues when the distribution cleanup job starts to fail. Lowering the distribution retention period also helped but...

You got to be kidding me. It does exist. And it's even called Best of SSC. :hehe:

Apparently my google skills have failed me. Thanks Jason. I...

I have yet to see a change request policy that I liked. 😛

I will just say that if I was you I would try to write the policies so that...