OSQL For SQL-Server 2000

Sep 27, 2005

I am on a new task where I don't have Enterprise Manager available and I need to build a database (I have been spoiled on all prior tasks).

I have access to SQL-Server and have OSQL available (and other utilities I don't know how to use).

I have already found that I can access the server using OSQL, but I don't know the rest of the parameters for OSQL or how to use them. I need to build tables, relationships, indices, stored procedures, views, etc.

Could someone point me to some documentation where I can learn how to use OSQL?

Thanks!

View 2 Replies


ADVERTISEMENT

Trying To Use Osql In SQL Server 2000

Nov 5, 2007

I want to run a stored procedure, from a .bat file.
Here is line 1 of the .bat file
osql -S SISPROD -d gSchool -E -Q "xSP_Attendance_Post_All_1Day '0708'"

When I run it as a Schedule Task, get
Run-time error '-2147217904...' Procedure 'xSP_Attendance_Post_All_1Day' expects parameter '@sy' which was not supplied.

The '0708' is the @sy parameter.
What is wrong with the command?

The weirder thing is that when I get a command prompt, any osql command gives me this:
'osql' is not recognized as an internal or external command,...'

Unless I run the .bat file -- then I get the same error as the 1st above.

SQL Server is not installed on this server. How does the Scheduled task run osql (although with the 1sterror above)? The task is running as "me", Active Directory user, same as I am logged on to server but cannot run osql at all.
TIA

View 2 Replies View Related

How To Apply A Sql Script File On Sql Server 2000 Without OSql.exe

Mar 5, 2007

Hi guys
I need to apply a sql script file on Sql server 2000 by .net 2.0 program. but on the current running machine, there is not Osql.exe file. Do you guys know how to execute the sql file without the command? Is there any way provided in .net library ?
Thanks for you response!

View 3 Replies View Related

OSQL SQL 2000 Named Instances Disappear When SQL Express Computer Added To Network

Aug 16, 2007

We have 10+ MSDE 2000 installations on the same network. Each install has a named instance and the
machines connect to eachother via VB application. We have a couple SQL 2000 Standard boxes and a SQL 2005
box all running on the same network with no issues. The problem we have recently run into is with a SQL
Express box. When the box is on the network OSQL stops finding the MSDE 2000 named instances on the
network and only the SQL Express named instance appears in the list. The second the SQL Express box is removed
from the network the named instances are visible. I monitored the UDP traffic and suspect there is an issue with the response from SQL Express to OSQL. Can't find any issues for this problem only report I found is if MSDE and Express are on the same machine.


SQL Express Response

.Q.ServerName;DDK7P4D1;InstanceName;SQLEXPRESS;IsClustered;No;Version;9.00.1399.06;;

MSDE Response

...ServerName;RED;InstanceName;SECOND;IsClustered;No;Version;8.00.194;tcp;4307;;Ser

verName;RED;InstanceName;THIRD;IsClustered;No;Version;8.00.194;tcp;0;;Server

Name;RED;InstanceName;MSSQLSERVER;IsClustered;No;Version;8.00.194;tcp;4303;;


Any ideas?

Thanks, Kevin.

View 2 Replies View Related

OSQL SQL 2000 Named Instances Disappear When SQL Express Computer Added To Network

Aug 16, 2007


We have 10+ MSDE 2000 installations on the same network. Each install has a named instance and the
machines connect to eachother via VB application. We have a couple SQL 2000 Standard boxes and a SQL 2005
box all running on the same network with no issues. The problem we have recently run into is with a SQL
Express box. When the box is on the network OSQL stops finding the MSDE 2000 named instances on the
network and only the SQL Express named instance appears in the list. The second the SQL Express box is removed
from the network the named instances are visible. I monitored the UDP traffic and suspect there is an issue with the response from SQL Express to OSQL. Can't find any issues for this problem only report I found is if MSDE and Express are on the same machine.


SQL Express Response

.Q.ServerName;DDK7P4D1;InstanceName;SQLEXPRESS;IsClustered;No;Version;9.00.1399.06;;

MSDE Response

...ServerName;RED;InstanceName;SECOND;IsClustered;No;Version;8.00.194;tcp;4307;;Ser

verName;RED;InstanceName;THIRD;IsClustered;No;Version;8.00.194;tcp;0;;Server

Name;RED;InstanceName;MSSQLSERVER;IsClustered;No;Version;8.00.194;tcp;4303;;


Any ideas?

Thanks, Kevin.

View 4 Replies View Related

Help! Backing Up Sql Server 2005 Using Osql.exe

Aug 26, 2006

Hi  I am trying to make a backup of my SQL server 2005, used with Web Developer 2005 Express, in osql.exe (can't find any other way of doing it). I get the error that "under the default settings SQL server does not allow remote connections".I connect to it fine from the Web Developer 2005 and my application . I followed  another post's instructions where I enabled the TCP/IP and named pipes for "Protocols for SQLEXPRESS", but didn't work. In fact when I changed TCP/IP properties/ IP Addresses/TCP Dynamic port to nothing , and TCP Port to 1357, the server wouldn't start again !! (not doin THAT again)Regards Amanda 

View 1 Replies View Related

Win NT Authentication Mode In SQL Server Using OSQL

Mar 26, 2004

i wannt to Connect SQL server from Client's pc to server using OSQL utility in Windows authentication mode. help me how can i do it?

View 1 Replies View Related

OSql Util In Sql Server 2005

Sep 16, 2007

There is support in Osql util in SqlServer 2005 ?

View 1 Replies View Related

Can I Use Osql To Known The Database Install On A Server Via 'guest' ?

Jul 23, 2005

Can I use osql to known the database install on a server via 'guest'account ?I had over 300 servers with sql server all around France (differentversion : 6.5, 7 and 8)I need to check all database on each servers from my place.Of course, also it would have been to easy, I don't have all 'sa'password...Is that possible to use the 'guest' account to execute a query likethis via osql :Extract.sqlexec sp_helpdbExtract.cmdfor /f "usebackq tokens=1 delims=" %%i IN (ListServer.txt) DOosql-S%%i -Uguest -P -dmaster -i"C:ExtractionExtract.sql"-o"C:Extraction\%%i.rpt"Could I query 'master' with the 'guest' account ?Or any other ideas how to do this by an other way ?Thanks

View 1 Replies View Related

Can&´t Connect To SQL SERVER 2005 Osql -L Servers:---NONE---

Mar 28, 2007

Hi, i´m new to SQL SERVER, I've been using Oracle and MySql without problems so far.
I'm having problems to connect to SQL SERVER on my local machine.
**UPDATE
I can connect via command line, but from Visual Studio can´t connect to SQL SERVER
Sometimes I got this error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
And sometimes something about enabling remote connections in SQL SERVER , but the server is in the local machine.
what´s suppose to be the name of my server? localhost?
what am I doing wrong, ?
I have no problems to connect to Oracle and mysql with Visual Studio.
Thanks in advance

View 3 Replies View Related

Sqlcmd And Osql Error HResult 0x2 SQL Server 2005 Exp

May 16, 2007

Hello,

I get following error trying to use SQLCMD OR OSQL

Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

I searched this forum for answers and I found one solution where it was said that Remote connections for TCP and Named Pipes needs to be enabled. I have them enabled, but I still get this error. I had working SQL server before, but I had to uninstall it. Now after installing ti again I started to get this error.

Anything else besides disabled remote connections cause this problem? I'm trying a local connection. I heard elsewhere that this could be firewall related, but shouldn't it use local connection always when I try to connect it with sqlcmd and no other parameters given?

View 2 Replies View Related

Osql

Jun 28, 2001

Hi, we are having problems getting osql to work. When we try and open it quickly opens and then closes again. Has anybody else had this problem?

View 1 Replies View Related

Osql

Oct 25, 2004

Hi all.

My first post here.

I want to distriburte a msde database. When doing so, I also want to make a new login, make a user, make the user the dbowner of the database i installed.

I found the Stored procedures I need to use, and I have tested that it works using OSQL.

What I want to do now is to make this automatic. After installing the database the OSQL commands should be executed and no user interference should be necessary. How can that be done ?

peet

View 4 Replies View Related

OSQL Help

May 15, 2008

Hi All,

I am trying to use OSQL (somthing I am new too)

I have the folllowing syntax, but it does not seam to work. Any ideas would be very gratfull.

osql -Usa -Ppassword -SServername -Q"select @@version"

Thanks in advance

Dave


Dave Dunckley says there is a law for the rich and a law for the poor and a law for
Dirty Davey.

View 7 Replies View Related

OSQL

Mar 11, 2008

Hello,

I have several sql scripts to be executed on a set schedule, with the output directed to a text file. If the schedule triggers this process daily, is it possible to append each days output to the same output file? I've researched the osql switches and various online sources...nothing really covers this.

This is done (relatively) easily with .vbs, but so far it looks tougher with TSQL.

Many thanks to all who respond!

View 2 Replies View Related

Osql

Mar 12, 2008

is there some way to activate osql from a c++ app and stream theoutput to my program?

View 1 Replies View Related

Osql

Dec 22, 2006

i'm trying to execute some scripts created by the express studio script wizard. i can connect with the studio, the website (asp worker) but i can't create the right cmdline for osql ..... this is my osql line ......

C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn>osql -S (local)\SQLEXPRESS -U sa -P sablah -i run.sql.......

this is the error i'm getting in my logs

Error: 18456, Severity: 14, State: 16.
2006-12-22 15:30:45.11 Logon Login failed for user 'sa'. [CLIENT: <local machine>]

"Server=(local)\SQLEXPRESS;Database=ggmi;User Id=sa;Password=cr79cr02;Trusted_connection=false;";

the following is the working connection string for my aspworker.

"Server=(local)\SQLEXPRESS;Database=ggmi;User Id=sa;Password=cr79cr02;Trusted_connection=false;";

when i try to put in the trust conenction parameter is says that it conflicts with the user flag ,. probably because its a differant type of login process. any ideas?

View 6 Replies View Related

Osql Utility

Jul 28, 2004

using osql utility i have converted a table in database to excel format. I have also chinese data in my database . The problem is while converting the data into excel format ,the chinese data is not comming in excel sheet.
Does anybody have an idea about this .
For converting i have used

declare @x varchar(300)
set @x = 'osql -S Servername -U username -P passwd -q "select * from northwind..region order by cand_index" -w 3000 -s "," -o C:directoryfilename.csv'


Thanks

View 2 Replies View Related

Osql Utility

Aug 14, 2004

Hi all
I am using osql utility in sql server 2000 to convert data in database to excel sheet. My datas contain both english and chinese . While converting to excel sheet english datas are comming but the datas in chinese is comming like (?) this. Does any body has any idea to solve this problem. is there any way to set font in osql utility.

set @x = 'osql -S servername -U username -P password -q "select * from

northwind..region" -w 3000 -s "," -o C:Downloaddownload.csv'
This is what i have used.
Note: I tried giving chinese font in excel still it is not working.
Its really urgent pls reply
thanks

View 2 Replies View Related

Osql Syntax Help

Oct 8, 2004

Dear friends,

I was trying to run this script from a dos batch file under win xp but it's not working. Please help with the syntax.
================================================== =======
OSQL -U sa -P samsde -S firebird /Q "RESTORE DATABASE NAVIMEX FROM DISK = 'C:30704' WITH

REPLACE, MOVE'NAVIMEX_Data' TO 'C:Program FilesMicrosoft SQL

ServerMSSQLDataNAVIMEX_Data.MDF',MOVE 'NAVIMEX_Log' TO 'C:Program FilesMicrosoft SQL

ServerMSSQLDataNAVIMEX_LOG.LDF'" QUIT
================================================== ========

Please provide me with the correct syntax to be put in a 'restore.bat' file :rolleyes:

Thanks in advance.
HotBird

View 4 Replies View Related

Osql -b Question!

Oct 25, 2004

the help document said that

"osql -b will specifies that OSQL exits and returns a DOS ERRORLEVEL value when an error occurs. The value returned to the DOS ERRORLEVEL variable is 1 when the SQL Server error message has a severity of 10 or greater; otherwise, the value returned is 0."

my question is : how can I get the DOS ERRORLEVEL.

example:

C:>isql -E -b -Q"backup log pubs to disk='C:adsfasd.tmp'"

the result:

Msg 4208, Level 16, State 0, Server YANG, Line 1
当恢复模型为 SIMPLE 时,不允许使用 BACKUP LOG 语句。请使用 BACKUP DATABASE 或用
ALTER DATABASE
更改恢复模型。
Msg 3013, Level 16, State 1, Server YANG, Line 1
BACKUP LOG 操作异常终止。

It's in chinese language,means
"can not use BACKUP LOG when the restore model being SIMPLE,you can use ALTER DATABASE or BACKUP DATABASE to change the restore model.
Msg 3013, Level 16, State 1, Server YANG, Line 1
BACKUP LOG aborted"

where is DOS ERRORLEVEL???? How can I get it????

thanks

View 2 Replies View Related

Running A Job Via Osql??

Dec 1, 2004

Hello All,
A VERY green SQL Server DBA here looking for some help. Our main production environment is Oracle, which utilizes Control-M as a scheduler. At the end of the Oracle batch process, we would like to automate a process to kick off a sql server job (perhaps via osql??) Is this possible?

Thanks in advance,
Tony

View 14 Replies View Related

Osql And Carc.:éàè

Dec 14, 2005

I run a script with Osql and got no error but the accent caracter (french message) are modified.

the script is
CREATE PROCEDURE dbo.AccentTest
AS
Print('é à è î ï ù')
GO
and come
CREATE PROCEDURE dbo.AccentTest
AS
Print('Θ α Φ ε ∩ ∙')
GO
:o
This is very bad! Can someone can help me?
Any suggestion?
PLease.....


osql.exe -S MyServer -U username-P pwd-d TestDB -n -o "C:Devosql_test.log" -i "C:DevAccentTest.sql" :

View 1 Replies View Related

Dynamic SQL Vs OSQL

Sep 5, 2006

Question for the experts here:

Is there any advantage of running an SQL statement through osql with the database information over using dynamic sql?

Example:

DECLARE @DB Varchar(50)
DECLARE @SQL Varchar(4000)
SET @DB = '<nvr_changing_server>.<my_dynamic_db_name>'
SET @SQL = 'SELECT admissiontype_id AS atype, admissiontype AS atype_desc, start_date, end_date
INTO tlkAdmitType
FROM <nvr_changing_server>.<nvr_changing_DB>.dbo.tlkAdmissionTypes'

exec master..xp_cmdShell 'osql -U sa -P sapwd -S nvr_changing_server -d my_dynamic_db_name -Q @SQL....'

vs. something like:

DECLARE @DB Varchar(50)
DECLARE @SQL Varchar(4000)
SET @DB = '<nvr_changing_server>.<my_dynamic_db_name>'
SET @SQL = 'SELECT admissiontype_id AS atype, admissiontype AS atype_desc, start_date, end_date
INTO ' + @DB +'.dbo.tlkAdmitType
FROM <nvr_changing_server>.<nvr_changing_DB>.dbo.tlkAdmissionTypes'

EXEC(@SQL)

The purpose of all this is...I need to pass a parameter for the DB that I will be inserting into...here we create a new db with a specific name based on quarterly data. We collect, crunch, validate data and ship it. Then when it's old we archive it then eventually delete it.

I have written a script that makes this quarterly build less painful. In fact I won't have to do it! :)...our Sr. Data Analysts will do it now. In order for this beautiful thing (*in my mind anyway*) to work they need to set parameters for which data to pull and where to put it. The DB is scripted into existance and the data is moved into it. So therefore they need to enter the Qtr,Yr and dbname. I have done DSQL before on smaller scripts and I am just curious if the expert pool here can shed some light on this approach. The script will most likely be run in a DTS SQL Task.

Thanks in advance...R

View 1 Replies View Related

Running OSQL

Feb 25, 2004

Hi,

When i want to run the OSQL utility, it will open the command prompt, but only for about a second, then, gone...

I'm running an XP pro machine with MSDE 2000 installed locally... any ieads??

thanks!

View 2 Replies View Related

OSQL Question

Mar 18, 2004

I created a sql script that transfers data from my test system to production adn vice versa. I would like to use OSQL and be able to pass parameters to the SQL script.

Example: param 1 = test; param 2 = production.

Can anyone tell me if this is possible and how to do it?

Thanks in advance for all the help.

View 2 Replies View Related

Error With Osql

Apr 21, 2004

Locally executing osql to create db files on a remote Webserver, I get this error:

41> 42> 43> 44> 45> Meldung 916, Ebene 14, Status 1, Server USER-EQ9OV60EMF, Zeile 12
Server user 'Robse_Testlogin' is not a valid user in database 'msdb'.

(The above is german and translates into "Message 916, Level 14,..., Row 12")

This is the command with parameters:

osql -S servername -U Robse_Testlogin -P password -i c:Storestoredb.sql"


Up to that line, everything works fine...what could be wrong?

View 3 Replies View Related

Osql Formatting

May 5, 2004

At first I'd like to justify myself - I'm rather a greenhorn in MS SQL ;-)
What I'd like to do is to create a very simple spool file from my database.
I'd like to do this using OSQL tool and it's very important for me to have the spool file in the same format as it was earlier when I used Oracle and simple spool command.
And it's almost the same, but white spaces...
There's always one white space at the begining of each line and at least one at the and of each line.
I've been trying many OSQL switches and ltrim(..) / rtrim(..) functions but the problem still exists...
The spool file is rather big - around 300MB so it's not good idea to use SED (for example) to remove white spaces.
So my question:
IS IT POSSIBLE TO REMOVE WHITE SPACES COMPLETELY USING OSQL SPOOL?

Thanks in advance for any help.

View 9 Replies View Related

Osql / Isql

Jan 17, 2008

Is osql/isql supported in SQL 2005? How about in 2008? Thanks

View 2 Replies View Related

Osql Timeout

Jul 23, 2005

Hi,I have several big tables with rows more than 25 mil rowsand to update/delete/insert data in these tables,it can take minutes.I use BULK Insert/DELETE/Update with osql.While I run one of these updates,if I try to select, it seems like both read and write get locked.Shouldn't SQL resolve this kind of locking?I left these to see if it gets resolved but both never returned.So I need to kill these processes.Does anyone have any scripts to find how long queries are running?Also I need to make osql timeout and tried -t but it didn't work.I used -t 1200 with DELETE in osql but it was running for more than 40minutes. So I killed it and ran DBCC DBREINDEX on the table and re-ranit and it worked.Shouldn't the query get killed after 10 minutes?What is exactly -t option for ?thanks,

View 2 Replies View Related

Osql Feedback

Jul 23, 2005

I have some long running scripts which I fire at my database using osql.(These are big files and mostly doing inserts but some also do a few otherthings.) It would be nice to have some activity indication (other than thedisk activity light) that these are running. When I used to use Oracle,their equivalent to osql had an option to print a dot (without a carriagereturn) for every "n" statements. This gave a nice "I'm alive" indicator. Ican simulate this by adding a few "print" statements in my sql, but printalways adds a carriage return. Does anyone know a way of doing a print butwithout the addition of a CR (or CR/LF)? So that a second "print" sends itsoutput to the same line as the first?I know this is a nicety and I can live without it, but it would be nice.thanks in advance,Brianwww.cryer.co.uk/brian

View 4 Replies View Related

Using OSQL And DTSRUN

Mar 21, 2006

I have a question. I am doing some work for someone and I have a batchfile that they can run that will execute an OSQL line and a DTSRUNline. In both lines I run them using the /S /U /P switches and ofcourse the /N or /i switch to tell it what to run. I have also triedreplacing the /U /P switches with the /E switch.My problem is that as long as I specify the users password on the OSQLline (either with /U & /P or with /E & /P) it will run. If I try andjust use the /E it will say password failed for DOMAIN/USER . Ok, Idon't really care I can specify the password and the script will run.However no matter what I do the DTSRUN line will not run, it gives methis same password error.I can run this line just fine on my PC on my network and my domainusing just the /S /E switches.Any ideas as to why it will work for OSQL but not DTSRUN?Thanks in advance.

View 5 Replies View Related

Using OSQL For BCP Handling

Feb 1, 2008

I find this thread very useful. But how can I run those scripts in command line using OSQL???

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved