By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,453 Members | 961 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,453 IT Pros & Developers. It's quick & easy.

Something Basic

P: n/a
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

Nov 11 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Hi pankaj,

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

Jens Suessmeyer.

Nov 11 '05 #2

P: n/a
(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
Nov 11 '05 #3

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

Nov 11 '05 #4

P: n/a
(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
Nov 11 '05 #5

P: n/a
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

Nov 11 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.