Archived Months
January 2003
March 2003
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
July 2007
August 2007
September 2007
October 2007
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 >>




DevelopmentNow Blog