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,185 reads
- Interests: MusiC (Heavy Metal), basket ball
2009-12-17 (first published: 2008-07-13)
1,844 reads
2009-04-17 (first published: 2008-10-15)
1,102 reads
2009-04-09 (first published: 2009-03-16)
1,375 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)
988 reads
2008-08-27
1,017 reads
2008-08-20 (first published: 2008-06-19)
1,120 reads
2008-06-20 (first published: 2008-05-11)
1,462 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,559 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,437 reads
Blogs
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
Monday Monitor Tips: Looking Back in Time
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Can You Tell Why a Plan Didn’t Go Parallel?
Let’s face it, most of the time, you probably don’t want your SQL Server...
Forums
Where to see how a Partition schema and function is defined
Please see the below. The dependencies of a table(the table depends on) shows Partition...
Is there a way to determine an Azure Data Factory Trigger's "next run time"?
Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a...
The Table Backup
Comments posted to this topic are about the item The Table Backup
Question of the Day
The Table Backup
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers