Thank for script 😎

... and because we shouldn't shrink some system databases

EXEC sp_MSforeachdb '

DECLARE @ln varchar(100)

SET @ln=(SELECT name FROM [?].dbo.sysfiles WHERE fileid=2 )

USE [?]

IF ''?'' not in...

David, Thank you for Sharing

I saw the use of master.dbo.fn_varbintohexstr

I like your approach better, even if Microsoft doesn't support it anymore (I still see it at SQL 2014)

Another...

Angel, Thanks for taking the time to share this with us.

I just put my 5ctv too 😀

- Identify Backup type with msdb..backupset.type 'D' - 'Full'; 'I' - 'Differential'; 'L'...

Hi,

Use the sqlcmd utility

http://msdn.microsoft.com/en-us/library/ms180944.aspx

Batch file:

echo Running badscript.sql

sqlcmd -i script.sql -b -o out.log

script.sql file has all the parameters to call the stored procedure

What happen if my connection is OLE_DB, it doesn't work, I have the same issue, the parameter is not passing

I also have SP2 for SQL Server 2005

I discover something about...

what about if u use a virtual machine with xp pro an install only the web part for reporting services?