Thanks for the detailed comment 🙂

I couldnt see why you want move tempdb to Disk D unless you are out of space on C.Moving tempdb to difference LAN Partitions is...

the main problem was due to not checking another column value;)

Thanks Jack for the detailed comment 🙂

I hadn't considered the case you described about multi row delete, I'll apply the required changes. However, the problem I'd written exists with one...

Jack Corbett (2/4/2009)

---

Are you sure the user that is executing the source query has rights on the other database? Cross-Database ownership chaining is disabled by default in SQL Server...

The database exists. besides I test the trigger on data that exists on both databases. The trigger acts the same if the referenced column data exists on the other database...

Jeff Moden (4/26/2008)

---

The first 3 things I'd do is...

1. Update to sp2 and apply the latest cumulitive update (#7, I believe).

2. Turn off autoshrink. If it keeps...

Thank you Steve 🙂

Thank you Steve 🙂

each user has his own categories, it may be the same as others or not

My main question is around cascade on delete which produces cyclic cascade...

sorry I didn't get you Abhijit

this is one of the designs that didn't work:

User(id, name), I define cascade on delete user and category

Task(id, UserID(FK), CategoryID(FK)) -> I

Category(id,...

When I define cascade or set null on update/delete of their FK references, a cyclic problem occurs:

User(id, name), I define cascade on delete user and category

Task(id, UserID(FK), CategoryID(FK)) ->...

Thanks Michael for the comments,

From this article:http://www.sql-articles.com/index.php?page=articles/linked_server_part2.html], I concluded that SQL authentication will not resolve the problem, Please provide me with more comments if I'm wrong.

I'm having the same problem subhad; could you clear me about followings?

"I added NT AUTHORITY as a user to SQL Server 2005"> I have NT AUTHORITY\LOCAL SERVICE,...

Thanks for replies

my problem is solved. That was due to a mistake in creating data set I removed it and created again and it resolved 🙂

Thanks a million mani.balaji:)

Thanks for the comments 🙂