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)
812 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)
217 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)
423 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)
82 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)
208 reads
Recently I had an interesting use case where I had to a compound calculation...
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
Morning all, Looking for any advice or thoughts on how to achieve the impossible...
As I was looking the authentication set up which come as default when we...
Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...
Ask SSC