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...

two ways to tackle this: a computed column is my suggestion, but you can use a trigger if you want to:

create table xample(xid int identity(1,1) not null primary key,

rateofpay money,

bonuspay...

actually, I was sitting around playing with a schema generator program, and because i had too much time on my hands, I wondered if whatever SQL uses was exposed or...

if EM was open when you imported the key, the changes would not show up...whem EM closes, it overwrites the keys with it's running configuration....

you need to make sure EM...