After loading the BCP files that are created during the trigger/
reporting events I've noticed that the data in the table is missing
records. I've also noticed that the missing records (records in the
table but not in the BCP out files) seem to occur in contiguous

After loading the BCP files that are created during the trigger/
reporting events I've noticed that the data in the table is missing
records. I've also noticed that the missing records (records in the
table but not in the BCP out files) seem to occur in contiguous

Can someone help me with an advanced query?
I have two tables
Table 1:  Employees
Cols: UID, lname, fname

i have a bunch of dts packages..from sql2k
is there a utility  to convert them to sql2005
any suggestions
dave

I am trying to join these two select statements into a single result
that would look like the following:
Ticket Number, Issue, Email
meeting this criteria from table "job_ticket" WHERE

I'm trying to update an older table with some new information. Our
previous systems stored US state info by their abbreviation, now have
a state table and link with the appropriate state id. I would like to
update the old table to our new system so set a new field called

I have an ancient preCambrian app that uses the db library to interface with
sql server databases.
It is written in c++.
When testing it I noticed on one machine with sql server 2005 installed it

I'm having difficulty searching for an answer to this challenge. Can
someone give me a clue on the right keywords to use to find a
discussion on this subject? All of the ones I saw appear to touch on
older versions. I'm working with SQL Server 2000, and need to backup

I have my first small SQl Server 2005 database developed on my local
server and I have also its equivalent as an online database.
I wish to update the local database (using and asp.net interface) and
then to upload  the data (at least the amended data, but given the

I'm running into a constant issue of SQL Server modifying the
millisecond part of a timestamp insert from another application. The
application inserts timestamp which includes a millisecond portion as a
string (varchar). But when an SQL Server moves this data to another

I have this problem occuring intermittently:
When I try to add a package to the project, and click on the Package
path button.  I get a oledb error x080004005 (client unable to
establish connection)...

I am running SQL2000. Can anyone tell me how I can use the contents of
a table as parameters for a stored procedure that resides on a
different SQL server?
I have a table:

In my asp.net application I have a local report with an image control in the
detail row of the table and the Value attribute set as
="File://" & Fields!FQPhotoFileName.Value
The first row in the table always shows the wrong image and it's always the

We are trying to use source control to store our database objects and
queries in Perforce. The general idea is to produce scripts which
create all objects in the DB and then store the SQL in source control.
Has anyone done this before and can suggest some advice? Alternatively

I got got a pile of bad email addresses to update in our SQL database.
I know how to do this for individual records using the update command.
Is there a way to execute an update using the list of addresses in an
excel spreadsheet or some other form of list?  This kind of scripting