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,204 reads
- Interests: MusiC (Heavy Metal), basket ball
2009-12-17 (first published: 2008-07-13)
1,853 reads
2009-04-17 (first published: 2008-10-15)
1,109 reads
2009-04-09 (first published: 2009-03-16)
1,390 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)
994 reads
2008-08-27
1,027 reads
2008-08-20 (first published: 2008-06-19)
1,129 reads
2008-06-20 (first published: 2008-05-11)
1,467 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,568 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,445 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
The Long Name
Comments posted to this topic are about the item The Long Name
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
T-SQL in SQL Server 2025: Fuzzy String Search I
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?