Create Snapshot Error Message

[Catadmin]

Anyone else find this annoying?

I wanted to prove to someone local that you can't do a snapshot on a SQL 2000 database even though it's connected via SSMS. So I wrote up the "Create...As Snapshot..." code in SSMS and got the error:

Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'AS'.

What the heck?? Shouldn't there be a clearer error indicating that you can't do snapshots on a SQL 2000 database?

Or has anyone else been able to do it and I'm just blowing smoke?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ptheriault]

I get the same error message and I am going to assume it's because SQL 2000 doesn't recognize the keywork snapshot. So you get an incorrect syntax error.

- Paul
- Database performance looks fine, it must be the Network!

 

[mrdenny]

SQL 2000 can't tell you that you can't do a snapshot, as it has no idea what a snapshot is.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com