SQL 2005 SP2.  When I try to import a table from one server to another
using SSIS, the table imported on the new server does not have the
primary key which exists on the source table.  Help please.  Thanks.
Raziq.

I have a statement that looks like this and runs incredibly slowly
(over 3 min to return data):
SELECT
<columns>

 Can someone confirm this is a feature of SQL 2000 which was fixed/
changed in 2005
Get 2 query analyser windows, do setup in one of them as below
-------------------------

If I have 2 tables:
Table testamount
orderID | amount
1       | 20

I need to Create a table called ‘Tracker’ with two columns.
The first column will be CustomerID, an nchar(15) field, while the
second will be UpdateTime a datetime field. Using the Customer table
in the my database, create a trigger that will insert a record into

Against my better judgement I have been thrust into the duty of
creating Crystal reports for my company.  I have discovered rather
quickly that I also need to become familar with SQL (creating views
and stored procedures).

I use Sql Server 2008.
1. After I truncate a table, is it necessary to recreate it's keys and
indexes ?
1. Is it necessary to run "DBCC DBREINDEX" to reorganize a table if the

I need a way to intercept and modify SQL statement with parameters
sent by .NET application.
It should be transparently, I mean I don't want application to be
recompiled.

We were just informed that we have to use SQL Server (Enterprise
Edition) for our projectinstead of Oracle
.
Which version 2005 or 2008 do you suggest is best for stability,

I've got databases (both SQL Server 2000 and 2005) wherein an ID column is
used in many tables. I now need to extend this field from nvarchar(20) to
nvarchar(32). It's nvarchar since it contains both numbers and letters.
How do I go about this?

I'm new at SQL Server 2005, and am having quite a number of problems
with blocked deadlocks at the moment.
http://www.sql-server-performance.com/tips/blocking_p1.aspx says that
"By default, blocking locks do not time out. The waiting connection

The With statement below , Im new To this..and need a little help
understanding what is going on here..
the below does show all the rows in a Group or Records based on a Group key.
Im looking for duplicates

I am trying to count averages for a date range. The amount of data and
data nature is highly dependant on the day of the week, so just
averaging all records together would skew my results, as queries are
typically covering a month at a time. I need to get averages per each

This is in an ASP script, as I try to get unique classcodes
(StudentClassCode column) in the StudentData table.
Doesn't matter what I try in ASP, it stubbornly says Incorrect syntax near
the keyword 'Select'.

Hi, I have a table that contains order information,  each row contains
information about a detail item that's been order but the key is OrderID
and LineNumber.
I'm trying to insert information into the table from another table but