Posted by Erland Sommarskog on 02/07/07 22:51

Wes Groleau (groleau+news@freeshell.org) writes:
> I'm not trying to be obscure--it's just that (1) I don't have access
> to that system and Usenet at the same time and place and (2) the table
> definitions were done with the GUI and (3) I couldn't get the scripting
> to work. (I've done it before, but this time it asks for a filename and
> then doesn't create the file)

As I've said you can script from Query Analyzer as well.

And I am sorry, but I don't feel inclined to come with further
guesses without the error messages you are getting. Nor am I interested
in composing queries and then only hear "it wouldn't take them". I
understand that it may be difficult for you to bring the information
from one corner to another, but it is even more difficult for me
who don't even see the queries. And after all, copying an error message
from one corner of a room to another is not rocket science. Pen and
paper still works...

>Not sure what is meant by "linked" but when I start QA,
>I leave the server choice on "(local)"

A linked server is a remote data source, which is accessed from SQL
Server in a distributed query. The linked server can be another SQL
Server, but can also be an Access database, Oracle database, Active
directory or anything else for which there is an ODBC driver or OLE DB
provider.


--
Erland Sommarskog, SQL Server MVP, esquel@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

[Back to original message]