Yes, thank you!   It all helps!  and the Checklist for moving system databases is awesome.

I tried the 'sa' account and I also tried using windows authentication.  no error - just won't connect saying the server does not exist and the registration fails.

I also just  tried...

I reinstalled sql so I can break it again  : )

I can see now why it's probably not a bad Idea to have an offline copy of your system DB...

Thank you ..  that is 'kinda' what I thought but I'm still learning this stuff.   The REASON I wanted to change the column length was because of an error from...

I'll give it a shot!!!  Thank you much!

Thanks.  I did BACKUP my master db before I blew it away with the restore.. BUt I guess that doesn't do me any good and I should have stopped SQL...

Sorry..  maybe I'm missing something..  but I cannot see where you can script out ALL databases at the same time.  I can right-click on each Database - one at a...

Thank you for your patience  with me..

CREATE TABLE [cities] (

 [F1] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [OUTDOOR] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [F3] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [F4] [float]...

17 Columns in Table F1, Outdoor, F2, F3, F4, F5, F6, F7, F8, F9, Medea, F11, F12, F13, F14, F15, F16, F17.  All columns are nvarchar and allow nulls.

need...