Interesting....

My question is: Why it stated SQL 2005 error msg, but, both the servers are SQL 2000?

paneri.rahul (7/22/2008)

I need to copy a timestamped file to a different folder and rename it(remove the timestamp) and finally delete the original file.

Firstly, I need to copy the file located...

You may check this article:

http://www.sqlskills.com/blogs/paul/2007/11/13/AutoshrinkTurnItOFF.aspx

Sure....

Right click the destiny server --> All tasks --> Import Data...-->(then, follow the steps)...--> DONE.

WITH NOCHECK?

NOT FOR REPLICATION?

sp_msforeachdb 'use ? select ''?'' as DatabaseName, DATABASEPROPERTYEX(N''?'', N''RECOVERY'')'

😀

by setting this up is this going to require any additional disk space to be consumed on the Publisher server and do you think it is wise to run...

For server side cursor, please check::D

http://www.sqlteam.com/article/server-side-cursors-and-ado-cursor-types

Sometime, you need to check error log or job log (if you have one).

Here you go::D

http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0661.mspx?mfr=true

Check this out:

http://www.informit.com/articles/article.aspx?p=599700

I know most peoples missed the permission setting, which causes the replication failed. So, be careful.

1. Create a table like:

TableName RowCount1 RowCount2

2. Insert the article names from Distribution into the above table.

3. Write a loop to get...

I don't think that restarting SQL server is a good idea. It may cause your database in-consistent issues.

After you killed the session, it was rolling back the transactions. For a...

Check this out:

http://support.microsoft.com/kb/240872