Someone correct me if I'm wrong, but I think you'll need to break your replication first, then drop and recreate the clustered index, then apply the snapshot and resync.

As an option, I don't think this would be a bad thing, but for some, it could become a crutch.

Before I start a restore action, I always triple-check all my...

I think you will need to load each line into a single column in a staging area, then split or parse out what you need from each column.

Normally, ETL type...

select LOGINPROPERTY(name,'passwordLastSetTime') from sys.sql_logins

You could trace what the script generation wizard executes.

You have a theory that you are running out of memory. Before you take any action, I would be certain that is the case. I don't see how...

What does your SQL error log say?

Sounds like a job for ROW_NUMBER() OVER (PARTITION BY), but I don't think that is available in SQL 2000.

You should try "WHERE EXISTS" instead of "IN".

Also, INTERSECT and EXCEPT might be better if you can't use EXISTS.

The easiest thing to do here is to display your query (using select or print) to verify it is what you expect before executing it as a query.

DECLARE @Col1 int, @Col2 int, @Col3 varchar(10)

DECLARE Molases CURSOR FOR

SELECT Col1, Col2, Col3 FROM BufferTable

OPEN Molasis

FETCH NEXT FROM Molases INTO @Col1, @Col2, @Col3

WHILE @@FETCH_STATUS = 0

BEGIN

EXEC spProcessMolases @Col1, @Col2, @Col3

FETCH...

Are you wanting to execute the stored procedure for each row in the table?

I'd rather stick needles in my eyes, that will be agonizingly slow.

Or are you trying to pass...

I would add an index as Cory suggests.

WITH DupCheck AS (

SELECT ID, COUNT(*) [COUNT]

FROM dbo.test_data

GROUP BY ID

HAVING COUNT(*) > 1

)

SELECT DupCheck.ID, Address, StartDate FROM DupCheck

LEFT JOIN dbo.test_data

ON DupCheck.ID...

sys.all_sql_modules

You could

select * from sys.messages