I don't know if this is useful to you, or you may be too far into production...but if you only have 2 systems, you could use positive identity values for...

In the Enterprise Manager, you need to right-click on the server-->Properties-->Replication Tab-->Configure. Then you can set up replication in the server. The easiest thing to do is set the...

In transactional replication, only changed (INSERT/UPDATE/DELETE) records are replicated to the subcriber database. Are you also trying to track deleted rows? If so, you must create a trigger that...

I have had success using the TABLOCKX locking hint. Although it goes against what seems like common logic, it actually increased performance by about 10x.

I especially notice improvements when...

Since you are using: "SET @ChildNodeID = (SELECT MIN(ChildNodeID) FROM dbo.tblNodeView WHERE ParentNodeID = @root AND ChildNodeID > @ChildNodeID)", you will get them in ChildNodeID order.

What about using...

The only thing I could find on this says that: constraints require less overhead than triggers, rules, and defaults.

-Dan

If I'm not mistaken, you need to keep in mind that with RAID 5, the size of each disk in the array will be considered usable up to the size...

You may be able to create a computed column with the new name that is simply the value of the original column.

-Dan

It creates/copies the CREATE TABLE statement for that table, so if you paste it into the Query Analyzer you can create the table...(on another server for example).

-Dan

Also, If your insert involves a Remote/Linked server, there is a RPC Timeout setting under Server->Properties->Connections->Query time-out.

-Dan

Sorry about the CHAR(39) thing, I though you were looking for that value(') in the column itself, i.e.-'haas%'

The reasons that I say it's not recommended are that the server cannot...

One thing to mention if performance is an issue...

You could use a Table Variable instead of a temp table. Table Variables are stored in memory instead of tempdb. ...

I think I understand what you are doing...I assume your stored proc is executing a dynamic SQL statement using a parameter as part of the WHERE clause.

I can't say that...

Try this, I changed the real tables temp tables (The "IDENTITY" Function only work with "INTO"):

CREATE TABLE #Employees

( [Name] varchar (50),

Surname varchar (50)

)

INSERT INTO #Employees ([Name], Surname)

VALUES ('Mario', 'Rossi')

INSERT INTO...

We have had great success with Transactional Replication. There is only about a 10-15 second delay in delivering and posting database changes. We are keeping 3 servers in sync...