newbie question describing tables

How can I print the structure of a table from Enterprise Manager?
Or is there another app that has a print option?"MacKenzieMouse" <no-spamkeyconc@.yahoo.com> wrote in message
news:JrmdnX6w396rZ2XcRVn-1w@.comcast.com...
> How can I print the structure of a table from Enterprise Manager?
> Or is there another app that has a print option?

You can create and print database diagrams in EM (right-click Diagrams, New
Diagram), or if you use a third-party data modelling tool (Erwin,
Embarcadero etc.) then it would be able to do the same thing. If the CREATE
TABLE script is good enough, then you can generate it in Query Analyzer
(right-click a table in the Object Browser), then print the resulting
script.

Simon|||To print the structure of a table from Query Analyzer just print the
ouput of EXEC sp_help 'table_name' or a query from the
information_schema.columns table.
--
David Portas
SQL Server MVP
--|||David Portas wrote:
> To print the structure of a table from Query Analyzer just print the
> ouput of EXEC sp_help 'table_name' or a query from the
> information_schema.columns table.
> --
> David Portas
> SQL Server MVP
> --

How do I print it ?
Is there any way to do that using the Query Analayzer ?|||Select the Text ouput option (CTRL+T), run the query, select the
Results tab then File/Print or CTRL+P.
--
David Portas
SQL Server MVP
--|||Works great! Thanks !|||MacKenzieMouse wrote:
> How can I print the structure of a table from Enterprise Manager?
> Or is there another app that has a print option?
Thanks to all that helped!sql

Newbie question

Is it necessary for the table structure on the publisher from whom an article will be updated on the subscriber, have the same structure as the subscriber table?
Wilma,
replication can be set up like this (nosync), but it is not necessary. The
simplest method is to have a snapshot applied on the subscriber - a process
referred to as initialization. In this case nothing needs to be on the
subscriber prior to setting off the publication.
Regards,
Paul Ibison
|||Thankyou Paul

Newbie needs help

I set up the MS SQL Desktop server engine on my computer.
I successfully set up a database and the table structure using a query
utility. My Visual Studio logs in to the server using a system account that
magically exists.

but...

I can't make my web application log in to the database. I can't configure
the connection string to connect. I can't figure out how to create new
authorized user accounts that might work either. The SQL desktop engine is
a black box.

I'm stuck. How do you work this thing?

Bob

--== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==--
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
--= East and West-Coast Server Farms - Total Privacy via Encryption =--Robert Dickow wrote:
> I set up the MS SQL Desktop server engine on my computer.
> I successfully set up a database and the table structure using a
query
> utility. My Visual Studio logs in to the server using a system
account that
> magically exists.
> but...
> I can't make my web application log in to the database. I can't
configure
> the connection string to connect. I can't figure out how to create
new
> authorized user accounts that might work either. The SQL desktop
engine is
> a black box.
> I'm stuck. How do you work this thing?
> Bob
> --== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
News==--
> http://www.newsfeeds.com The #1 Newsgroup Service in the World!
120,000+ Newsgroups
> --= East and West-Coast Server Farms - Total Privacy via Encryption
=--

---------
Dim lsConn ' ConnectionString for database
Dim ladoConn ' Database connection

' Server connection
lsConn = "Provider=sqloledb;" + _
"Data Source=<ServerName>;" + _
"Database=<DatabaseName>;" + _
"UID=<UserID>;" + _
"PWD=<Password>"

' Connect to the database
Set ladoConn = CreateObject("ADODB.Connection")
ladoConn.Open(lsConn)
---------

HTH
--
David Rowland
http://dbmonitor.tripod.com