Carolyn,

That's interesting. I've only had a few datbases over 200GB, but I've never seen this issue, even on W2K. It seems like a file handle thing, which could be an...

It's actually a weird issue in the forum code. There's a mem leak somehwere, so we were restarting the app pool every hour. I backed that down to 4 times...

Bulk load the data into some staging table and then move it over a few rows at a time.

the other thing is to examine the triggers and ensure you're not...

select @projectcode = @projectcode + '0001'

In the second example you are directly returning @projectcode+'001' and having the output column named ProjectCode, not assigning the variable.

Or set a performance alert on this counter.

Interesting thread and I'd love to get a writeup from any of you to share with everyone on how the rollout goes (or has gone for any of you) and...

Interesting points and thanks for the comments.

I know most of us live in the world of < 1TB databases and actually it's prob < 100GB for the vast majority. A...

No separate windows in SSMS. It's a pane (and pain) in SSMS only for queries.

You can still connect with QA, but the object browser only partially works.

You can also rename the northwind and pubs dbs and let them come up suspect to get SQL to start.

The update has to apply to specific rows. You are using a where exists() clause, which returns a true or false, not a set of rows.

What you need to do...

Do you have an exceptionally large log? Or is this server low on memory?

I've not seen this before.

If you issued a BEGIN TRANSACTION, you must manually commit, but Antares686 has given you a good explanation.

Also, are you getting log full messages? Or do you just see the...

I believe you need to be the table owner, db_owner, or ddl_admin to alter a table.

I don't think moving the system databases is a good idea. It can work fine, but if you have issues, then it's hard to recover.

Easy to reinstall, then move DBs...

It's a strange session issue that we've seen with some people. Can't reproduce it here, but it seems to be an issue between the ASP and ASP.NET sessions.

Steve