Hi Grant,

Your work around for delegating profiler access is intriguing. Could you please take a few moments to share this setup, so it would help the rest...

Hi,

Thanks for the fast response. I am not experienced with full text engine. So I am not sure how I would go about doing so. When...

After setting a db to offline it wont be available for a restore, however, you put all statements in a single transaction

--Step1

alter database <dbname>

set offline

with rollback immediate -- this is...

the original script might kill connections that are active, what about new incoming connections, they will still be created.

With the set single_user also it is not possible to achieve the...

Nigel,

I think you missed my post on page 1. It has as a similar implementation, and it allows to find the first sunday - saturday of the...

Hi,

This is a nice idea, however, with the implementation I see an issue. What if I want to find the first Tuesday for july 2009? Instead...

When implementing the HashBytes or CheckSum is it optimal to do these checks manually in the respective update stored procedure, or is it better to be used trigger based? ...

You mention that SQL Server Audit object is available in any version of SQL other than Express, however, Audit is only available in 2008 Enterprise. Is there a water...