[dba-VB] SCRUM: Invalid Columns

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
> 




More information about the dba-VB mailing list