Larry Kruse (10/13/2010)

---

Thanks Lowell...I was kind of afraid that was the case. It seems kind of like it would be something that a lot of folks would want to...

ok a bit of reearch reveals a few things.the .RecordsAffected will pretty much return -1 every single time.

There is no count because the reader is streaming the results in from...

i think the reader has a reader.RecordsAffected property;

so you should be able to get the # records from reader.RecordsAffected?, right? or is that for a different purpose than i think?

well everything depends on what you want to do;

there's usually a reason why you want to audit old and new data; typically you create an audit table with nearly the...

i have this saved, which uses the old sysindexes view;

i have not updated it to use sys.indexes and whatever sys view has some index details; this might help:

SELECT object_name(id) as...

Paul one of the output columns is [IndexKB] in...

you might be mixing information from a different database system...as far as i know, I SQL Server there is not a GUID associated with the old/new rows;

you have the rows...

yeah, i switched away from SQL2000 a while ago, and all my scripts are targeted for the newer platform.

take a look at this script contribution i made for SQL 2000:

Get...

a forwarded email is beyond the control of the SQL server and sp_send_mail;

the client application which forwards the mail may add lines, headers, footers, indent everything in the email and...

also, don't you have to exclude NULLS from the underlying emails if you are using NOT IN:

INSERT INTO contacts (email, business)

SELECT email, business

FROM scrapes

WHERE (dbo.vaValidEmail(email) = 1)

AND (NOT email...

GilaMonster (10/12/2010)

---

It's more general than that. It's just about every statement.

SELECT * FROM master.sys.objects -- 74 rows

IF (1=1)

SELECT @@ROWCOUNT AS RowsAffected -- 0, because the IF did not affect...

not enough info to help so far I think, naresh;

does your MatchingOff table have 7 columns, or one column with all the values comma delimited?

you can use a CASE statement...

every insert/update/select/set/delete statement resets the @@rowcount to the rows affected by the executed statement, so it's a best practice to use a variable to capture the rowcount you need,:

begin

declare...

depends on what you want to do with it; the full text engine has the option to open and index the contents of word and pdf documents for example; if...

the easiest way would be to use the Import/Export from SSMS; before you can do that, you need to have the ability to connect from the SQL server to the...