Browse by Tags

All Tags » SQL Server Management Studio (RSS)
Lock request time out period exceeded
I was trying to drop a foreign key for a table I was working on and I ran into a time out exception from SQL Server Management Studio: TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for ForeignKey 'fk_MyForeignKey...
Posted 08 June 2011 01:44 PM by Jeff Widmer | 4 comment(s)
Filed under: , ,
Cannot connect to SQL Azure Database
When connecting to a SQL Azure Database using SQL Server Enterprise Manager you will get a “Cannot connect” error if you have not configured the SQL Azure firewall to let your IP address through. To configure the firewall, log into the Windows Azure portal...
Posted 03 March 2010 12:37 PM by Jeff Widmer | 1 comment(s)
Filed under: , ,
How to change SQL Server login default database through SQL Script
I am moving a SQL Server database from one drive to another by detaching and then reattaching.  I detached the database, moved the mdf and ldf files, and then went to attach it and was presented with this dialog: TITLE: Microsoft SQL Server Management...
Posted 19 February 2010 09:51 AM by Jeff Widmer | 2 comment(s)
Filed under: ,
Machine Setup: How to enable Line Numbers in Visual Studio and SQL Server Management Studio
I like to have line numbers visible when working in both Visual Studio and SQL Server Management Studio.  By default, line numbers are turned off in both environments.  One of the first things I do when setting up a new development machine is...
Posted 23 October 2009 09:16 PM by Jeff Widmer | 5 comment(s)
Filed under: , ,
More Posts

Search

Go

This Blog

News

Recommended Blogs

Syndication