I would suggest you get used to using projects and solutions and VSS.  It will take some getting used to if you have only been doing database administration, but it...

I am aware of that option and it was not set.

Working around my issue was easy, so I don't really have a problem anymore.  It was frustrating to find the problem, but that's what I get paid for.  I ran...

I tried that and it still did not solve the issue.  If I raise the error after the recordset it returned, SSIS does not seem to see the error -...

There are a lot of ways to do this.  You could be sneaky if you really wanted to use an IN:

SELECT * FROM Client WHERE ClientID IN (

SELECT ClientID FROM...

The short answer is that XML is going to be less-efficient for MSSQL than tables will be.  The long answer is the obvious "it depends" answer that you always get. ...

I have.  The OLEDB driver does not seem to have a problem with it.  My biggest SQL 7 compatibility issue is that the Lookup component in SSIS cannot connect to...

I have had this problem.  I cheated and opened the dtsx file in notepad and modified the data type of the field in the source component's definition.  Once it saw...

Dmanju is misunderstanding the licensing.  The device in question is the end-user device, not the citrix server.  This is very clearly stated in the licensing agreement that you checked off...

Just a minor point on this.  Using a scalar function in your where clause like this will force a table scan.  Since the query optimizer cannot anticipate the order of...

A good developer does not build anything they don't have to.  There are a million of freeware survey application out there:

http://www.bestsoftware4download.com/software/t-free-e-data-collection-download-gpuqueua.html

Even using a huge IN statement is a bad idea.  You have two problems - the first is that SQL 7 (and 2000 to some extent) does a bad job...

Look for partitioning views in SQL 2000 Books online.  You can horizontally split your data into multiple tables and create a view that is the name of the original table. ...

We recently purchased a similar 4 processor dual core box for a project and I spent several days performance testing with and without hyperthreading.  I found about a 4% increase...

I assume you are connecting to servers that have static IP addresses.  If this is the case, you can eliminate a lot of variables by adding the IP address to the...