Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Intellisense to SQL Server 2005 ?

  
   Database Forums (Home) -> Programming RSS
Next:  start and end range from multiple entries  
Author Message
Bassam

External


Since: Jul 01, 2008
Posts: 11



(Msg. 1) Posted: Mon Aug 23, 2010 6:25 am
Post subject: Intellisense to SQL Server 2005 ?
Archived from groups: microsoft>public>sqlserver>programming (more info?)
Hello,

we have SQL Server 2005 in the server , to get the benefit of Intellisense
at SSMS can I install management tools of SQL Server 2008 R2 in my PC
(Admin) and connect to 2005 instance ? will that work ? what would I lose if
I use 2008 R2 SSMS instead of 2005 SSMS ?

Thank you
Bassam

 >> Stay informed about: Intellisense to SQL Server 2005 ? 
Back to top
Login to vote
Erland Sommarskog2

External


Since: May 30, 2004
Posts: 1649



(Msg. 2) Posted: Mon Aug 23, 2010 9:25 am
Post subject: Re: Intellisense to SQL Server 2005 ? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Bassam ( ) writes:
> we have SQL Server 2005 in the server , to get the benefit of
> Intellisense at SSMS can I install management tools of SQL Server 2008
> R2 in my PC (Admin) and connect to 2005 instance ? will that work ? what
> would I lose if I use 2008 R2 SSMS instead of 2005 SSMS ?

You can run SSMS 2008 R2 against SQL 2005 without hassle. However, you will
not get intellisense when you are connected to SQL 2005.


--
Erland Sommarskog, SQL Server MVP, esquel.TakeThisOut@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 >> Stay informed about: Intellisense to SQL Server 2005 ? 
Back to top
Login to vote
Jeffrey Williams

External


Since: Dec 25, 2008
Posts: 8



(Msg. 3) Posted: Mon Aug 23, 2010 7:39 pm
Post subject: Re: Intellisense to SQL Server 2005 ? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
To get intellisense for a 2005 or prior version of SQL Server, you will have
to purchase a third-party product. Redgate SQL Prompt is one, SQL Assistant
is another - either will work.

Jeff

"Bassam" wrote in message

> Hello,
>
> we have SQL Server 2005 in the server , to get the benefit of Intellisense
> at SSMS can I install management tools of SQL Server 2008 R2 in my PC
> (Admin) and connect to 2005 instance ? will that work ? what would I lose
> if I use 2008 R2 SSMS instead of 2005 SSMS ?
>
> Thank you
> Bassam
>
>
 >> Stay informed about: Intellisense to SQL Server 2005 ? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Installed new SQL server 2005 on Windows 2003 Server Stand.. - Hi, I am just trying to register my newly installed SQL SErver 2005 Enterprise Edition on my development machine. But when I try registering I got the below error. How do we address this issue? Looks like this is some thing to do with some kind of..

SQL Server 2005 Auditing - I am using SQL Server 2005 server. There are 2 applications running on this server. Those application issuing 100 of commands daily against the database. My manager wants to see a report tht which commands issue n tht database. When i use sp_who2, it...

SQL Server 2005 auditing - I am using SQL Server 2005 server. There are 2 applications running on this server. Those application issuing 100 of commands daily against the database. My manager wants to see a report tht which commands issue n tht database. When i use sp_who2, it...

Migrating to SQL Server 2005 - Hello SQL Gurus, We are migrating legacy application to SQL Server 2005. Can anyone point me to documentation regarding minimum requirements for an application to connect? For example: do we need at lease MDAC version 2.8.

UNION in SQL Server 2005 - The query select 576 union select 6 Returns 576 6 But select 576 union select 6 union select 38 returns 6 38 576 which is ordered Why does it order only if there are more than two values?
   Database Forums (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]