Perfmon registry entry can be found at , i am not sure if the open timeout setting will work for you or not ...

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\PerfProc\Performance]

Here is some interesting article for...

Trying to get some info about your scenario ...

1.Are you setting up replication for the first time on this server ?

2.Are you able to apply snapshot when you exclude...

How about ...

1. You make the ordering column as float.

2. When someone changes the ordering of a person, lets say from 1 to 5, you update it as 5.1

and then...

Add your NT login as a member of buitin administrator on that MSDE machine.

When you install Sql server on any machine it by default has the builtin\administrator as a login...

I would consult the networking guys to see if there is any network hiccups or outages

Hint: You will have to use ROW_NUMBER OVER ( PARTITION BY ) 🙂

I dont know the answer but would try looking into the mail profile or try different @body_format while sending mail.

If you are planning to implement database snapshots, please go through the following link first.

Looks like on some SAN \ disk array hardware combinations, there is a limitation on the...

@tablename is a local table variable.

When you are executing the dynamic sql, its not able to access it ( out of scope )

Use instead temporary ( #tablename ) or global...

1. What is the data going to be used for ?

2. How many users will be accessing this server ?

3. Are you planning to run reporting of this server ?

Depending...

Sql server service is not able to listen on the given port cause some other application is using it.

Try rebooting the server. This fixed it for me.

Is the database which is not synchronizing properly getting lots of inserts, updates or deletes ?

What is the size of table being replicated ?

Does this happen at some perticular time...

I am not sure what your question is ?

You cannot rebuild index ONLINE if the table has columns with large datatypes like : image, text, ntext, varchar(max), nvarchar(max), varbinary(max),...

I dont know what are you using the file for but you can also use sp_send_dbmail to query output into a flatfile

and have it comma separated cause using xp_cmdshell is...

Ofcourse, you need to provide the input file .sql file and enlist all your SP execs in it.