I believe you are looking for a recursive way to find all those dept that have a valid root dept by eliminating those that have in invalid root.

i.e:

(7, 'Test6',...

we restored the database from backups. the concern here is the fact that the files were deleted. there is no concrete evidence on what could of happen, but it could...

Thanks for your reply.

The sql log shows that Sql Server actually restarted. The next entries just show the normal load steps from SQL.

items in the log:

Information,[098] SQLServerAgent terminated (normally)

Microsoft SQL...

if your server is a 32bit server with 16 processors, changing it to 352 should help as this is the recommended setting.

you can check what the current settings and thread...

Increasing the number of worker threads may actually decrease the performace because too many threads causes context switching which could take so much of the resources that the OS starts...

We found that this problem is often found when the database is set to autogrow. The root of the problem is when the database becomes too big and it needs...

[font="Tahoma"]

Hi, we experienced this similar problem on a SQL SERVER 2005 environment. This error started and created a 30 GB log file in a 30 minute span. It took...