Tuesday, December 16, 2008

SQL Server: Use VS or SSMS?

Yesterday, I fired up SQL Server Management Studio 2008 to add a uniqueidentifier column to a table and it just got grumpy and said I would have to drop and re-create the table. I thought it was a server-side thingie when I co-worker asked me to try it in Visual Studio with the Server Explorer and voila!

I was pretty surprised since SQL Server Management Studio is supposed to be the tool of choice for database administration... I guess MS SQL DBAs will now have to re-consider.

No comments: