Get Data, Log, Backup, and Binn Directory (SQL Server 2005)
Use this to find Data, Log, Backup, and Binn Directory for SQL Server 2005
2008-12-15 (first published: 2008-11-18)
1,684 reads
Scripts
Change Ownership of a Maintenance Plan
Change owner of a maintenance plan so the SQL Agent jobs have the correct owner for running.
2008-12-12
3,206 reads
2008-12-12 (first published: 2008-11-19)
879 reads
Report failed SSRS subscriptions
Generates a dataset for determining when subscriptions fail to send e-mail or post reports to file shares.
2008-12-10 (first published: 2008-11-19)
1,324 reads
2008-12-08 (first published: 2008-11-07)
487 reads
Finding all data types in user tables
A quick way to get a snapshot of what data types are being used in all user tables.
2008-12-04 (first published: 2008-10-02)
1,140 reads
2008-12-03 (first published: 2008-10-29)
1,130 reads
MSSQL Job Monitoring Simplified using Simple Query
This query states the execution status of the job i.e. Executing, idle etc. you also modify and search the jobs by changing the search condition.
2008-12-02
1,066 reads
2008-12-02 (first published: 2008-10-30)
1,440 reads
Get SQL Server 2005: Details about running or defined traces
This provides information about traces that are defined on SQL Server 2005.
2008-12-01 (first published: 2008-10-25)
1,303 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
Alamat BCA KCP Thamrin Nine Telp:0821°7555°651
Telp/Wa 628217555651 Thamrin Nine Podium Area - UG Unit A, Jl. MH Thamrin No.10,...
Alamat BCA KCP Samanhudi Telp:08218200203
Telp/Wa 628218200203 Jl. Samanhudi No.57 B, RT.5/RW.3, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
Alamat BCA KCP AM Sangaji Telp:08218200233
Telp/Wa 628218200233 Jl. A.M Sangaji No.020 A, RT.3/RW.04, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers