usp_ShowOrphanUsers - SQL 2k5
Check Orphaned logins ie, not associated with any database on the current instance.
2008-07-16 (first published: 2008-05-20)
1,620 reads
Scripts
2008-07-11
436 reads
Monitor Any Linked Server From SQL 2000
Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000
2008-07-11 (first published: 2008-06-03)
1,610 reads
usp_createsnapshot
Stored procedure which creates snapshot of database. Timestamp in snapshot. Multiple datafiles are supported
2008-07-04 (first published: 2008-05-28)
837 reads
usp_ActiveProcesses - SQL 2k5
Returns list of active processes and their buffer contents over a specified time.
2008-07-02 (first published: 2008-05-20)
1,476 reads
sp_utilityFindObjectModifying
SHOW WHICH TABLES ARE MODIFIED BY A STORED OR FUNCTION OR WHICH STORED OR FUNCTION MODIFIES A TABLE
2008-06-27 (first published: 2008-05-21)
814 reads
2008-06-26 (first published: 2008-05-20)
924 reads
2008-06-25 (first published: 2008-05-20)
1,270 reads
2008-06-25
324 reads
Check DTS Package Logs for Errors
This will let you know which package had errors rather than sifting through all the package logs one by one.You just need to replace the date.
2008-06-23 (first published: 2008-05-20)
719 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers