Agree, avoid auto-shrink. Instead use a script - i.e.

BACKUP LOG AdventureWorks WITH TRUNCATE_ONLY

go

DBCC SHRINKFILE ('AdventureWorks_Log',TRUNCATEONLY)

go

See MS KB240867 -

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

This should help -

How to Use Telnet to Test SMTP Communication

http://technet.microsoft.com/en-us/library/003e4901-884f-4bc7-b3c3-557add4e5c3a.aspx

Ah...misunderstood......I too would suggest BCP...this article might help -

http://www.sqlteam.com/article/osql-storing-result-of-a-stored-procedure-in-a-file

Not sure if a sp_dropserver gets logged in the default trace as an ObjectCreated/Deleted, worth a look though - trace files are in C:\program files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\*.trc

Try -

DECLARE @FileName varchar(100)

,@FileDirectory varchar(1000)

,@Cmd varchar(1000)

SET @FileDirectory = 'C:\TEMP'

SET @Cmd = 'echo OSQL -E -Q "Select filepath, filetree, filename from ccs.dbo.Work_DBA_Purge"-O>>' + @FileDirectory + '\TEST.txt'

EXEC master.dbo.xp_cmdshell @Cmd

NP - i.e.

Option Strict Off

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.IO

Public Class ScriptMain

'Author: Tommy Bollhofer (tbollhofer2@gmail.com)

Public Sub Main()

...

Agree with Chris - if you must live with it however, a FW between the MSSQL server and the application server to prevent users from accessing MSSQL directly. If no...

You can download desktop prof 6.3 via MSDN (assuming you have a subscription 😀 )

Use and execute SQL task in your package and disable the trigger prior to your data flow task.

USE pubs

go

ALTER TABLE dbo.employee DISABLE TRIGGER employee_insupd

go

1) Detach the userDB

2) Copy LDF over to new disk subsystem (i.e. D:\MyDB.LDF -> E:\MyDB.LDF)

3) Reattach the userDB using the new LDF (i.e. E:\MyDB.LDF)

4) Verify userDB

5) Delete the old LDF...

Use dynamic SQL? i.e.

declare @sql nvarchar(MAX),@DBName varchar(50),@myCount int

declare @myTable table (DBName varchar(50))

insert into @myTable (DBName) values ('master')

select @myCount = count(*) from @myTable

while @myCount > 0

begin

select top 1 @DBName = DBName...

Script posted -

http://www.sqlservercentral.com/scripts/SQL+Server+2005/61278/

Use a script task i.e.

Imports System

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.IO

Public Class ScriptMain

'Author: Tommy Bollhofer (tbollhofer2@gmail.com)

'Assumes the following variables are available:

...

Just posted a script you can use (just waiting for it to be published 🙂 ). Title = '2005 Online Index Rebuild using DMV'. This might help you.

As soon...