|
|
Posted by Erland Sommarskog on 11/11/05 10:39
(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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|