Alright, so I have this problem. I want to make it easy for me and
others to be able to run a query and easily choose whether we want
Merchants or NonMerchants. Previously, we would have to comment out
bits of code and would leave things messy (it would also leave room for

Can anyone tell me how a program like this might work:
http://www.red-gate.com/products/SQL_Data_Compare/index.htm
I want to backup databases into a central repository but I only want
the records that have changed for that day. This program seems to do it

Sql Server 2005 - Server Management Studio  allows a 'contains' filter on
stored proc names ...
its easy to list all stored procs that contain  _aaa_
What is the incantation to list all procs that contain _aaa_  AND _yyy_  ??

Hi, I have no idea about SQL Server.
my first question is,
SQL server usually mean "MS" sql server. right?
Also, my second question is,

Could someone help me with the following problem?   Hours of googling
yesterday couldn't get me the answer.   I'm using SQL 2000 and DTS and
trying to import a huge fixed width text file.
File is >1m rows and >200 columns and is defined by a proprietory (i.e. not

SQL Server 2000 (DDL below)
If I try to run this code in QA:
SET IDENTITY_INSERT tblAdminUsers ON
INSERT INTO tblAdminUsers

I am a novice SQL guy so you all take it easy on me.
I am trying to run a query and one of the columns of my has values that is
referenced in another table, i.e. for EmployedStatus I have a bunch a
numbers from aother table.  I go to that table to see what the numbers mean

I have a large SQL Server 2000 database with 3 core tables.
Table A : 10 million + records
Table B : 2 million + records
Table C : 6 million + records

When detaching my db a msg came back skating that I have over 300
connections to it. I know at the moment I was the only one connected so, for
some reasons, user process ids are not recycled (or eliminated) when the
user disconnects from the db. Is this normal? If not, how do I ...

Situation: at work we have a windows 2003 server with MS sql server
2005 express. With my pc at work, I can see my own database I created.
At home. I can connect with VPN to the network. With extern desktop I
can see the database and do everything. Now I want to create a login

We’ve got database marked as “suspect” in our MSSQL Server. We found out this
when viewing it using Enterprise Manager. We are ready to forsake the
unwritten transactions in the transaction log. Please tell us what we should
do so that we can bring the database marked as normal.

I have a stored procedure that has to extract the child records for
particular parent records.
The issue is that in some cases I do not want to extract all the child
records only a certain number of them.

I don't know if this is possible, but I haven't been able to find any
information.
I have two tables, for example:
Table 1 (two columns, id and foo)

Does anyone know if there is a possibility to run a DTS with parameters ?
David Greenberg

I wanted to ask you for help as I am struggling with it second evening
already...
I have got tables DEVICES and PARTS.
One device can consist of multiple parts.