Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Using 3rd arty clients for sql server 2005

Author  Topic 

Kimi86
Yak Posting Veteran

79 Posts

Posted - 2012-03-15 : 13:36:56
I have been working with SQL Server 2005 since 2 years and have always used SQL Server Management Studio to access it. I am in a new project and here they use SQL Teradata Assistant to access SQL Server 2005.
Though I have been able work my ways around I have noticed some t -sql commands like "print" and "go" do not work.
I want to know and convince my new team to get sql server management studio to work with SQL Server. Hence I need to know the cons of using the new tool instead of SQL Server Management studio.

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-15 : 15:25:28
my guess it's in 1 unit of work...and print probably doesn't return data

And if they have SQL Server, the already DO Have SSMS



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

LoztInSpace
Aged Yak Warrior

940 Posts

Posted - 2012-03-15 : 22:35:29
Have you considered that you are taking a very short-sighted approach? You need to gather the pros and cons of both tools and make an informed choice for *you* as well as your colleagues. Your request right now reads "I do X, they do Y. How can I convince them to do X because I prefer X". Not much of a case.
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-03-15 : 22:43:34
Why does it matter anyway ?

They can use their own tool, you can use SSMS and i will still use Query Analyzer to write all my query in SQL 2000, 2005, 2008


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

Kimi86
Yak Posting Veteran

79 Posts

Posted - 2012-03-15 : 23:05:16
Thanks everyone .. I had never though SSMS to be different from Sql Server.. So when I was given this new tool, i got pretty confused. I get the point now..
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-16 : 11:49:31
I've heard people using DBArtisan...never Terrible Data Ass to do this work..but that's just me

Stick with the Microsoft Products for Microsoft

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -