Thanks for your response. As it turns out the SQL Service account needed "List Folder Contents" to the root of the drive where the data files are located.

Thanks for the reply. All system databases including the model are in the default data directory (i.e. The same one as tempdb).

Have a look in Books Online for DBCC SHRINKFILE and Recovery Models.

We just let the transaction roll back.

Out of interest, what are the ways you mention?

Can you post your code?

So you have the full blown version not the 120 day eval?

Also, make sure that "Force Protocol Encryption" is not checked. Also, a shot in the dark here..if these client tools are on your workstation as opposed to the server maybe...

Can you post your DDL?

Let me give you an example of a situation in which a view is better than a trigger.

There are two applications. Application X is a legacy app...

It sounds like you might want to look into views. For lots of information on both see Books Online.

Noel

That's the ticket! Thank you!

See the thread "Delete Large records 20 million rows!!! FAST" in this forum. It might give you some good ideas.

I was thinking that about the agent also. Any suggestions as to how to test it? I'm not able to make the service fail not can I log in as local...

If I understand you correctly you want either triggers or views. Look them up in Books Online.

Right! I guess what my question really is, is this. Because the count(*) is on the primary key (i.e. it is unique) will SQL continue searching once it has found...