Re: Compatibility Level

Thanks Ekrem

"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:556BCA38-00F9-42EE-B27D-7C979B3AD3E2@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxx> wrote in message
news:Oe2cc1J8HHA.4712@xxxxxxxxxxxxxxxxxxxxxxx
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'.












.

Relevant Pages

  • Re: VS 2005 - Server Explorer - Diagrams - Invalid DBO User
    ... > What I meant was that you could set the database compatbility level to 90, ... > use the diagram tool and then reset the compatibility level back to 80. ... >> you saying that "you can always set it back to the orginal compatibility ... > If your requirement is to use the database on an instance of SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Serious .NET Problem?
    ... Given their track record of compatibility, ... using ADO.NET to run T-SQL or a Stored Proc to help work around the bug? ... For help on SQL Server specific stuff, ...
    (borland.public.delphi.non-technical)
  • Re: Installing SQL Server 2005 on a PC that has Visual Studio 2008
    ... getting rid of VS2005 and moving to VS2008 and it worked well, but as a large organization we had all our production databases on servers running SQL Server 2005. ... The overall planning - in terms of compatibility and future vision - seems poor to me. ... >> Rick Byham, SQL Server Books Online ... >>> What do I need to do to install ss2005 BIDS so I can master SSIS ...
    (microsoft.public.sqlserver.clients)
  • Re: Access 2003 or 2007 Compatible with SQL Server 2008
    ... Sylvain Lafontaine, ing. ... Did you finally try it in this way: Access 2003 with SQL Server Express ... 2003 and upgrade our SQL Server to 2008? ... Our biggest concern is the Compatibility ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Compatibility Level
    ... 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. ... MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT ...
    (microsoft.public.sqlserver.clients)
Loading