I have a SQL query in a stored procedure with "select distinct ..." query.
Retrieves large data.
I want use paging results. I use Sql server 2000.
Any help, please ?

I am fairly new to SQL and have run into a problem where I need some help.
I have a  test MOSS 2007 installation that is running on SQL Express and I
wanted to upgrade it to SQL Enterprise.  I used the SKUUPDATE=1 switch
making sure not to select the default instance and to select ...

we inherited a 2003 dc that has Exchange 2003 , SQL 2000 installed.  We want
to demote this machine and understand what has to happen with Exchange in
order to do so.
I wanted to know if/how SQL will be affected by the demotion and if there

I have a query with a bunch of SUMs in it, GROUPed by a variety of
columns. I've been asked to convert for FX, which is easy enough...
someNumber * ISNULL(oneFX,1)/ISNULL(otherFX,1)
Even though the numbers are used as a combined figure, to use them I

All,
I need to copy a database schema and configuration tables. I don't want to
copy our customer data. Is there an easy way of doing that I've tried a few
things but I was hoping someone has an easy way.

I would like to ask those of you, who are SQL Server admins.
Our software product creates a database and all tables that are needed for
this product to work properly.
In the previous versions, our product installer just deployed database to

I had to kill a SS2008 bcp-in because of space issues with the log file
device.  I believe the bcp had actually loaded the rows but had moved-on to
creating the Clustered index. The flat-file had 147,000,000 rows @35 gig. It
is my understanding that bcp loads the database pages ...

Hi there is it possible to connect a SQL 2000 server as a linked server in
2008?
I'm getting SQL Server Error 65535 when I try.

I have upsized an Access 97 database to sql server 2008 using Microsoft SQL
Server Migration Assistant 2008 for Access. Migrated tables were linked to
the Access 97 database front end by the Assistant. Most of the tables have
migrated fine. However, a handful of tables when opened ...

I am trying to configure SQL 2005 September CTP (9.0.1314) to mirror
its database to another server, taking advantage of the Witness sever
feature.
I go through the configure security wizard and correctly fill in the

If I have set up an enpoint like so:
CREATE ENDPOINT [MyFirstUserConnection]
STATE = STARTED
AS TCP

Does Microsoft has similar tools like Red Gate SQL Compare to compare
schemas between two databases?
Thanks,
Lijun

I have a table with columns like this:
UserID  Date     Data1 Data2 Data3 ...
User should have data recorded every day (once a day)
Now, given a start date and end date, I need to find all the missing

I need to store different languages of text in a single column as nvarchar.
When selecting text from this column targeting a particular language, I wish
I get the results sort by meaning dictionary order. One way is to append a
collate clause with the appropriate collation.

In SQL 2005, is there a way that I can script out the entire database, so
that it  contains all the create scripts for all the tables, views,
constraints, functions, procedure in the right sequence. Also is there a way
that I can script out data , so that after I create the ...