2002-11-05
598 reads
Maintenance and Management
Changing the Owner of a Single DTS Package
This is not an original script - but one I modified from an article by Darren Green on databasejournal.com (02/21/2000). His original script changed the owner of all DTS packages owned by @old_owner to be owned by @new_owner. This script will change the owner of the most recent version of a specific DTS package (@p_name) […]
2002-10-29
509 reads
Script to get tables which have primary key
There isn't a convenient sp or tool in sql server to find out all the tables in a database which have primary keys. This script can help you to list all the tables with primary keys.
2002-10-21
452 reads
Set all databses to dbo.
I got this script from this site and it works fantastic. I would just like to give an update to this script. All credit should go to the person that published this script on this site not me. I would just like to point out a few things. If you want to schedule this as […]
2002-10-18
427 reads
sp_checksqlversion
How many times have you seen @@version return a number but failed to interpret what service pack it is? Although SQL 2000 gives a gift (SERVERPROPERTY) of querying a readable value, my script will remedy the puzzle and show more parameters such as CPU speed, memory, windows version, and installation date. The limitations are:1. MSDE […]
2002-10-16
463 reads
Linked SQL Servers, databases, and users Report
Fixed user protion of the script. Sorry had the test script mixed with prod. I was asked to create a report listing all of our SQL Servers, and the databases on them. I was also asked to list everyone that has access to each database and whether it was a standard, windows or windows group […]
2002-10-15
1,063 reads
Script to Drop Primary key in whole database
I have wriiten this Procedure which Drop all primary keysin whole database Dynamically. Create This Procedure in any User database . Execute it . It Will drop all Primary KeysEnjoy
2002-10-09
303 reads
Script to Find, occurence of field in user Tables
Enter the name of the field you want to search, in the varchar variable @fieldname al the tables having this particular field will be listed
2002-10-09
271 reads
Get DB Table Details Quickly
Get All the Table Details in a Database in a Second By Running sp_table_info. This procedure will give the No. of row , reserved space , data space , index space and Unused space. Compile the Procedure in Master Database and access it from any other database. We can use it for a single table […]
2002-10-08
504 reads
Database Identity property resetter
After going through development and test cycles it can be laborious to have to go and reset identity properties on tables (Yawn!!) So I wrote a script to do it. It has two parameters database name and identity start value. It basically checks the identity value with the number of rows in the table. if […]
2002-10-06
329 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers