Johnathan,

I liked your code and it worked for me but when I try to do this from the computer of someone who is not a sysadmin it does not work. ...

http://www.sqlservercentral.com/scripts/contributions/1193.asp

This was a script to a really nice function which lets you format the date any way you need.

Sue

Seems like I read somewhere that you couldn't set a breakpoint if you have SQL Server started using the Local System account.  Don't remember all the details but you might...

I have a DTS package set up to connect to an Oracle database and import various fields into SQL Server tables.  Many of these fields require a year to be...

Brad,

Would you share a copy of the script you use to drop connections? 

Sue

Steve

I have also had Database Maintenance plans that I found had not failed but were still executing because someone had left a connection open.  I have it set to reorganize data and...

Doug,

Do you have some examples you would care to share?

Sue

John,

Check out this site as it seems to pertain to why you are getting NT authenticated.

http://support.microsoft.com/default.aspx?scid=kb;en-us;194641

Check for nonprinting characters as I had text file similar that had a CRLF inserted in one text field which caused it diplay as blank but it was not null.  I...

A dsn-less connection simply stores the location of the data within the database instead of setting up a DSN on the computer.  To set this up I initially have to...

We use numerous Access programs which have an Access front end with the data stored in SQL Server.  Each different program has a master version, which is stored on the server, and...

This is a problem that we had frequently in our organization.  After we moved the data to SQL Server and linked the tables to Access, the programs seldom, if ever get corrupted.  When the data...

Is there any way to have the job run on demand by a nonsysadmin without using a proxy account?

How do you raise an error which starts the job?

Would someone who wasn't a sysadmin be able to run a DTS script using DTSRUN.exe?

Michael,

Thanks so much for your patience.  I also work for a government agency.  I knew about the file scripting object.  I just didn't know how to set the property of...