Who did what?
This select will show the last sql statement for every open session plus many helpfull information.
2012-01-13 (first published: 2008-03-04)
3,971 reads
2009-12-17 (first published: 2008-07-13)
1,794 reads
2009-04-17 (first published: 2008-10-15)
1,095 reads
2009-04-09 (first published: 2009-03-16)
1,327 reads
Get DBMail information
get the profile name and the account name etc about the dbmails created on the server
2008-09-12 (first published: 2008-07-13)
970 reads
2008-08-27
1,001 reads
2008-08-20 (first published: 2008-06-19)
1,109 reads
2008-06-20 (first published: 2008-05-11)
1,448 reads
Script permissions on all databases
i took the core from a script found in the site for generating permissions and update it.
2008-05-06 (first published: 2008-03-06)
3,486 reads
space check
When run it will check the space left on the disk. If it was under 4GB it will raiserror.
2008-05-05 (first published: 2008-03-04)
1,419 reads
Blogs
ASF 030: Benni De Jagere interview
By Kamil
Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...
Figuring Out How To Hide Production Data
There’s a really simple conundrum that we go through all the time. The best...
Forums
Query Optimization Level
Comments posted to this topic are about the item Query Optimization Level
Now Is a Good Time for Choices
Comments posted to this topic are about the item Now Is a Good Time...
Design ideas for hostoric data & trending
Hi everyone, I have a use case (below) for which I am considering multiple...
Ask SSC