I agree with colin; a master procedure to handle things in batches is a great idea....I'd question whether a user interface really needs to look at a million records, or...

i would lean towards the data not being in the expected format....maybe it's a unix based file, and contains only \r for the rowterminator and not , which is Carriage...

take a look in the scripts section:

http://www.sqlservercentral.com/scripts/Index+Management/30139/

the above is a script to reindex all tables.

it's all there:

n:Login failed for user 'sa'.

you must have mis typed the password. reenter it, and if permissible, run it right now on demand, instead to confirm it runs.

you had almost everything you need...you simply want to sub select:

SELECT * FROM CustomerRecords

WHERE SSN IN (SELECT SSN

FROM CustomerRecords

GROUP BY SSN

HAVING (COUNT(SSN) > 1)

) X

ORDER BY SSN

it's not blindingly obvious, but in QA when you do a SELECT INTO statement, to dynamically make a new row, the table that gets created from the data is created...

sure you can, you just have to raise the error yourself:

begin

[logic for determining if an issue appears here]

declare @err varchar(400)

set @err='Transaction (Process ID ' + convert(varchar,@@spid) + ') was deadlocked...

Ironically, the error given is the answer.

error numbers belwo 50,000 are reserved, and can only be raised by the SQL Server engine. you can read the list of error...

when run in QA or anything like that, yes only column names appear...the rest is hidden.

when placed in a client side data table or ADODB.Recordset. the attributes like data type,...

here's a find and replace for a TEXT field in SQL 2000;

in this example, i'm replacing a relative link with a full link, so it's a good example:

DECLARE @reviewid int,...

you mean like a substring?

declare @sample table(col1 varchar(10),Col2 varchar(30) )

insert into @sample

select '.com' ,'www.whatever.com' union

select '.net','www.whatever.com' union

select '.net','www.whatever.net'

--charindex [string to find], [column or value to find...

in TSQL, it's simply setting the SET FMTONLY ON/OFF setting; it returns the datatable with no rows, so it can them be displayed with whatever the column definitions are;

CREATE PROC...

just be sneaky and rename it twice then...that should fix it:

sp_renamedb [HR_TRACKING ],[HR_TRACKINGTMP]

sp_renamedb [HR_TRACKINGTMP],[HR_TRACKING]

there s a stored proc just for it; you'll get an error if anyone is connected to it when you try to rename.

sp_renamedb [old name with spaces],[newname]

I believe the issue is that the server has not been set up to allow remote connections (what we used to call mixed mode in sql 2000, right?)

i think you...