This is due to you trying to take a trans backup with no fullbackup.

SQL Server Ent either 2000 or 2005 will not install completely on any workstation. I have installed the developer editions locally. They have the same functionality sans the...

We dont want to add any third party components to the SQL server. I can make this work from a VBSCRipt but not from T-SQl itself.

How did you make out with this?  I need to do the same but I need to find the status of each subscription.  I have a number that are in...

How about the best of both worlds?  Create teh sql to grab the correct data/summary and shoot it out as an XML file.  A quick DTD to format it and...

There is but a few problems. 

1.  I need to be able to decrypt and display the password to the user/administrators of the system. 

2.  I need to have it case sensitive. ...

I have to agree.  You have not concatenated the string that was passed into the function.  As a general rule, it is best to print your sql strings to the...

As far as I know there is no way to transactionally replicate the table to Oracle.  I use DTS and  linked servers to get the data from SQL server to the Oracle...

I would also suggest turning any query in the spread sheet to a Sotred proc on teh server.  THis will speed up the returns. 

I agree with Chris.  I prefer not to use the DSN's on a machine.  I feel that using the OLEdb provider and the correct connection string allows me to have...

from what I see, you are trying to use the RTrim function as you would use the RIGHT function.  The function RTrim requires no secondary argument.  RTrim('This String   ') will...

That would be good.  I will take whatever you have to offer. 

So the sql: 

select * from sysarticles where Dest_Table = <table> and select * from syssubscriptions where artid=<artid from previous> will tell me if the table is published and has...

I'll do that as well.  Thanks.

Moving it to another drive and increasing it's size is a workaround.  Follow Zach's advice and find out why it is growing first.  If you cant control that, you will...