Viewing 8 posts - 1 through 8 (of 8 total)
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...
February 1, 2014 at 11:43 am
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...
March 26, 2011 at 12:50 pm
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...
October 21, 2009 at 5:41 pm
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...
October 21, 2009 at 7:09 am
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...
August 11, 2009 at 10:50 am
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...
August 10, 2009 at 11:12 am
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? ...
December 19, 2008 at 11:03 am
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...
December 18, 2008 at 9:53 am
Viewing 8 posts - 1 through 8 (of 8 total)