Thank you all for your replies.

Give me some time to interpret them and check them on this instance.

A little work around I 've done in the mean while, is to...

as Grant stated the intersect is meanth to compare two sets of data, based on all columns of these sets.

An inner join result set is only based on the matching...

I would prefer to wait for the rollbacks to complete, unless they take way , way to long.

GilaMonster (2/10/2010)

Don't be tempted to restart SQL. If you do that, the rollback...

What i meanth to mention is that if you have multi column DRI, you should provide a DRI matching index ( multi column, exact column sequence ) to...

- Talk to the application support contact person.

- DRI may indeed actually NOT be desired at all.

- Keep in mind, this will need the data feed process to be revised...

experience .... ehum gut feeling :w00t:

Invalid "non printable" characters in your script .....

Copy / paste it into e.g. Word and replace the found non-printable characters by a space.

e.g. SQL2000 EM allowed char(13) to be used...

Did you have a look at http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2e047054-d816-4798-98aa-82eb9678dde4/

Gail published a very nice article on managing transaction logs ...

http://www.sqlservercentral.com/articles/64582/

In general we use the same methode as Brad described in his reply.

Can you provide version info regarding the sqlserver you are trying to connect to ?

- Sql2005 / 2008 ?

- Editon ?

- build no ?

- Can you ping the servername (without...

you need to stop/start the instance to activate TCP\IP.

So first enable the setting in config manager, then stop and start the sqlinstance.

Did you try putting it in a udf ?

Been there ..... done that ...:hehe:

Learn to play .... play to learn:w00t:

If they doubt it the db is still in use ??? So far for performance 😉

- You execute the @SQL1. This runs by its own batch and doesn't know your variable.

- IMO you should just change your Set @SQL1 so it uses

......