Is there a way around this?
I have a SQL 2005 with 8 GB of memory that I want to set AWE on.
But the local security policy won't let me, it says:
This setting is not comaptiple with computers running Windows 2000

I'm using SQL 2005 to export data. I would like to use the bcp utility
to export data to an Excel file.
I have to generate quite a few files and the names are dynamic. The
ideal would be to loop through records in a stored procedure to create

Env is ms sql server 2000.
ddl:
create table srchPool(tid int primary key, taid int, s tynyint, uid
tynyint);

need the concpet of load balancing cluster ?
can any one help me out with any link....?

I am struggling with a simple query, but I just don't see it.
I have the following example table.
Table Messages
ID  Subject  Reply_to

I have an imported table that contains three text columns, day, month
and year, each of which may have leading spaces or be zero.
I have successfully written a query to combine them into a new
nvarchar(8) column format YYYYMMDD but would like to then make it a

I am running this query to an sql server 2000 database from my asp
code:
"select * from MyTable where
MySqlServerRemoveStressFunction(MyNtextColumn) = '" &

Far below (in section "original 3 steps"), you see the following:
1. a temp table is created
2. some data is inserted into this table
3. some of the inserted data is removed based on a join with the same

Here's my issue.  I'm tracking product interest so to speak.  Each
time a user clicks on a product the userid, product id, and date is
tracked.  Now users usually look at their products of interest several
times.  So everytime they click the same product it is tracked as

Hi, I use SQL Server Enterprise Manager for MS SQL Express and i want
to change the column properites for [int]
type of column, but I cann't change it.
More in details...

I have one question about many "or" operation make system choose
incorrect index
There is one table TT (
C1 VARCHAR(15) NOT NULL,

I'm completely lost why a trival task in VFP is a lengthy drawn out
process in SQL Server
For Example
A simple select statement where I want to return the most current date

I have this problem.
My software creates a temporary table (#MyTable).
This table should be used by a report engine and printed each time with
different "order by" clause, depending on some parameters (and the program

Dear Gurus,
I have table with following entries
Table name = Customer
Name      Weight

I think this question has been asked number of times. However, I am
looking for some specific information. Perhaps some of you can help
close the gap. Or perhaps you can point me towards right direction.
Perhaps this group can help me fill in ms-sqlserver related following