I agree with Kathi.

SELECT
'Dear' + ' ' + p.FullLegalName as Expr1
, 'RE: SLAUGHTER OF REACTORS FROM YOUR' + ' ' + upper(stli.Name) + ' ' 
    +...

Just to add something that was pointed out to me by a colleague, the function won't work for SQL Server 2005 (need to use SMO instead of DMO), but the...

What server are you running. I've heard of some issues with Windows Server 2003 after applying SP1.

If you run the SELECT statement using xp_cmdshell and OSQL you can have your cake and eat it to

Yes the batch will...

The "Cannot initialize SSPI package" usually refers to making a trusted connection via Windows Security. Did accounts, or policies change recently?

If the ReportServer service uses LocalSystem, then you need to add...

How about

DECLARE @var varchar, @cmd
SET @var = select path_name from PathVariables where active =1
SET @cmd = 'IF EXISTS ' + @var + ' ...stuff'
Exec master..xp_cmdshell @cmd

Or if you're daring, try using...

That script will check if the linked server is defined, it won't test the network connectivity.

Most reliable method is to run a simple select statement on the remote server using OSQL.

Using the techniques I suggested above, I haven't had a problem sending query results using xp_smtp_sendmail.

I've used CDO to send mail as well, but trying to maintain a consistent codebase...

Ok, so you've got a project record that's like this

1, West, 14:00

Node record is like

1, 1

I'll presume you have the ProjID and NodeID set as IDENTITY fields. So the...

You need to set both the Execution and History properties to generate the snapshots.

So are you changing the ProjID key? What gets changed in the nodes? This could be a process similar to Type 2 changes in a datawarehouse.

Before being more constructive we'd...

Check the feature list for SQL Server 2005.

MS will be releasing a set of controls that can be used to render reports in Windows Apps.

I must be confused

You need to pass the whole connection string for each different user?

Just so I know what to keep away from,...

What "certain actions" cause the 100% usage?

Bear in mind that if the operation you're trying to run can't be split safely amongst the processors SQL Server will only use one...

If you looking to send out plain text emails then don't waste your time with SQL Mail and xp_sendmail, get xp_smtp_sendmail from http://www.sqldev.net

If you want to have some HTML...