[dba-VB] SCRUM: Invalid Columns

Mike,

You can stop MS SQL Server service in Services or just reboot your PC.

When that solved delete current version of .mdf, then copy one from archive and attach it again and then restore db from backup using replace option.

Note: published backup has several backup versions - please use the latest one.

To help you to solve the issue I have just uploaded current db files and backup - you can just attach .mdf - backup is to restore db if you'll make some changes you wanted to overwrite back.


The archive is at MS LIve dba-VB:

https://cid-000971dc34dc18c0.groups.skydrive.live.com/browse.aspx/.Documents/NorthWind.NET/Database?view=details

named 

NorthwindNET_DB_and_backup_20090326.zip

Thank you.

--
Shamil

P.S. Falling asleep here CU tomorrow....

-----Original Message-----
From: "Mike Mattys" <mmattys at rochester.rr.com>
To: "Discussion concerning Visual Basic and related programming issues."<dba-vb at databaseadvisors.com>
Date: Wed, 25 Mar 2009 18:11:36 -0400
Subject: Re: [dba-VB] SCRUM: Invalid Columns

> Yes, I deleted everything and orphaned the connection
> Trouble.
> -
> Michael R Mattys
> MapPoint and Database Dev
> www.mattysconsulting.com
> -
> ----- Original Message ----- 
> From: "Mike Mattys" <mmattys at rochester.rr.com>
> To: "Salakhetdinov Shamil" <mcp2004 at mail.ru>; "Discussion concerning Visual 
> Basic and related programming issues." <dba-vb at databaseadvisors.com>
> Sent: Wednesday, March 25, 2009 6:04 PM
> Subject: Re: [dba-VB] SCRUM: Invalid Columns
> 
> 
> > Having trouble finding a way to shut down In-Use database.
> >
> > -
> > Michael R Mattys
> > MapPoint and Database Dev
> > www.mattysconsulting.com
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>