Hi Robert,

if you have any specific questions I can help or you can use the specialist forum: http://dbghost.forumco.com/forum~FORUM_ID~7.asp

regards,

Mark Baekdal

MSN m_baekdal@hotmail.com

+44 (0)208 241...

have you tried taking a back up and restoring it to your SQL 2005 instance, it's worked for me so far.

regards,

Mark Baekdal

MSN m_baekdal@hotmail.com

+44...

Install SQL Client tools for SQL 2005 on the client machine and it should work as it will upgrade the SQLDMO.dll so it can connect to SQL2005 instances. 

in process one, where is the audit information on who, when and how all the changes were made? A snapshot will always have the one person as the who and the history of...

try DB Ghost (http://www.dbghost.com) - it's cheap and it works.

regards,

Mark Baekdal

MSN m_baekdal@hotmail.com

+44 (0)141 416 1490

+44 (0)208 241 1762

check out this article on the subject: http://www.innovartis.co.uk/pdf/Innovartis_An_Automated_Approach_To_Do_Change_Mgt.pdf

it's all about creating an automated change management process using the tool DB Ghost. DB Ghost has one major difference to all...

try using:

select serverproperty('servername')

if this is different to @@servername you need to use sp_addserver to make the output the same.

regards,

Mark Baekdal

MSN m_baekdal@hotmail.com

+44 (0)141 416...

we use a standard method:

Select ObjectID

From ObjectTable

Where 0 = case when ObjectName=FilePathName then 0

when ObjectName is null and FilePathName is null then 0

else 1 end

here's a white paper on the subject: http://www.innovartis.co.uk/pdf/Innovartis_An_Automated_Approach_To_Do_Change_Mgt.pdf

The tool at the center of this subject is DB Ghost (http://www.dbghost.com or http://www.innovartis.co.uk)

regards,

Mark Baekdal

try iterating the index objects (using index2) - foreach(SQLDMO.Index2 in View2.indexes){//your code}

regards,

Mark Baekdal

MSN m_baekdal@hotmail.com

+44 (0)141 416 1490

+44 (0)208 241 1762

http://www.dbghost.com

this is how I do it and it always works, it involves using DB Ghost http://www.dbghost.com

use the data and schema scripter to script out the objects to a directory.

run...

try source control - have all development come from source control - and use a tool that supplies the link between source control and deploying changes - DB Ghost

this is something I do to get the schema without having to create it myself:

    'first the schema

    oComm.CommandText = "SELECT top 1 * from [owner].

with (nolock) where 1=2...

I thought these two facts I quoted were fascinating and disturbing. I quoted the Indian summary primarily because India has a very large IT influence - more so than any...