Easiest way to do this (if you need to, answer above questions), is to create a table (tablename, idreset). Have the user insert a value into this table, say the...

First, which version of SQL Server. Second, you posted this in Notification Services. Please post in the forum related to your issue, probably Admin or General in this case.

This looks like homework. Please do not ask us to solve your homework questions. You should be digging in and writing your own SQL.

Please don't cross post.

Discussion here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=353763

I'd make the space and copy it over. Any network hiccups will cause your restore to abort.

I definitely like Robert's approach.

I used to do this with objects by making my own DB, then storing a copy of sp_configure and sysobjects for each db. Then I'd have...

A latch is a type of lock and a timeout indicates that too much time expired. Are you getting errors from clients?

Blocks/locks/timeouts are not serious. They indicate your server, usually...

So they are not failing either? Are there any common attributes in what they do/access?

I'd enable some logging and see if a log is generated. Be sure SQL Agent is...

Event logs have lots of filters. You should be able to move out the SQL Login events easily.

Registration for the BI conference is open at http://www.microsoftbiconference.com/

What's the index? You can see if you have queries that are even capable of using it if you look at the first col in the index and the columns...

backup transaction mydb with no_log

will clear space as well. Then you can run the backup.

Be sure to setup log backups after this along with data backups.

Something like this

update xx

set fld4 = fld1 + total

where fld1 mod 2 = 0

for one of them. The other would be

update xx

set fld5 = fld2 +...

No, no other way around it. The thing you can do is run a report that compares version numbers. They increment by 8 if I remember, so a change of...

While I've rarely had performance issues with RAID 5, there are definitely good arguments to use RAID 10 instead if you can afford the space.

If possible, try to get an...