Salakhetdinov Shamil
mcp2004 at mail.ru
Thu Mar 26 02:50:30 CDT 2009
Hi Mike, Yes, that's useful - I have added the link to MS LIve dba-VBn favorites. Thank you. -- Shamil -----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> Date: Wed, 25 Mar 2009 19:17:11 -0400 Subject: Re: [dba-VB] SCRUM: Invalid Columns > 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 > > >