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)
4,076 reads
- Interests: MusiC (Heavy Metal), basket ball
2009-12-17 (first published: 2008-07-13)
1,815 reads
2009-04-17 (first published: 2008-10-15)
1,098 reads
2009-04-09 (first published: 2009-03-16)
1,345 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)
976 reads
2008-08-27
1,007 reads
2008-08-20 (first published: 2008-06-19)
1,114 reads
2008-06-20 (first published: 2008-05-11)
1,454 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,492 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,428 reads
Blogs
SQL Homework – October 2022 – Replication part 2
In August we started taking a look at replication. We learned some of the...
Function Vs. Performance
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...
Daily Coping 3 Oct 2022
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
Forums
Version Controlling Lambdas
I know there are lambda versions. But I want to know if this can...
subscriber part of ALWAYSON
Hi. Publisher stop sending transaction to AOAG primary replica whenever AG failover. It seems...
SQL Server Licensing Question
I'm in the process of replacing a sql server 2012 with 2019. How do...
Ask SSC