Getting unique or primary key columns for a given table
Following script will list out all the columns which have unique/primary key constraints for a given table.
2009-01-02 (first published: 2008-12-10)
1,271 reads
Scripts
Automatically Restore Backup Files for SQL 2005
This script helps with restoring backup files SQL Server 2005
2008-12-31 (first published: 2008-12-11)
1,605 reads
Insert Multiple Records using a Single insert statement
This is used to insert the multiple values using a single insert statment.
2008-12-31
521 reads
Tables referenced by a stored proc (2000)
This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.
2008-12-30 (first published: 2008-12-05)
1,038 reads
How to Change all Table owner one in to another in sql server 2000?
we need change all user table db owners For selected database using T SQL we can easily use this method.
2008-12-29 (first published: 2008-11-30)
1,231 reads
Finding Execution Time of a SQL Statement
Capturing the execution time for rebuilding an index for set of tables.
2008-12-26 (first published: 2008-11-27)
1,710 reads
Deleting Duplicate Records
This article explains a simple solution for the common problem in MSSQL 7.0/2000, finding & deleting duplicate records from a table.
2008-12-24 (first published: 2008-11-26)
2,818 reads
2008-12-23 (first published: 2008-11-10)
2,948 reads
Create Role for specific set of Objects based on a set of Conditions.
This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.
2008-12-19 (first published: 2008-07-23)
1,323 reads
Generate CREATE DATABASE FOR ATTACH for all databases on server
I couldn't find a solid script for this so I put this together. It creates the database EXACTLY as it was with growth and proper file groups.
2008-12-18 (first published: 2008-11-14)
1,276 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
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...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Bank BCA KCU Singaraja Telp/Wa:0817 839 777
Bantuan CS : (0817) 839777 Jalan Dokter Sutomo No.3, Banjar Bali, Kec. Buleleng, Kabupaten...
Bank BCA KCU Kuta Telp/Wa:0817 839 777
Bantuan CS : (0817) 839777 Jl. Sunset Road No.88B, Kuta, Kec. Kuta, Kabupaten Badung,...
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