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.
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: Upgrade Advisor Trace Files ...Compatibility 'Update' but that update is lacking some fixes to make it ...User testing has generated at least one ... turn-around time and effort required to work with the vendor is less ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... (microsoft.public.sqlserver.tools)
