This script runs within a DTS package. It searches the backup directory stored as a global variable in the script and trims all backup files older than some number of days. the script includes logging to the C: drive so you can trace the effects of the script. You need to create the global variables […]
2001-09-12
1,525 reads
This SP checks the path where SQL Server is installed, and then lists all the .mdf and .ldf files. Also list the quantity of tables, views, sp, xp and users on the given database.
2001-09-10
2,824 reads
Creates the backup devices where sql server is installed, creates an error message above 50001, an alert, and an adittional job in case the scripts fails. In the first time backups all databases and then backups the logs until two days past from the last full backup. Then backups the databases again and so on. […]
2001-09-07
1,264 reads
A simple stored procedure that only shows the user tables. It is like sp_tables but fixed to give a simpler vision of the tables.
2001-09-07
1,680 reads
Here we go again. This is the last in my backup series that I use to do backups of the databases. As far as I know this should only kick out errors when there really is one. This stored procedure is designed to take 4 parameters @bksrv : This is the name or the IP […]
2001-09-06
878 reads
This is the SP I schedule to do diff backups on the DB's that I can. I still need to add errorchecking to see if there is a full available before I do a diff. I'll add that when I get time. This stored procedure is designed to take 4 parameters @bksrv : This is […]
2001-09-06
1,545 reads
Displays identity values, number of rows in the table, and the difference between the two. The difference can indicate the amount of deletions that could be going on.
2001-09-06
358 reads
This script creates a stored procedure that shows you a list of all the users that are locking objects on the database with mode X. It shows a full and detailed description on the user and object locked.
2001-09-06
1,470 reads
This is the script I use to backup all my DB's this does fulls and dumps them locally to disk then spools them off to FTP. This stored procedure is designed to take 4 parameters @bksrv : This is the name or the IP address of the spooler or backup server to send to. @user […]
2001-09-06
4,600 reads
This stored procedure, updates the schema version of user table(s), which in turn marks the Stored Procedures and Triggers for recompile.
2001-09-05
1,418 reads
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
WhatsApp 082225313145 Jl. Pluit Raya No.200, RT.16/RW.8, Penjaringan, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus...
Comments posted to this topic are about the item When the Token Meter is...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers