Mike Mattys
mmattys at rochester.rr.com
Wed Mar 25 18:17:11 CDT 2009
I found this to help me out: SQL Services Manager http://www.sqldbatips.com/showarticle.asp?ID=46 - Michael R Mattys MapPoint and Database Dev www.mattysconsulting.com - ----- Original Message ----- From: "Salakhetdinov Shamil" <mcp2004 at mail.ru> To: "Discussion concerning Visual Basic and related programming issues." <dba-vb at databaseadvisors.com> Sent: Wednesday, March 25, 2009 6:36 PM Subject: Re: [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 >> > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com >