How to empty database
Sometimes you need to empty the content of database. Following script can do that for you.
2007-10-15
4,810 reads
Scripts
Automate Scripting with SQL Scripter
SQL Scripter is an open-source console tool for generating SQL Server DDL. Written in C# using .NET 2.0, SQL Scripter provides front-ends for MSBuild, NAnt and the Windows command line. Each front end supports syntax for specifying which types of database objects to script, including all objects of a type or directly named instances.SQL Scripter […]
2007-10-12 (first published: 2007-07-31)
6,255 reads
usp_ShowOrphanUsers - SQL 2k
Check Orphaned logins ie, not associated with any database on the current instance.
2007-10-11
881 reads
Find Column Usage
When changing schema or modifying an application it is often necessary to determine when a column from a specific table is used. This procedure produces a formatted report (when outputting from query analyzer or management studio in text mode) that specifies all of the procedures, views, functions and triggers that use the designated table.column.
2007-10-10 (first published: 2007-07-19)
7,380 reads
Auto Auditing on Tables
This is something that I find very useful and saves me a lot of time.This procedure needs to be created on the Database that holds the table that you wish to Audit. This procedure when called will create an audit table based on your source table in a database of your choice. All update/delete and […]
2007-10-03 (first published: 2007-06-20)
9,229 reads
Creating BCH Files for Veritas Direct to Tape
This script was written to solve a problem where we needed to dynamically create bch files for Veritas Backups direct to tape backups. We needed to parse the sysdatabases daily and create the bch files that veritas would use to backup each server and database. This SQL Script uses xp_cmdshell to call a windows shell […]
2007-10-02 (first published: 2007-06-18)
450 reads
create an insert statement
Many times we are required to write lenghty insert statements for tables with many columns. This script will create an insert statement for u.It takes 2 parameters first tbale name and second the ordinal positions of the columns seperated by ','for example USP_GenerateInsert 'TabName' ,'1,2,3,4,5'Hope this is Helpful
2007-10-01 (first published: 2007-06-17)
1,737 reads
Change DTS package owner
This simple script is useful if you have a lot of scripts owned by developers, and you want to re-assign them all in one go to SA or any other login. Note the section which produces a rollback if you have any problems after the re-assign
2007-09-27 (first published: 2007-06-01)
2,376 reads
Extracting words with removal of punctuations
Extracting words of a string with removal of unwanted punctuations.This is a flexible function to extract words from a string and tested on both SQL 2000 and 2005As you see the logic of this function is very simple. Maybe the update statement seems strange to beginners because it does not update any field of underlying […]
2007-09-26 (first published: 2007-05-26)
1,288 reads
Row counts for all tables in a database
I saw a script on here that outputs commands to the messages pane in Query Analyser. When run, these scripts output row counts for all your tables. This script does the same thing, but in one step.Tested on SQL Server 2000.
2007-09-25 (first published: 2007-05-24)
751 reads
Blogs
Book Review – Microsoft Power BI Performance Best Practices
I was asked to do a review of the book Microsoft Power BI Performance...
SQL Server Distributed Availability Groups and Kubernetes
A while back I wrote about how to use a Cross Platform (or Clusterless)...
Introducing SQL Server 2025 - Enterprise Ready AI
Introducing SQL Server 2025 - Enterprise Ready AI SQL Server 2025 is an upcoming...
Forums
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
A Strange Result
Comments posted to this topic are about the item A Strange Result
Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing
First time here...hoping I can find some direction and answers so I can devise...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers