This is a script that creates Insert / Update / Delete and Get stored procedures for a specific table.It will only work for tables with a unique primary key.Have a look at what is does, and if you like it, Vote for it. Maybe there are tons of sprocs out there that perform the same […]
2003-02-19
292 reads
The script provided installs a Sql Server User Defined function which will perform a case sensitive string compare similar to the compare script submitted by Mike McManus. The script also includes test code which may be highlighted to test the function once it is installed and provides examples of usage.
2003-02-18
241 reads
This procedure refresh all views of current database in good order to recreate correct dependencies lost after updating views.This procedure just call sp_refreshview and uses temporary tableExecution of this procedure prevent errors in DTS Import/Export wyzard : Copy objects and data between SQL Server databasesexec refresh_all_views_in_order -- in current database and all dependencies are ok […]
2003-02-13
782 reads
Utilizing sp_dropserver and sp_addserver system procedures we will change local SQL Server name to a specified one, or, by default, to the WINS machine name. Just another utility in my DBAservice toolbox database.Notes:1.Tested in SQL Server7.2. In some cases it is necessary to rerun sql server setup in order to start the server after renaming. […]
2003-02-13
380 reads
MetaData_TableDependenceOrder Lists User tables in foreign key dependence order.I use this to determine data load order without having to disable foreign key constraints accepts a database name (required) and an optional comma delimited list of tables to filter the dependency list with. If tablelist is not passed, it returns all tables with a load ranking […]
2003-02-12
166 reads
When you want to compare two strings that may have case differences on a case-insensitive server, this script will quickly and easily do the compare for you. It returns 0 if strings are equal, 1 if not. Feel free to modify/reuse in your code.
2003-02-11
220 reads
If, like me, you are constantly restoring/moving several databases between multiple environments (development to staging, production to training, etc.), you know how tedious it can get to use EM, or to manually type out all those RESTORE...WITH MOVE statements in QA.Even having a saved script isn't the ideal thing, as you still need to go […]
2003-02-10
1,817 reads
I came across a situation where I needed to fix a vendors permissions issue. It required changing permissions on 338 views and tables, and leaving only 5 intact. Below is the Script I used to perform this task.
2003-02-10
157 reads
This Stored Procedure can attach multiple data File that have *.mdf or *.ldf Extention ..Example :you have multiple data file on your "c:\SQL_data directory" .. just type this on your query analyzer.. of course you have to be a member of sysadmin fixed server role exec attach_db "c:\SQL_data"
2003-02-08
310 reads
This script find the size of the data and log file for every database on your server and add it to a table. But it could do with some added sparkle! Still it is simple to run, you might want to change the database from utils mind.
2003-02-07
964 reads
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
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...
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Comments posted to this topic are about the item How Can SQL Server Detect...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers