Pro T-SQL 2005 Programmer’s Guide (Paperback) Book Review
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database
While writing article based on my SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key I got an idea about writing this article. I was thinking if you can find primary key for any table in the database, you can sure find foreign key for any table in the database as well.
SQL SERVER – T-SQL Script to Attach and Detach Database
Following script can be used to detach or attach the database. If the database is to be from one database to another database following script can be used to detach from old server and attach to a new server. Let us learn about how to Attach and Detach Database.
SQL SERVER – T-SQL Script to Insert Carriage Return and New Line Feed in Code
Very simple and very effective. We use all the time for many reasons – formatting, while creating dynamically generated SQL to separate GO command from other T-SQL, saving some user input text to database etc. Let us learn about T-SQL Script to Insert Carriage Return and New Line Feed in Code.
SQL SERVER – 2008 – Book On-Line Link – BOL
I am researching SQL Server. Those who are asking me questions about SQL Server 2008, please refer following link. I will post my tutorials and articles very soon. Books Online is commonly known as BOL.
SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date
This post is second part of my previous post about SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days
SQL SERVER – Fix: Error 2596 The repair statement was not processed. The database cannot be in read-only mode
ERROR 2596 : The repair statement was not processed. The database cannot be in read-only mode.