And make sure your backups are on different PHYSICAL media to the database.

I've lost count of the number of organisations I've seen that partition a large raid array into different...

kevriley (8/19/2009)

---

Ian Scarlett (8/19/2009)

---

Just to add to kevriley's solution... if you use this method, don't forget to re-add any constraints and triggers you may have had on the original employee...

Just to add to kevriley's solution... if you use this method, don't forget to re-add any constraints and triggers you may have had on the original employee table.

That message means you are trying to update a view that joins to at least one other table.

I assume in your code that "tab1" is actually a view.

What are you...

Functions are used to return data and cannot (should not... some undocumented workarounds have been suggested) be used to do anything that changes the database state i.e. your UPDATE statement.

You...

Unless I've missed something, then apart from slight differences in the estimates, those plans look the same.

If that's the case, then you should be looking at the differences in...

GilaMonster (8/15/2009)

---

Yes, you would.... Especially the one that reads 'MCT'

I've corrected him elsewhere also today. I'm...

I'm a bit confused here. You have posted this in the SQL 7,2000 forum.......

If memory serves me correctly, there wasn't an XML datatype...

David is right, it works SOMETIMES. In this case it depends...

Possibly... if that's the only entry you've seen then it may be nothing to worry about. If you're seeing a lot of these,...

This is just personal preference, but I hate having databases for 3rd party applications (even Microsoft ones) on the same instance as our own databases.

The ability to upgrade to a...

Another subtle difference between SQL 2000 and SQL2005. Try this:-

CREATE TABLE #EID ( ID INT, Ename VARCHAR(10) )

INSERT INTO #EID ( ID, Ename )

SELECT 1, 'hello'

SELECT * FROM #EID...

Having just re-read my original post, I don't think I explained the Primary Key bit very well, and I don't want to send you off in the wrong direction because...

Dot a definitive answer, but a few things to think about which may sway your decision one way or the other.

One of the basic rules of designing your database is...

If you run osql without the -S parameter, it will try to connect to the default instance.

If yours is a named instance (i.e. machinename\instancename), you will need to specify this...