i would bet it's the SET NOCOUNT ON thing; the adodb recordset can get the  12 records(s) affected as the recordset to return, unless you explicily say set nocount:

ALTER...

you should be able to use regualr expressions to strip out either rtf or html;

you can do it within an app or client side in vb or .net, but for...

if you switch to HTML view in the textbox where you type your comments, you'll see that when typing directly into textarea, the ENTER key ends up creating a <P>...

i would suggest some of the utilities from Redgate or idera that can present all changes in script format by reading the transaction logs.

it's full featured and would probably cost...

can't you still use the standard driver for SQl server to connect to a SQL 2005 database?

indexes are used by the server to find data faster.

I doubt you might want the server to get the data slower or less efficiently.

in a complex query, you might add...

dunno if this is it, but i've seen a simialr situation:

Device activation error. The physical file name 'E:\WSUS\SUSDB_log.LDF' may be incorrect.

you would get this error if:

the folder path to create the...

If you could send me the proc, i could convert it to TSQL no problem.

just guessing, but the whole SQL is full of inner joins... so that means if one of those tables in all the joins do not have a row to match...

a widget like that would be handy for me; I often have to find schema differences between a client db and the expected schema.

with sample data, in QA, it works fine....i agree. it has nothing to do with the quality of your SQL/procs.

but in the real world application, your data is returning no...

your error is on the vb handling side....

ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed.  "

this error occurs if you refer to the recordset in vb...

oops sorry

I beleive you assigned the user in question the following roles:

db_ddladmin

db_datareader

db_datawriter

because of the ddl_admin role, the user can create objects for him to use himself, hence the objects are created...

i searched for "pivot" here on SSC, and found a number of script contributions; you should look at those as well;

this link looked promising: http://www.sqlservercentral.com/scripts/contributions/1038.asp