Excellent script Markus!!! Huge help with what I was wanting to do.

I made some minor tweaks to it to make it compatible with SQL 2008. I...

Is any special promo code required at registration time to get into casino night? It's been a couple years since I've been able to make it, and last time...

BIG THANKS!!! That is exactly what I needed. Can't believe xp_logininfo never showed up in any of the google searches I did. Maybe I should have used...

I have a 2000 DTS package that has a T-SQL step that accepts global variables as parameters.  One of my users needs to be able to execute this package.  I've...

I take the steps specified in the workaround but still have the same issue.  I tried using the wizard and it will export the file fine.  I saved the wizard's...

That worked great! Thanks.

I've got another question now. I am unable to execute the package unless I specify a SQL login. Does this method require SQL Authentication?...

Andy: Yes, every line has a CR and LF. This was my first theory as well, but I found that everything looked good.

Simon: Data Pump. I had looked...

I seemed to have found where my error was. It had nothing to do with the DTS package. The problem existed in the job. I had the...

Through the help of another developer, we found a solution. Believe it or not, this actually worked. We found that the DTS wizard ignored the Null EOL and...

Not the way I understand the problem. Chr(0) is the NULL EOL. I want to get rid of it. Then take the data in the line (which...

The company I work for is creating a web based program that will report on job statuses. Basically, I'm trying to find any supporting tables that are used by...

Try this:

print Dateadd(day, -1 * (day(getdate())), getdate())

Unless there's a system proc that does it, I think this is about as clean as you'll get.

I figured out my problem this morning. Sorry to bother you. It seems that if you are hard coding a path to the attachment you need single quotes...

Thanks everyone. I appreciate all your help.

I don't know if this will help or not but here's something I just found out. My local machine has Service Pack 3. The server its running on...