Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Question Unanswered: Connecting to sql 2k thru sql 7 EM

    Can I connect to SQL server using sql 7 EM? currently it is not allowing me
    to connect, but some one told me that there is a work around.Anyone heard/aware of it?

    Regards,
    Harshal.

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Are you really sure there is a workaround ??? Maybe it might be possible if the database server is running in 7.0 compatibility mode ... just my guess though
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    I don't know actually
    my project manager said there is a way to connect to sql 2k using sql7 EM our previous DBA used to connect .
    But as far as I know, every time sql dmo when connecting, checks for the verison and so doesn't allow to connect, so I don't know about any workarounds, so was just checking out with u guys if there really exists any workaround.

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    I think my guess is wrong
    As per the holy book :

    In SQL Server 2000, the master database has a compatibility level of 80, which cannot be modified. A database containing an indexed view cannot be changed to a compatibility level lower than 80.


    So I dont think that can be done ....
    Unless Brett differs ;D
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •