2002-11-05
592 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
497 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
446 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
421 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
456 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,055 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
293 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
265 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
498 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
323 reads
Blogs
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Connect resiliently to SQL Server
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Forums
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...
AlwaysON health check alerts
Comments posted to this topic are about the item AlwaysON health check alerts
Bat and SQL script to generate DB user permissions for all Databases in SQL server
Comments posted to this topic are about the item Bat and SQL script to...