I have a process, which blocks other processes.  If I do a query on this process from master..sysprocesses? I get this:

select spid,blocked,open_tran,status,cmd from sysprocesses (nolock) where spid = 66 or blocked<> 0

===========================================================================

spid,  ...

[I could not shrink the log file below 25 gb because it was set as min size in database

properties. ... It looks like log file has been incremented many times...

I use a job that logs all runnable processes into a table every minute.  Later I query the table and this helps not only to find out what databases are...

For my servers I use multi-server jobs and snapshot replication to copy my SPs across.  Comes really handy, so you don't have to configure the same reports/alerts on each server.

Sorry, I put the wrong URL above, it should be this one:

http://support.microsoft.com/kb/243586/

It has a list of options which cause the recompiles below.  Anyway the main point of the question...

I found this out.  You need to manually add "Maintenance cleanup task" to have the old backups deleted.  You can not do it in the DMP wizard.

I am using standard...

Unfortunately this query does not work correctly on any of my servers SQL 2000 or 7.0: the database name gets linked to backups for different databases.  Is there a chance...

When you do:

select physical_name from msdb.dbo.backupfile

You get a list of the data and log files like these:

e:\mssql\data\MyDB.mdf

d:\logs\MyDB_log.ldf

What I am looking for is the list of backup files like:

f:\backup\mydb\mydb.bak

f:\backup\mydb\mydb.trn

No, I meant xp_readerrorlog.  The the sp_readerrorlog is just a wrap SP for xp_readerrorlog as you can see from it's code below.

create proc sp_readerrorlog(

 @p1  int...

I am trying to create a text file from Windows event logs, so to be able to import them into a database and send some alerts.

Just found the answer, you can not use insert into with [dbcc checkdb], you have to use ISQL:

DROP TABLE #maint

go

DECLARE @SQLSTR varchar(255)

SELECT @SQLSTR = 'ISQL -E -Q"dbcc checkdb(master)"'

CREATE TABLE #maint...

Ahhh...  Sorry, missed the word DSV!  Great!  This should work for me.  Thanks.

Putting some calculated columns or building a view could be a solution, but I was looking into using just one column for the entire hierarchy.  In AS 2000 I was...

Of course I restored it in standby state and then configured the log shipping to use existing database without reinitialization.  The log shipping definitely works as all the databases are up...

first_file_000000000000.trn

There is no such file anywhere.  This name is used when copy job has nothing to copy, but it does, as all backup jobs are running fine as well...