all groups > sql server misc > may 2005
remotely access SQL Server via ODBC
Posted by Menuz2 at 5/26/2005 7:39:14 AM
I am purchasing an application that uses SQL Server. The application uses
ODBC. I need to have workgroup members execute this application from out on
the internet. What is the best practice to remotely access SQL Server via
ODBC: setup a VPN using seperate hardware, or using VPN features buil... more >>
Recommendations for importing a lot of data
Posted by Toby Groves at 5/19/2005 9:55:04 PM
The situation is that I need to import a fair-sized wedge of records
into an existing SQL Server database from a remote client. This will be
done through software running on the client as part of an application
upgrade cycle.
Now I'm talking in the region of 50000 records here, across two ... more >>
Designing a database questions
Posted by Maziar Aflatoun at 5/18/2005 11:42:45 AM
Hi everyone,
I'm creating a web application to keep track of user skills. Each user can
have 1 to 100 skills where they select by clicking on checkboxes. Also, is
must be searchable?
Can anyone recommend a good approach for this? Instead of creating 100
columns?
Thank you
Maz.
... more >>
How do I measure the cost of compiling an execution plan?
Posted by pshroads NO[at]SPAM gmail.com at 5/17/2005 5:28:37 PM
My company is using a lot of ad hoc queries and I am trying to convince
them to move to stored procedures. However certain managers don't
believe that the compilation of ad hoc queries and the fact that they
usually aren't reused is really anything to worry about. They think
that the cost of doi... more >>
SQL Server 2000 - 17Gb file - how can I condense/split?
Posted by jsa1981 NO[at]SPAM hotmail.com at 5/17/2005 6:07:59 AM
I have a database that stores images for my company. The database file
is becoming larger and larger. At the moment it is 17Gb.
I was wondering if there is a way I can split this database into two or
three files, and maybe put the files in different places. The server my
company is using is ol... more >>
Cannot start MSSQL Server 7
Posted by Water Cooler v2 at 5/13/2005 2:07:16 AM
I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing informati... more >>
Stored Proceedure: Problem adding second DateTime Parameter
Posted by James Leech at 5/6/2005 12:00:00 AM
Hi Guys
I am trying to run the folowing sp from an asp page and i get an error
(ADODB.Command error '800a0d5d' - Application uses a value of the wrong type
for the current operation.) when the script hits the line I have
highlighted. As you can see this is the second parameter of a DateTime... more >>
How can I tell if a SQL Agent job is running?
Posted by pshroads NO[at]SPAM gmail.com at 5/5/2005 4:40:53 PM
I'd like to put logic in a SQL Agent job so that it doesn't run if the
job is already running. Is there an easy way to tell if a job is
running?
Thanks
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|