Cloud & SQLSailor

Cloud, Databases & Beyond!

Month: September 2011

September 30, 2011

Find all tables which doesnt have a primary key column

Today I wanted to pull this info to work on a replication strategy and the below code shows how to do that in a matter of seconds — Find all…
September 27, 2011

Can I upgrade SQL Server 2005 Express SP3 to SP4,which setup should I use?

Many people have this question in mind on how they can upgrade exisiting SQL 2005 Express to SP4,which setup should they use. Answer is – Microsoft SQL Server 2005 Express…
September 27, 2011

Rename a table,Easy using sp_rename,but how to use in C#

Today I came across an interesting question on how to rename a table in SQL Server.Thats a pretty easy one and we can use sp_rename to accomplish this. sp_rename ‘OLD_TABLE_NAME’ …