Viewing 15 posts - 16 through 30 (of 32 total)
This was a script to a really nice function which lets you format the date any way you need.
September 16, 2004 at 8:45 am
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...
August 24, 2004 at 6:33 am
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...
July 20, 2004 at 2:37 pm
Would you share a copy of the script you use to drop connections?
July 14, 2004 at 2:56 pm
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...
July 13, 2004 at 2:33 pm
Do you have some examples you would care to share?
July 9, 2004 at 2:28 pm
Check out this site as it seems to pertain to why you are getting NT authenticated.
July 7, 2004 at 10:45 am
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...
June 11, 2004 at 8:43 am
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...
May 13, 2004 at 9:56 am
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...
May 12, 2004 at 8:40 am
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...
March 19, 2004 at 11:15 am
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?
March 17, 2004 at 11:46 am
Would someone who wasn't a sysadmin be able to run a DTS script using DTSRUN.exe?
March 15, 2004 at 8:34 am
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...
February 6, 2004 at 2:50 pm
I am still very interested in seeing what code you are using to check to see if someone has the latest ADP version. Most code I have seen checks...
February 6, 2004 at 7:46 am