You can use a script task - i.e.

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

System.Windows.Forms.MessageBox.Show("SOME MESSAGE...

Hi Andy - refer to http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx

GRANT VIEW DEFINITION on Schema.ViewName TO RoleName

GRANT VIEW DEFINITION ON Schema.ViewName TO RoleName

This message indicates the operator has an invalid e-mail address, this is appears to be a response from your SMTP relay. Check the database mail logs. Try to reproduce with...

I'm assuming your running this via the UI which in turn is issuing a DBCC SHRINKFILE (file, EMPTYFILE). You can do a DBCC INPUTBUFFER on the SPID in question to...

SQL writes in 8K data pages thus 8K should be sufficent. As far as queue depth is concerned, most HBA drivers default to 32 per LUN, and 256 per port....

If you have the space, go for 64K. Most people don't 🙂

NP - sent via e-mail.

NP Pete, just sent you an e-mail with the script. Hope it works out for you 🙂

I'm running cumulative update 3 (Build 3186) although there are no fixes for profiler in this build to the best of my knowledge. Does it give you a specify error...

I wrote a VBScript a client a while back that performs a hardware/software inventory via WMI and stored the information in MSSQL. I believe we deployed this via a GPO....

Mosha Pasumansky blogged about this a while back -

http://sqljunkies.com/WebLog/mosha/archive/2006/11/17.aspx

I'm unable to reproduce this behavior - are you running SP2? Regarding login/password, SSAS only supports NTLM/Keberos authentication.

Are you running x86 or x64? Keep in mind SSAS is limited to 3GB in an x86 environment (using the /3GB switch).