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

i guess i'm confused a bit.... this works perfectly on my machine; let me explain a bit:

enterprise manager looks on the local machine for the key we exported....

so when i...

register your servers, and then call regedit.

browse to this key:

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group]

you'll see all the servers you registered; simply export that key.

to test, delete the key...

while TOP doesn't allow a variable in SQL2000(but does in 2005) you can use rowcount instead for the same results:

drop procedure pr_search

create procedure pr_search(@limit int=0)

as

--rowcount of 0 = all,

--rowcount of...