This link seems to instruct on how to "freeze" column headings on a report:

http://msdn.microsoft.com/en-us/library/bb934257(SQL.100).aspx

yes, make sure you are not waiting on the file to grow. Create the file at a size that will accomodate all of your data and allow some room...

I am going and I hope that I got in on the SSC party.  I registered for the conference in January and I am not sure if the code got...

No to more Visas and yes to more accessable education.  If bill wants more workers then he should train up the people we have here already looking for jobs.  For...

Okay this is great up to a point.  I placed the development team in this role and they are quite happy to see the jobs and jobs history.  Now the complaint...

Yes, the date field does not include a time component.  The duplicates are identical.  The credit card payment data has far less chance of duplicates than another extract we have,...

As strange as it may sound, people make multiple payments for the same amount on the same day to the same account. 

Yes, I think your all catching on now.  The discussion is really about uniqueness in tables not programatically setting a PK. 

One of the tables in question contains payments customers...

This is awsome, thanks for the valuable tool!

Do you understand that my dilema is that it is being suggested that the table does and should contain duplicate rows?  I understand that there are several ways to enforce...

I am being told that there is no benefit to having a primary key defined, especially a surrogate key of identity if it is not used in joins. 

We have...

Thanks for the feedback everyone.  We are going to give a try.  Since everyone is sharing the size of their backups I will divulge that we are packrats and are...

I went through the same thing.  The website suddenly doesn't list prices and from memory what they are quoting is twice as much as I expected.

What gives?

Thanks for the response. 

So, you would say that since the query is run on the remote server the impact to the server that the link is configured/invoked from has...

I ran into this exact situation a couple months ago.  Before you can add the user to any new access or change any existing acces you must completely remove her...