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

i would fix the table and extract the foreign key, and then add the constrant back tot the table fix the design that is preventing you from doing the right...

A named instanced exists side by side your SQL2000 "default" instance. During the installation process ,If you select default instance, you will overwrite your SQL 2000 instance..(that's in the "bad...

Isn't it true that whatever version of SQL 2K you have the disk for, if you are running a non-server version operating system, it installed as the developer version anyway?

so...

you might consider pinning the tables that the procedure is calling; If the data is pinned and in memory, you'd avoid the wait time while it goes to disk; I...

i wanted to do the same thing...you can't; you'll need to save all your data/backups,uninstall the old instance, and then install a new instance witht eh new "correct" name, and...

the index info is dropped as well, so the indexex add new values with your inserts:

from BOL: TRUNCATE TABLE immediately frees all the space occupied by that table's data...

it looks like you just need to add a WHERE statement to the end:

SELECT Maintenance.[No],

Maintenance.[File No],

Maintenance.Company,Maintenance.[Name] as [Employee Name],

Maintenance.[Description],

v2.[Date],

v2.[Comment] As [Status]

   FROM Maintenance

   LEFT JOIN (SELECT...

i think it's just the missing SET command for an Object; otherwise your syntax is exactly what i use.

SET param = command.CreateParameter(paramName, adCurrency, adParamInput, 8, value)

otherwise it might...

why not use Jeff's function as a calculated column?[edit--on rereading, that is exactly what remi and david said..i just provided the example sorry]

DROP TABLE X

CREATE TABLE X(XID INT IDENTITY(1,1) NOT...