You can either uninstall Express, or install Dev Edition as a second instance. Personally, I'd uninstall Express.

blandry (12/16/2009)

---

I hate to throw a whine at you, but your post presumes that all over the world a DBA can be measured to have the same basic skills from...

Adam Gojdas (12/16/2009)

---

Using a DROP/CREATE with an IF EXISTS clause instead of an ALTER statement for deploying SQL Server objects like stored procedures is one example of a standard that...

Bru Medishetty (12/16/2009)

---

Even if you have no 3rd part tool, you can find what's going on with the databases. You have Activity Monitor start there, look if you have any...

CirquedeSQLeil (12/16/2009)

---

john.arnott (12/16/2009)

---

CirquedeSQLeil (12/14/2009)

---

Alvin Ramard (12/14/2009)

---

GSquared (12/14/2009)

---

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha...

Take a look at Try Catch in Books Online. It has all the details.

Basically, errors with a severity below 11 won't fire off the Catch block. Errors 11...

Can you provide the table definitions and some sample data for the current tables?

From what you're describing, it seems like the whole thing could be simply a few joins and...

Lynn Pettis (12/16/2009)

---

Also regarding the company providing training; it's nice when they do, but in the end it is up to us to keep ourselves current and relavent in our...

Thank you.

As for the comment about MS: Trust...

I've used Apex SQL Edit. It works. Might do what you need. Haven't used TOAD, but from what I've heard, I'm probably not missing much.

Grant Fritchey (12/16/2009)

---

GilaMonster (12/16/2009)

---

As far as I'm aware, what's in the log is the uid, the database user id. If the person who deleted the data was a sysadmin, that'll...

Computers are becoming easier for end-users, not for DBAs. For us, it gets more complex all the time!

This site had a series of articles last year (I think it...

You don't have to convert/cast the data. Use "type" in the For XML clause.

select (select 1 as Val for xml raw, type);

If you don't use "type", it comes out...

Not a problem. Easy mistake to make.

The "success" block IS the try block. If something succeeds in the try block, it just moves on to the next command.