When posting a reply, you need to look at the portion below and will find edit attachments.

Nick_UK (11/27/2009)

---

does the following do the job for you, this would work in 2005 but I'm not sure if it would in 2000 or not.

USE DatabaseName

GO

EXEC sp_helpfile

GO

books online link to...

I second Lutz ideas of posting the Execution Plan?

What do you mean by disabling table2?

You mentioned about size of table1 but there is nothing in your update statement which...

What details are you looking for?

If you are a fresher in SQL DBA field, look for such...

hoanguyen268 (11/27/2009)

---

Hi all,

I have the same problem with replication. I have one server is using SQL server 2000 (S1) and the other is using SQL server 2005 (S2). Both...

Have you read the Original Post ?

The OP wanted to monitor through script on all Server. OP has mentioned about seeing in GUI.

I...

When you got the idea already then why can't you specify clearly what is that you need instead of posting couple of lines.

Do you need how to move the SP's...

SQL Books Online gives a very good explanation. Please refer it.

In SSMS go to the Database which has your tables.

Right Click the Database -> Tasks -> Generate Scripts.

In the Wizard, click next in the initial screen, in the next screen...

It needs creation of all the database objects manually and use Stored Procs to move data.

I did not get the answer for the question how large is the database and...

Before inserting into the actual table, can you check what's captured by using

SELECT * FROM #TempFirstLevelChangeDetail

What does it show?

You need to script all the database objects on the source server and create them on destination server. After which you can uses BCP or use Linked Server tomove the...

What changes in SSMS are you looking with the SQL Server SP3?

You wanted to purely use T-SQL only to do this?

Not contemplating idea of SSIS to do this?

When you login from your workstation, login details you are providing (Windows or SQL), it needs to have sysadmin Server Role Permissions on that server.