Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote -2 down vote favorite

I am novice to SQL Server and Database also.

we have SQL Server 2008 installed on server.

I want to run queries from remote computer on the database which is resides in SQL Server 2008.

I want know that is there any tool/utility so I can install it on my local machine and run queries over database server.

Any alternate approach would be helpful.

share|improve this question
3  
You mean another tool than MS SQL Management Studio? – juergen d Apr 13 '12 at 11:24
yes. is there any available – Vikramsinh Shinde Apr 13 '12 at 11:25
2  
yes. millions of tools. try a simple gooogle search. – juergen d Apr 13 '12 at 11:27

closed as not a real question by juergen d, marc_s, Jeremiah Willcock, casperOne♦ Apr 14 '12 at 12:54

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers

up vote 3 down vote accepted

If SQL Server 2008 is already installed in the server that you want to run the query you just need SQL Server Management Studio (Query analyzer). Just create a connection with the server and you will be able to run any query.

You can take the control of the server with other tools like TeamViewer and run queries with sqlcmd (from command prompt), query analyzer, or any others like queryexpress and many others if you want.

share|improve this answer
up vote 1 down vote

Use SQL Server Management Studio and connect (By the name or IP of your server) to your remote server and run your sql

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.