ok. If I save it as a Sturctured Storage File. How do I then load back into SQL Server? Lets say for example someone deleted it and I need to...

Thanks. Thats what I suspected, but just wanted to check.

Thanks.

Is this for all threads or will you be querying on a particular ThreadID?

The duration field along with the others were purely for reporting puposes! I think your correct there is probably no need to have the duration field as well.

I'm aloud to...

Jeff,

Thanks for your solution to the question however, thanks for suggesting a better way of storing the data. I was never keen on the Days, Hours Minutes & Seconds Columns....

What you need to do is

1) Backup all User Databases restore them to the new SQL Server.

2) Script all the Jobs from the other SQL Servers and run on...

1) What sort of backups are you talking about? Database, Transaction Log etc.

2) How have you determined that the Backups hang?

3) If doing Database Backups, how big are the Databases?

kevinsql7,

Be careful when dropping the BuiltIn\Administrators Group from the SQL Server. Reason I say this is the the Account that is used to Start the SQL Server Agent requires SA...

Is there a Foreign Key in Table2? If there is try,

SELECT A.*

FROM Table1 A INNER JOIN Table2 B ON A.PrimaryKeyID = B.ForeignKeyID

It depends on what Replication Model you will Implement!

1. If it's just Snapshot then I suppose you can use DTS to copy the Initial Database and then set it up to...

Thanks MG.

Thanks for pointing that out.

Ok thanks.

Thanks Yelena.

awilbur77,

I have been a respected member of these forums on this web site for a long time. No one has ever spoken to me in that tone and these...

Just what exactly are you tryin gto achieve here?

If you have setup Merge Replication then the Insert, Update and Delete Triggers are required otherwise Merge Replication will not work!