Something Basic

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

Hi pankaj,

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

Jens Suessmeyer.

(pankaj_wolfhunter@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, esquel@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

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

(pankaj_wolfhunter@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, esquel@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

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