What are the challenges you face when working across database platforms? Take the survey

SQL Prompt and multiple versions of sql server

pachen11pachen11 Posts: 3
edited March 16, 2010 5:32PM in SQL Prompt Previous Versions
I have sql server 2005 and sql server 2008 instances installed. Sql prompt works on sql server 2008 but not in sql server 2005. How can I make it work in sql server 2005 (if it can only work for 1 of them at a time, I'd rather have it available in sql server 2005).


  • Options
    Hi there,

    Can you confirm, are you using SSMS 2005 or 2008?

    SQL Prompt 3.9 from what I can remember should cache each DB that you connect to, up to a limit, therefore if you connect to a 2005 DB through either SSMS 2005 or 2008, it should then cache and you shouldn't have problems of it not working.

    You can of manually refresh the cache using CTRL + Shift + D once you are connected to a DB too which might help.

    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
  • Options
    Thanks Pete,

    I was using ssms2005 to work with databases on sql server 2005 servers and ssms2008 to work with databases on sql server 2008 servers. As you pointed out, there's no reason I can't use ssms2008 for both... then I'm happy.
Sign In or Register to comment.