Something like this may work for you (you will probably want to tweek it to your needs)

select

groupname,d.name

from

...

Can you explain the locking problem a little further?

For what it is worth, both statements work just fine on my servers. are both of your servers at the same version? (select @@version). What do you mean "misbehaves"? Are...

Moving stored procedures would not truncate the log. How are you noticing that the log is getting truncated?

The only way I have been able to tell exactly what happened in the SQLMaint task is to view the maintenance plan history (Right-click plan and view history). The other...

http://www.microsoft.com/downloads/details.aspx?FamilyID=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=en

Simply because we have purchased some software (that will run on another server) that requires a SQL Server database. The vendor's install program that puts a database out on this...

This is excellent information! Thanks so much!

Did you ever figure out how to get the TIME out of the log? I don't think it is available via the DBCC LOG command.

Thanks,

Francis

Not sure why you want to "downgrade" but if it is because of licensing costs, you might want to look into this (and get it in writing): we were once...

Yep, thats it. JourneymanProgrammer had it too, but it didn't sink in until I saw another example

thanks!

Got it. Thanks!

quote:

---

Putting the transactions logs on seperate set of disks is to gain disk I/O speed. Though the transaction log file is written...

Thanks for the reply Frank.

After a closer look at sp_monitor, I think this will give me what I need.

Cheers,

Francis

While "Physical Disk\%Disk Time" and "Processor\% Processor Time" are useful, I find "Physical Disk \ Avg. Disk Queue Length" and "System \ Processor Queue Length" much more informative, especially on...