I'm not sure this is a supported upgrade. It may be, but you should be able to install ss2k5 and then attach or restore your databases on the new instance....

What is "nesting"?

It's

FROM Inventory AS I

INNER JOIN Block AS B

ON I.BlockID = B.BlockID

INNER JOIN Phase...

I believe it writes to one at a time, though there are multiple threads, one per file. So if you have a large or open tran, it could be writing...

You are trying to add all the rows from table2, some of which have the same firm, or PK, in Table 1.

You need to do this as two statements.

update table1

...

you mean

select *

from tableA

where cola = case when colb = 'b' then 1 else 0 end?

You can, but if you explain what you're looking to do, we might...

Workgroup. We run 4 machines in a workgroup here with ss2k5 accessed by all of them (it's on one of them).

Standard edition

A few questions:

- Can you post the schema?

- What did you try? and what was the error?

You need an index and a PK. Probalby more than one index. You should...

Thanks and I doubt my friend is reading, but I'm glad I appeared to reach a few others.

Good ideas above and I'll add my favorite. If someone grabs you and...

It could be permissions or some config with this being created.

If you log in as the user (SQLAgent), can you run this as a DTExec command line? Can you run...

Be sure you know your ANSI_NULLS setting.

In accounting you need to know what to do with every value. There are times that you don't want a zero, so a null...

You need to read in Books Online on creating users and logins. Look up CREATE USER and CREATE LOGIN

You can only have one user per login in each database as...

If you are doing this in a dev world, two ways:

1. Let them create objects and then "mark" them for dbo status. They do this by dropping the object name...

Litespeed does it, since I've had smaller, GB sized dbs, I use sql_er's method. Restore on another server or a new db, copy data over.

In SQL 2000, the "version" field will change on alters. May change on a few other index things, but alters for sure. You can track this

http://www.sqlservercentral.com/columnists/sjones/20010423065956_1.asp

Doesn't give you a date...

No way I know of to set an alert on this.

What I've done is store the object list in a table and then run a job to compare current...