You could try using the convert function with the 3rd parameter (the style parameter) set to 1 - see Books on Line for info.

eg

declare @mymoney money

set @mymoney = 1234567890

select  '$' +...

exec dbo.sp_helprotect null,'public'

You're talking about two different things here to me - shrinking the log file(s) is quite different to truncating the log.

Obviously if you truncate the log and use a recovery...

You could always use the DTS copy objects task - it gives you the copy with/without data option plus a lot more.

When I do this I usually load the new data into a staging table, I never load data directly to online tables, and then merge the old and new using...

Batch the update it'll run much faster.

See Microsoft's Tips and Tricks centre for help - it's an old trick that works real well.

 http://www.microsoft.com/sql/techinfo/tips/development/updatebatches.asp

Hi,  Not sure if this is the same thing but ...

There was an issue with the DTSUI.dll file in one of the SQL Server 2000 Service Packs - 3a I think - where...

Why not see what EM fires - set up a profiler trace on a db and then use EM to display the db in TaskPad view - it'll show you...

To id the collation issues try the script below. (if this doesn't appears ok post a reply with you email address and I'll email you the script).

Regards,

Stu

--===============================--

use master

go

if exists (select...

Try sp_helprotect

eg

sp_helprotect null,'UserName'

I don't believe you need special permission to run this command.

Got to love the old sybase sprocs.

What Jill says is 100% correct.

I noticed that the log shows you are in fact using a SEND MAIL task - DTSStep_DTSSendMailTask_2 (not an EXEC SQL task) so when you open the...

That's what you get when you exec the stored proc in the wrong database context - make sure you exec sp_helpsubscription in the context of the published database.

Ok here's what I've got...

Easy! Simply add the @subscriber parameter.

Suggest you look sp_helpsubscription syntax in BOL -

sp_helpsubscription [ [ @publication = ] 'publication' ]

    [ , [ @article =...

try this - sp_helpsubscription @Publication = 'PubName'

Exec this in the published db and this will show you articles published and who is subscribered to them.

Obviously you can have one pub serving...

If you're getting the error as dialog pop up when in Task Pad view, simply change the view to Large Icon view and then back to Task Pad view for...