Client Utility syntax

Client utility asks for the Server Alias name, and the server name.
If the computer-name is Location1, and the SQL-Server instance
name = BOB, and say the ip-adress is 1.2.3.4
Then,
Server Alias Name would = Location1\BOB
Server Name would = 1.2.3.4\BOB
Is this correct?
Yes!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Robert A. DiFrancesco" wrote:

> Client utility asks for the Server Alias name, and the server name.
> If the computer-name is Location1, and the SQL-Server instance
> name = BOB, and say the ip-adress is 1.2.3.4
> Then,
> Server Alias Name would = Location1\BOB
> Server Name would = 1.2.3.4\BOB
> Is this correct?
>
>
|||I am having trouble connecting:
server doesn't exist or access denied
ConnectionOpen (connect() )
I can connect via XP remote desktop to the public ip 207.x.x.x .
In doing so and checking tcp/ip properties, I see that the setting is NOT to
obtain an IP automatically, rather it is "use this ip address". And the
local address is 192.x.x.x
How does this effect my connection setup?
thank you,
bob
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:9F58DE4A-569D-4561-8252-DABFDE6AFC99@.microsoft.com...[vbcol=seagreen]
> Yes!
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> "Robert A. DiFrancesco" wrote:
instance[vbcol=seagreen]
Location1\BOB[vbcol=seagreen]

Client Network Utility - tcp/ip

what is the syntax the server alias and the server name?
Is this correct: server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
server name should be the "ip-address\instance name"?
You can use anything for a server alias. If you want to hide that fact that
an instance is an instance, you can just use a single word as the alias. Or
you could mask a default instance as a named instance. The server name can
be either the network (computer) name or the IP-address if you are using
TCP/IP, with the instance name added if necessary.
Jacco Schalkwijk
SQL Server MVP
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OeOF%23rPVFHA.3024@.TK2MSFTNGP14.phx.gbl...
> what is the syntax the server alias and the server name?
> Is this correct: server alias should be the
> "computer-name\sql-instance-name"? Will it work against a default
> instance?
> server name should be the "ip-address\instance
> name"?
>

Client Network Utility - tcp/ip

what is the syntax the server alias and the server name?
Is this correct: server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
server name should be the "ip-address\instance name"?You can use anything for a server alias. If you want to hide that fact that
an instance is an instance, you can just use a single word as the alias. Or
you could mask a default instance as a named instance. The server name can
be either the network (computer) name or the IP-address if you are using
TCP/IP, with the instance name added if necessary.
Jacco Schalkwijk
SQL Server MVP
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OeOF%23rPVFHA.3024@.TK2MSFTNGP14.phx.gbl...
> what is the syntax the server alias and the server name?
> Is this correct: server alias should be the
> "computer-name\sql-instance-name"? Will it work against a default
> instance?
> server name should be the "ip-address\instance
> name"?
>

Clearness needed in Sp_attach_db

Hi

With the sql server on line help , The syntax for the sp_attach_db has
the file name .It is aslo given that max of 16 files can be geven. I
attached a db with a single d.mdf .

could u pls tell what r the 16 file types or how a db can be attached
with 16 files.

With thanksYou can use CREATE DATABASE ... FOR ATTACH to attach a database of more
than 16 files. See the SQL 2000 Books Online
<tsqlref.chm::/ts_create_1up1.htm> for details.

BTW, sp_attach_db and sp_single_file_attach_db are basically just
wrappers for this command.

--
Hope this helps.

Dan Guzman
SQL Server MVP

--------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index...epartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--------

"Raghuraman" <raghuraman_ace@.rediffmail.com> wrote in message
news:66c7bef8.0311160458.621723bc@.posting.google.c om...
> Hi
> With the sql server on line help , The syntax for the sp_attach_db has
> the file name .It is aslo given that max of 16 files can be geven. I
> attached a db with a single d.mdf .
> could u pls tell what r the 16 file types or how a db can be attached
> with 16 files.
>
> With thanks