Something Basic

[pankaj_wolfhunter]

Greetings,

When i log onto sql server using tsql i get the following line of
information:

locale is
"/en_US.ISO8859-1/en_US.ISO8859-15/en_US.ISO8859-15/en_US.ISO8859-15/en_US.ISO8859-15/en_US.ISO8859-1"
locale charset is "ISO8859-1"

Is there any way that i can omit this message appearing all the time?

Secondly, i have written a unix script that gets all the user defined
tables from sql server.
When i open the file after running the script, i get the table names
but along with that
i also get some numbers. like

Query: SELECT name FROM sysobjects WHERE type='U'

Output as in file after the script:

1> 2> 3> 4> name
stores
emplyoee
------------

In unix i can apply some command to get rid of these numbers but Is
there any way to do this thro sql-server only? some parameter or
something?

Help will be greatly appreciated

TIA

[Jens]

Hi pankaj,

Sounds like this is a provider specific thing, which provider are you
using ?

Jens Suessmeyer.

[Erland Sommarskog]

(pa***************@yahoo.co.in) writes:

When i log onto sql server using tsql i get the following line of
information:

locale is
"/en_US.ISO8859-1/en_US.ISO8859-15/en_US.ISO8859-15/en_US.ISO8859-
15/en_US.ISO8859-15/en_US.ISO8859-1"
locale charset is "ISO8859-1"

Is there any way that i can omit this message appearing all the time?
No idea. SQL Server does not produce this message. Sounds like something
that comes with whatever you connect with.
Secondly, i have written a unix script that gets all the user defined
tables from sql server.
When i open the file after running the script, i get the table names
but along with that
i also get some numbers. like

Query: SELECT name FROM sysobjects WHERE type='U'

Output as in file after the script:

1> 2> 3> 4> name
stores
emplyoee
------------

In unix i can apply some command to get rid of these numbers but Is
there any way to do this thro sql-server only? some parameter or
something?

Again, SQL Server does not produce these numbers. These are prompts produced
by command-line tools. And since you are on Unix, this is obviously a
third-party tool. It looks like you are using some derivate of ISQL.
Trying using the command option -n to prevent the prompts from being
produced.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[pankaj_wolfhunter]

Thnx for all the replies.
Jens, i am using tsql to connect to ms-sql server.
Does this helps?

[Erland Sommarskog]

(pa***************@yahoo.co.in) writes:

Thnx for all the replies.
Jens, i am using tsql to connect to ms-sql server.

Transact-SQL, sometimes called T-SQL, is indeed the name of the language
you use for programming SQL Server.

However, I have never heard of a tool called tsql. Mind you that most
people here connect to SQL Server from Windows, and Unix tools are mainly
unknown to us.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[pankaj_wolfhunter]

thnx for the reply. for now i am considering that i cannot remove that
information part and got
to use some unix command to do so.
thnx again