June 22, 2008 at 7:04 pm
I am doing an upgrade project to upgrade SQL Server 2000 to SQL Server 2005.
I tried to change all of the commands "isql" or "osql" to "sqlcmd".
In SQL Server 2000, when I run like "isql -r 1 -S servername/instancename -U xx -P xxxxx -i xxx.sql", the screen has such "1>2>3>1>2>3>4>1>...."output, however, in SQL Server 2005, I change the command to "sqlcmd", there is no any output.
How I can resolve this issue.
June 22, 2008 at 9:01 pm
[font="Verdana"]OSQL is still supported in SQL 2005, hence you can make use of it!![/font]
Regards..Vidhya Sagar
SQL-Articles
June 22, 2008 at 10:10 pm
why do you care if the output is different? sqlcmd still executes the script right?
---------------------------------------
elsasoft.org
June 22, 2008 at 11:41 pm
my leader care about the output. that's fine, I would told him still using 'isql' or 'osql' in SQL Server 2005.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply