Adam,

Haven't taken it, but pass percentages seem to be about 850 or so and the # of questions is usually 52. I took the 444 exam and it was standard...

You can also use the FileSystemObject in DTS (ActiveX) task to do this.

I think you can make this person an owner of the dbo schema as well.

Search this forum and the MS one and you'll likely find some interesting problems to solve. There are also a few DTS articles on this site you can read.

I tried it years ago in the floppy era and it worked a few times for me. Haven't messed with it since then.

sp_help_revlogin from Microsoft. Search for it there for 2005. I think we might have the original version for 2000 here.

Yep, saved it: http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1711

The syntax changed slightly for 2005.

Use this on...

Jeff's got great advice here and I agree with him. If this server is used by a few people it might be ok, but 1GB of RAM is pretty low....

Biggest thing for me is on-site shower. Nice to be able to run/bike/basketball/soccer, etc. and get clean after lunch.

Sorry, I know I saw it somewhere, but I must have grabbed the wrong URL. Still looking.

Sorry for missing this the other day.

We did it by creating two tables. One for things you add from the site and one for things we add, like purchased products....

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