help on query from management studio.

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

Script Library

help on query from management studio.

Author

Topic

mcupryk
Yak Posting Veteran

91 Posts

Posted - 2011-03-04 : 12:56:46

I would like to do a query from sql server management studio.
Do output the tables and data to somewhere.

For some reason I don't have access to copy database or script to.

Any help would be awesome.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-04 : 13:08:40

You'll need to provide better information. For instance, we need to know what "to somewhere" is. Is it a file? Another SQL Server? ...

And "for some reason" isn't enough information for us to know what problem you are having. Are you getting an error when you use the import/export wizard in SSMS? If so, what's the error?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-04 : 13:08:58

And what access do you have?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2011-03-11 : 06:38:48

unless you have full access to the database you cannot generate scripts for the database..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources