do you use DTC anywhere in the applications?

we had an issue before where there was a never terminating DTC transaction ongoing and it wouldn't terminate by killing the spid and...

From the sounds of the discussion that was had, it sounded like they wanted the same OLTP DB to be running on both nodes to which I initialy said, hold...

Thanks that was my thought as well that it couldn't be done, just someone was saying they managed to do it before to which I thought was a bit strange.

Yeah I have moved on to powershell anyway, just didnt know if there was a quick way to change between DMO and SMO

ok so scripted all tables and views from the db using SSMS and searched for *= and =* to which brought back nothing.

as SQLDMO is no longer a feature in...

No I didn't look at calculated columns, will take a look and re-post.

Managed to get what I needed.

To do this, open up the DSV in BIDS, click on VIEW, CODE, this will then bring up the XML for the DSV and then...

I have seen this a number of times in relation to MSDTC and BizTalk, with one of the instances causing quite a significant problem in the live environment.

To get the...

I would like to thank Chris for this, it is excellent.

One question I have is how do you "UNDROP" from trash can.

Say we have 3 copies of the same table

zz_RecycleBin.Table1_20110411_1125

zzz_TrashCan.Table1_20110410_1426

zzz_TrashCan.Table1_20110409_1735

The...

Hi Gail

Thanks for this, unfortunatly the application which runs is only supported up to SP2 for SQL 2005 as the vendor hasnt got round to testing on their systems for...

to get around this issue i put event handlers on all of my DFT's and Execute SQL Tasks to log to a table when the task started and finished.

i managed...

after a bit of playing with the job and bids I have noticed that the first package is the one which is cancelling so it never gets to package 2,3...

The job was stopped prior to completion by (Unknown) . The Job was invoked by User SITES\agreen. The last step to run was step 1 (LoadingBayBT1). The...

Hi McSQL

Its usually between 6 and 7 minutes then the job stops.

One of the articles I was looking at was in relation to a WAITFOR event where it maybe that...

Hi Adiga

Query --> IntelliSence Enabled is checked, I shall try a repair via Add Remove Programs shortly.

Hi Gail

In terms of the 'not working' I am not seeing the popup box...