This has been an very insightful problem to have. Next time we'll keep in mind the performance penalty of combining the views. As it turns out the culprit was a...

There is plenty of space on the harddrive. Our performance issues in the end weren't related to fragmentation, but it was a good place to start troubleshooting!

It is reasonable enough...

There are only 1318 rows with data 48K and index 16K!

Thanks,

Olja

I have DTC running on both machines. Actually as I run the given code, I can see that a transaction with the same GUID is initiated on both machines.

Thanks,

Olja

Thanks for the replies and samples! I managed to get my code updating the text fields as expected.

Mohammed, how would i go about doing this. I have a cursor which I loop through and previously I would just append the text value to the varchar. How would...

If you go to enterprise manager, right click the db name and choose "all tasks" > "generate sql scripts", a dialogue box will appear allowing you to choose the objects which...

Lowell, I did consider this! The issue is that a lot of my business logic resides at the db level and moving this particular functionality into asp.net will result in...

Selva, you forgot to post the link 

Thanks, Olja

Such a minor yet essential detail. Thanks a lot!

What I usually do is have two delete procedures: one that tries and deletes only the row from the referenced table (usp_User_Delete)  and another called usp_User_CascadeDelete which deletes all the...

I presume that the other tables have foreign keys on this table. Are the cascade deletes implemented to automatically delete the referenced rows and you just want to tell them...

This is an interesting discussion and thank you for your feedback. Although I have let go of the hungarian notation in my code a very long time a ago, the sql...

http://www.windowsitpro.com/SQLServer/Article/ArticleID/22091/22091.html may be what you are looking for.

olja

OK, so you are trying to make sure that no two roles have the same priviledges. If you inserted your new priviledges into a tmp table you could do something...