I can't replicate it (also SQL2k Sp3a on Win2003). It opens at the default backup location.

What's showing in the "File Name" field before you click on the...

The destination file doesn't have to exist. In my testing I created one from the DTS package.

Cheers,

- Mark

Gregory,

You'll be able to do so. Even though Excel isn't installed, the Excel driver should be there.

For most consistent results, hop onto the server in question (either locally...

I don't think so. Just off the top of my head, I think you'll get Enterprise Manager users screaming.

I'm sure the repercussions are a lot more serious than that,...

I would try wrapping the linked server bit in a transaction and see how that goes.

Failing that, you may want to seek the help of someone who actually knows what...

Another option is to let SQL's built-in functions do it for you....

declare @secs int

select @secs = 7455

select convert(varchar(5), dateadd(second, @secs, '00:00'), 108)

Cheers,

- Mark

Always known about the escape character but never would have considered the use of square brackets. Bit of lateral thinking there... we learn something everyday.

But (MikeTomkies),...

If I wanted to keep a record of all the "spUpdateEntity" sprocs that were executed on the database I would have spUpdateEntity log all the parms to a separate table...

This was a cross-post. There's additional comments made at...

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15202&FORUM_ID=54&CAT_ID=1&Topic_Title=Log+Shipping+Error&Forum_Title=In+The+Enterprise

Cheers,

- Mark

I sometimes use NEWID() to "randomise" results. Eg.

select top 4 * from pubs.dbo.authors

order by newid()

Cheers,

- Mark

Try:

use <dbname>

exec sp_spaceused

Cheers,

- Mark

I was thinking maybe countyDriver.contributingFactors was a varchar comma-separated list of FactorIDs, but your response kills that theory.

The JOIN must be working, otherwise you'd get no rows returned, rather then...

To isolate whther it's the sproc, try calling it from a query Analyzer script and then print/select the output parameter.

Cheers,

- Mark

Can you supply a short example of what the output looks like now, and how you'd prefer it?

Cheers,

- Mark