Duplicate post. Replies here please:

http://www.sqlservercentral.com/Forums/FindPost1249462.aspx

What do you mean exactly with "network utilization"?

Glad I could help.

This[/url] seems to be what you're after.

Hope this helps

Gianluca

This is a good place to start looking:

http://msdn.microsoft.com/en-us/library/ms187445.aspx

The simplest way is disable the index and then enable it with ALTER INDEX REBUILD.

Another vote for transactional replication.

If you need peer-to-peer replication, be aware that it's an enterprise only feature.

You can also change the application name in SSMS connection settings.

Named instances listen on a non standard port, either dynamic or static.

The SQL Server Browser service tells the clients on which port the named instance is listening. If you cannot...

I guess you need a split function.

Be careful with big input data: the split function handles 8000 characters at most.

Another possibility is using CHARINDEX to find the colon and SUBSTRING/RIGHT...

No surprises: it's all documented behaviour.

You can use any expression as a left or right side of the LIKE operator. Any expression includes a constant, such as '-'.

As far as I know, you cannot.

Oracle and DB2 are supported publishers, but Sybase is not.

Maybe with some replication tools of sybase you can achieve the same thing, but not...

What error are you getting?

Does the remote user have SELECT privileges on the new database?

Lynn Pettis (2/7/2012)

---

Now that it is officially posted on facebook, I can start telling everyone.

Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born at...

Draelith (2/7/2012)

---

I opened up your script Gianluca Sartori, but it is giving me some errors. I noticed that when you are creating the ##DBCC_OUTPUT table, you don't include the RowId...