Looks like a case of dirty reads. Is the query executed with set transaction isolation level read uncommitted ?

I think he also needs to execute this to get database back to multi user mode.

USE [master]

GO

ALTER DATABASE [xyz] SET MULTI_USER WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE [xyz] SET MULTI_USER...

Both Lester and ALZDBA methods works good. I had tried and tested both methods sometime back but I found ALZDBA method less painful if you have only two or three...

Use master

declare @DBName varchar(35),

@STR varchar (255)

declare DBRecoveryModelGenerator_cursor cursor for

select name from sysdatabases

where category...

Delete files in a folder that are certain days old script is worth keeping in personal briefcase. Thanks for a good article.

kdv (3/5/2008)

---

These scripts create the script for logins and passwords, but is there a script that also would script out the logins and their roles? Same with users...

I checked both 2000 and 2005 and it shows nvarchar(255) -

For an EventType of RPC, EventInfo contains only the procedure name. For an EventType of Language or No Event,...

I found these articles by Steve very useful in my last couple of interviews. Though they are published long time back. But still good for references.

http://www.sqlservercentral.com/articles/Administration/2988/

In eventinfo column for DBCC inputbuffer you can see the first 256 characters only. Why not run a SQL profiler. Textdata column will display the complete code in it.

use databasename

go

exec sp_fulltext_database 'disable'

I had moved files using xcopy and robocopy on different server on same network in past. But, never tried if they work on ftp server or not.

A question for...

Try this script to take backup on remote server. I am using it for long time.

/*

exec dbo.Usp_Remote_Backup_2005 @dbname = 'DataBaseName',@backupdevicename = 'DataBaseBackupName', @path = 'F:\Backup\'

exec dbo.Usp_Remote_Backup_2005 @dbname = 'DatabaseName',@backupdevicename...

Thanks for the script G. I was looking for this...

.

No. Enterprise Manager in 2000 is not that robust. But, you can register your 2000 server in...

I think it should...