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,091 reads
- Interests: MusiC (Heavy Metal), basket ball
2009-12-17 (first published: 2008-07-13)
1,818 reads
2009-04-17 (first published: 2008-10-15)
1,098 reads
2009-04-09 (first published: 2009-03-16)
1,346 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)
977 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,499 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
Flyway Desktop Projects for My PoC
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Daily Coping 30 Jan 2023
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Forums
Are you worried about repairing appliances?
Repair My Appliance Is A Service Provider with Certified Appliance Service Technician. Servicing All...
Trouble moving from a 2017 SQL Express DB on one HP laptop to another HP laptop
I am trying to migrate a DB from an old dying laptop to a...
Database copies (cross environment) and sizing strategies for 2019
I'm sure this has been asked many, many, many times and hoping several optimal...
Ask SSC