Re: Compatibility Level

#1

Thanks Ekrem

"Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote

Quote:

Hi Rogers,

You can not create a Master Key in SQL Server 2000 because it's a new
feature of SQL Server 2005.

You can not see 90 compatibility, because you are connecting to SQL Server
2000 via SQL Server Management Studio. Your 80 compatible database is
still on SQL Server 2000 that's why you can not convert it to 90. First,
you should Backup and Restore or Detach\Attach or Copy Database to your
SQL Server 2005 server. And after this operation, when you check it's
properties\options you will see 90 compatibility in the compatibility
list.

--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT

"Rogers" <naissani (AT) hotmail (DOT) com> wrote in message
news:Oe2cc1J8HHA.4712 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Dear Professional,

Attached is the screen shot, I can't see compatibility level 9.0 in SQL
Server 2005.

I am using following commands

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'EncPassword'
It gave me following error:

Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near 'MASTER'.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Compatibility Level

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Compatibility Level - 09-05-2007 , 11:30 PM