There are many times you have to deploy a common code in all of your SQL Servers. I am sure there might be thousands of way to do this, but here is how I do it and it works great. Good thing is - you can either pass SQL Statement or a SQL script (in […]
2007-03-05 (first published: 2005-05-26)
804 reads
Stored procedure usp_CheckMissingPermission_for_User checks missing exec permission for given user or group on all the stored procedures within the database. It not only detects missing exec permission, but also generates a scripts for you to fix the problem.
2005-05-30 (first published: 2005-05-09)
209 reads
This script generates filegroup listing on a given database for each table within the database. This will be very handy to indentify which table is built on a particular filegroup. This is useful for a VLDB (very large database).
2005-05-27 (first published: 2005-05-09)
413 reads
This script is userful in CaseSensitive environment. This will detect a values from a table column which are lower case.
2005-05-26 (first published: 2005-05-09)
78 reads
Generating WITH MOVE Statements for restoring backups on a different servers which has different disk layout.
2005-05-25 (first published: 2005-05-09)
205 reads
By Steve Jones
Over the years I’ve had this blog, I’ve added lots of tags. In 15...
The moment you decide you want to monitor your SQL Server instance for query...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi, I am trying to automate SSAS cube processing by having an SQL Server...
We are looking for SQL developers as beta users for our SaaS solution (...
Comments posted to this topic are about the item Offline Files
Ask SSC