Search results for query: *

We are trying to create a batch job in Windows that will create a new ODBC DSN. The port number needs to be set in the DSN and I can't find a way to automate that using odbcconf.exe Is there another way to set the port number in a DSN? Thanks.

There are a couple of users which need system administrator permissions but they need to be blocked from creating new logins. Does anybody know of a way to do this? Thanks!

We currently have a 2-node cluster - each node has 60 DBs spread over three SQL Server instances running on 2GB RAM, 2 Pentium III 700Mhz CPUs and 100GB storage. We are experiencing performances problems and the servers are too old to reinvest in, so we are looking to buy new replacements. I...

Hi all, I am moving databases from one server to another and I need to change the Server in all my SQL Server Data Sources on the client end. Is there any way to automate this process or do I have to go into Administrative Tools >> Data Sources(ODBC) and open each data source and change the...

Thankyou for your quick response... I did get it to work (it would help if I remembered to keep the same file name!)

Hi, There is a file I need to delete every time a certain html page is unloaded (either by closing the window or moving onto another html page). I saw that VBScript has a way to delete a file and if I put it in a function like this: <SCRIPT LANGUAGE=&quot;VBScript&quot;> function deleteHTML()...

Terry - I ran some tests and got the date to work using your formatting. Thanks for your help, I should be able to get it to work now. Jon - It didn't work any better with #, but I suspect I was doing something else wrong. Thanks for the help.

I am using Version SQL 8.00.382 Thanks to the people who have responded - I will try both suggestions today

I thought I had a handle on bcp format files and bulk inserts until I was required to insert an 8 character field (eg. 20020622) from a text file to a DATETIME field in a sql database table. I tried using the single quotes, which work on regular inserts: '20020622' but I am getting this error...