I wanted to know if there was any difference in having Outlook or Outlook
Express installed on the SQL server machine if it is used for parsing emails
and for job failure notifications with in the SQL Agent.
thanks
Meenal
Meenal,
Please read:
INF: How to Configure SQL Mail
http://support.microsoft.com/default...b;en-us;263556
esp. " Because Microsoft Outlook Express does not create a Mail profile,
Outlook Express will not work with SQL Mail."
HTH
Jerry
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>I wanted to know if there was any difference in having Outlook or Outlook
> Express installed on the SQL server machine if it is used for parsing
> emails
> and for job failure notifications with in the SQL Agent.
>
> thanks
> Meenal
>
|||Thank you - that was exactly the kind of information I was looking for.
thanks
Meenal
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e$pGtm20FHA.2312@.TK2MSFTNGP14.phx.gbl...
> Meenal,
> Please read:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/default...b;en-us;263556
> esp. " Because Microsoft Outlook Express does not create a Mail profile,
> Outlook Express will not work with SQL Mail."
> HTH
> Jerry
>
> "Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
> news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>
sql
Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts
Friday, March 30, 2012
Outlook vs Outlook Express on SQL server
I wanted to know if there was any difference in having Outlook or Outlook
Express installed on the SQL server machine if it is used for parsing emails
and for job failure notifications with in the SQL Agent.
thanks
MeenalMeenal,
Please read:
INF: How to Configure SQL Mail
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
esp. " Because Microsoft Outlook Express does not create a Mail profile,
Outlook Express will not work with SQL Mail."
HTH
Jerry
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>I wanted to know if there was any difference in having Outlook or Outlook
> Express installed on the SQL server machine if it is used for parsing
> emails
> and for job failure notifications with in the SQL Agent.
>
> thanks
> Meenal
>|||Thank you - that was exactly the kind of information I was looking for.
thanks
Meenal
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e$pGtm20FHA.2312@.TK2MSFTNGP14.phx.gbl...
> Meenal,
> Please read:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
> esp. " Because Microsoft Outlook Express does not create a Mail profile,
> Outlook Express will not work with SQL Mail."
> HTH
> Jerry
>
> "Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
> news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
> >I wanted to know if there was any difference in having Outlook or Outlook
> > Express installed on the SQL server machine if it is used for parsing
> > emails
> > and for job failure notifications with in the SQL Agent.
> >
> >
> > thanks
> > Meenal
> >
> >
>
Express installed on the SQL server machine if it is used for parsing emails
and for job failure notifications with in the SQL Agent.
thanks
MeenalMeenal,
Please read:
INF: How to Configure SQL Mail
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
esp. " Because Microsoft Outlook Express does not create a Mail profile,
Outlook Express will not work with SQL Mail."
HTH
Jerry
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>I wanted to know if there was any difference in having Outlook or Outlook
> Express installed on the SQL server machine if it is used for parsing
> emails
> and for job failure notifications with in the SQL Agent.
>
> thanks
> Meenal
>|||Thank you - that was exactly the kind of information I was looking for.
thanks
Meenal
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e$pGtm20FHA.2312@.TK2MSFTNGP14.phx.gbl...
> Meenal,
> Please read:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
> esp. " Because Microsoft Outlook Express does not create a Mail profile,
> Outlook Express will not work with SQL Mail."
> HTH
> Jerry
>
> "Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
> news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
> >I wanted to know if there was any difference in having Outlook or Outlook
> > Express installed on the SQL server machine if it is used for parsing
> > emails
> > and for job failure notifications with in the SQL Agent.
> >
> >
> > thanks
> > Meenal
> >
> >
>
Outlook vs Outlook Express on SQL server
I wanted to know if there was any difference in having Outlook or Outlook
Express installed on the SQL server machine if it is used for parsing emails
and for job failure notifications with in the SQL Agent.
thanks
MeenalMeenal,
Please read:
INF: How to Configure SQL Mail
http://support.microsoft.com/defaul...kb;en-us;263556
esp. " Because Microsoft Outlook Express does not create a Mail profile,
Outlook Express will not work with SQL Mail."
HTH
Jerry
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>I wanted to know if there was any difference in having Outlook or Outlook
> Express installed on the SQL server machine if it is used for parsing
> emails
> and for job failure notifications with in the SQL Agent.
>
> thanks
> Meenal
>|||Thank you - that was exactly the kind of information I was looking for.
thanks
Meenal
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e$pGtm20FHA.2312@.TK2MSFTNGP14.phx.gbl...
> Meenal,
> Please read:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/defaul...kb;en-us;263556
> esp. " Because Microsoft Outlook Express does not create a Mail profile,
> Outlook Express will not work with SQL Mail."
> HTH
> Jerry
>
> "Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
> news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>
Express installed on the SQL server machine if it is used for parsing emails
and for job failure notifications with in the SQL Agent.
thanks
MeenalMeenal,
Please read:
INF: How to Configure SQL Mail
http://support.microsoft.com/defaul...kb;en-us;263556
esp. " Because Microsoft Outlook Express does not create a Mail profile,
Outlook Express will not work with SQL Mail."
HTH
Jerry
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>I wanted to know if there was any difference in having Outlook or Outlook
> Express installed on the SQL server machine if it is used for parsing
> emails
> and for job failure notifications with in the SQL Agent.
>
> thanks
> Meenal
>|||Thank you - that was exactly the kind of information I was looking for.
thanks
Meenal
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e$pGtm20FHA.2312@.TK2MSFTNGP14.phx.gbl...
> Meenal,
> Please read:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/defaul...kb;en-us;263556
> esp. " Because Microsoft Outlook Express does not create a Mail profile,
> Outlook Express will not work with SQL Mail."
> HTH
> Jerry
>
> "Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
> news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>
Friday, March 9, 2012
osql to connect to a Database
I am running MSDE 2000 Rel A on a Windows XP machine and am able to
connect to it by doing the following:
osql -U sa
or
osql -E
But how do I connect to a Particular Database or see all the tables
etc? I am a but familiar with sql (which could be the problem) and an
trying to do the following that I can with it:
sql user_name/database_name@.password
so that I can connect directly to the DB I'm interested and then I can
do:
select tablenames;
desc table_name;
select * from table_name;
etc
Any ideas? Like I mentioned, maybe I'm trying to do things that is not
supposed to be possible with osql (which would really suck).
- manzoorosql -S (local) -E -d pubs
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Manzoorul Hassan" <manzoorul.hassan@.gmail.com> wrote in message
news:1105052724.438484.94120@.z14g2000cwz.googlegroups.com...
>I am running MSDE 2000 Rel A on a Windows XP machine and am able to
> connect to it by doing the following:
> osql -U sa
> or
> osql -E
> But how do I connect to a Particular Database or see all the tables
> etc? I am a but familiar with sql (which could be the problem) and an
> trying to do the following that I can with it:
> sql user_name/database_name@.password
> so that I can connect directly to the DB I'm interested and then I can
> do:
> select tablenames;
> desc table_name;
> select * from table_name;
> etc
> Any ideas? Like I mentioned, maybe I'm trying to do things that is not
> supposed to be possible with osql (which would really suck).
> - manzoor
>|||Hi Hassan,
From your posting it looks like 'sa' password is blank (that is incase you
are not giving any password when OSQL utility prompts).
Best practice is to change the 'sa' pwd to something else, as it gives
access to anybody in your network, with sql client.
If you are not using blank pwd, please ignore this message.
--
Thanks
Yogish|||thanx a million!!!!
- manzoor
connect to it by doing the following:
osql -U sa
or
osql -E
But how do I connect to a Particular Database or see all the tables
etc? I am a but familiar with sql (which could be the problem) and an
trying to do the following that I can with it:
sql user_name/database_name@.password
so that I can connect directly to the DB I'm interested and then I can
do:
select tablenames;
desc table_name;
select * from table_name;
etc
Any ideas? Like I mentioned, maybe I'm trying to do things that is not
supposed to be possible with osql (which would really suck).
- manzoorosql -S (local) -E -d pubs
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Manzoorul Hassan" <manzoorul.hassan@.gmail.com> wrote in message
news:1105052724.438484.94120@.z14g2000cwz.googlegroups.com...
>I am running MSDE 2000 Rel A on a Windows XP machine and am able to
> connect to it by doing the following:
> osql -U sa
> or
> osql -E
> But how do I connect to a Particular Database or see all the tables
> etc? I am a but familiar with sql (which could be the problem) and an
> trying to do the following that I can with it:
> sql user_name/database_name@.password
> so that I can connect directly to the DB I'm interested and then I can
> do:
> select tablenames;
> desc table_name;
> select * from table_name;
> etc
> Any ideas? Like I mentioned, maybe I'm trying to do things that is not
> supposed to be possible with osql (which would really suck).
> - manzoor
>|||Hi Hassan,
From your posting it looks like 'sa' password is blank (that is incase you
are not giving any password when OSQL utility prompts).
Best practice is to change the 'sa' pwd to something else, as it gives
access to anybody in your network, with sql client.
If you are not using blank pwd, please ignore this message.
--
Thanks
Yogish|||thanx a million!!!!
- manzoor
osql to connect to a Database
I am running MSDE 2000 Rel A on a Windows XP machine and am able to
connect to it by doing the following:
osql -U sa
or
osql -E
But how do I connect to a Particular Database or see all the tables
etc? I am a but familiar with sql (which could be the problem) and an
trying to do the following that I can with it:
sql user_name/database_name@.password
so that I can connect directly to the DB I'm interested and then I can
do:
select tablenames;
desc table_name;
select * from table_name;
etc
Any ideas? Like I mentioned, maybe I'm trying to do things that is not
supposed to be possible with osql (which would really suck).
- manzoor
osql -S (local) -E -d pubs
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Manzoorul Hassan" <manzoorul.hassan@.gmail.com> wrote in message
news:1105052724.438484.94120@.z14g2000cwz.googlegro ups.com...
>I am running MSDE 2000 Rel A on a Windows XP machine and am able to
> connect to it by doing the following:
> osql -U sa
> or
> osql -E
> But how do I connect to a Particular Database or see all the tables
> etc? I am a but familiar with sql (which could be the problem) and an
> trying to do the following that I can with it:
> sql user_name/database_name@.password
> so that I can connect directly to the DB I'm interested and then I can
> do:
> select tablenames;
> desc table_name;
> select * from table_name;
> etc
> Any ideas? Like I mentioned, maybe I'm trying to do things that is not
> supposed to be possible with osql (which would really suck).
> - manzoor
>
|||Hi Hassan,
From your posting it looks like 'sa' password is blank (that is incase you
are not giving any password when OSQL utility prompts).
Best practice is to change the 'sa' pwd to something else, as it gives
access to anybody in your network, with sql client.
If you are not using blank pwd, please ignore this message.
Thanks
Yogish
|||thanx a million!!!!
- manzoor
connect to it by doing the following:
osql -U sa
or
osql -E
But how do I connect to a Particular Database or see all the tables
etc? I am a but familiar with sql (which could be the problem) and an
trying to do the following that I can with it:
sql user_name/database_name@.password
so that I can connect directly to the DB I'm interested and then I can
do:
select tablenames;
desc table_name;
select * from table_name;
etc
Any ideas? Like I mentioned, maybe I'm trying to do things that is not
supposed to be possible with osql (which would really suck).
- manzoor
osql -S (local) -E -d pubs
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Manzoorul Hassan" <manzoorul.hassan@.gmail.com> wrote in message
news:1105052724.438484.94120@.z14g2000cwz.googlegro ups.com...
>I am running MSDE 2000 Rel A on a Windows XP machine and am able to
> connect to it by doing the following:
> osql -U sa
> or
> osql -E
> But how do I connect to a Particular Database or see all the tables
> etc? I am a but familiar with sql (which could be the problem) and an
> trying to do the following that I can with it:
> sql user_name/database_name@.password
> so that I can connect directly to the DB I'm interested and then I can
> do:
> select tablenames;
> desc table_name;
> select * from table_name;
> etc
> Any ideas? Like I mentioned, maybe I'm trying to do things that is not
> supposed to be possible with osql (which would really suck).
> - manzoor
>
|||Hi Hassan,
From your posting it looks like 'sa' password is blank (that is incase you
are not giving any password when OSQL utility prompts).
Best practice is to change the 'sa' pwd to something else, as it gives
access to anybody in your network, with sql client.
If you are not using blank pwd, please ignore this message.
Thanks
Yogish
|||thanx a million!!!!
- manzoor
osql to connect to a Database
I am running MSDE 2000 Rel A on a Windows XP machine and am able to
connect to it by doing the following:
osql -U sa
or
osql -E
But how do I connect to a Particular Database or see all the tables
etc? I am a but familiar with sql (which could be the problem) and an
trying to do the following that I can with it:
sql user_name/database_name@.password
so that I can connect directly to the DB I'm interested and then I can
do:
select tablenames;
desc table_name;
select * from table_name;
etc
Any ideas? Like I mentioned, maybe I'm trying to do things that is not
supposed to be possible with osql (which would really suck).
- manzoorosql -S (local) -E -d pubs
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Manzoorul Hassan" <manzoorul.hassan@.gmail.com> wrote in message
news:1105052724.438484.94120@.z14g2000cwz.googlegroups.com...
>I am running MSDE 2000 Rel A on a Windows XP machine and am able to
> connect to it by doing the following:
> osql -U sa
> or
> osql -E
> But how do I connect to a Particular Database or see all the tables
> etc? I am a but familiar with sql (which could be the problem) and an
> trying to do the following that I can with it:
> sql user_name/database_name@.password
> so that I can connect directly to the DB I'm interested and then I can
> do:
> select tablenames;
> desc table_name;
> select * from table_name;
> etc
> Any ideas? Like I mentioned, maybe I'm trying to do things that is not
> supposed to be possible with osql (which would really suck).
> - manzoor
>|||Hi Hassan,
From your posting it looks like 'sa' password is blank (that is incase you
are not giving any password when OSQL utility prompts).
Best practice is to change the 'sa' pwd to something else, as it gives
access to anybody in your network, with sql client.
If you are not using blank pwd, please ignore this message.
Thanks
Yogish|||thanx a million!!!!
- manzoor
connect to it by doing the following:
osql -U sa
or
osql -E
But how do I connect to a Particular Database or see all the tables
etc? I am a but familiar with sql (which could be the problem) and an
trying to do the following that I can with it:
sql user_name/database_name@.password
so that I can connect directly to the DB I'm interested and then I can
do:
select tablenames;
desc table_name;
select * from table_name;
etc
Any ideas? Like I mentioned, maybe I'm trying to do things that is not
supposed to be possible with osql (which would really suck).
- manzoorosql -S (local) -E -d pubs
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Manzoorul Hassan" <manzoorul.hassan@.gmail.com> wrote in message
news:1105052724.438484.94120@.z14g2000cwz.googlegroups.com...
>I am running MSDE 2000 Rel A on a Windows XP machine and am able to
> connect to it by doing the following:
> osql -U sa
> or
> osql -E
> But how do I connect to a Particular Database or see all the tables
> etc? I am a but familiar with sql (which could be the problem) and an
> trying to do the following that I can with it:
> sql user_name/database_name@.password
> so that I can connect directly to the DB I'm interested and then I can
> do:
> select tablenames;
> desc table_name;
> select * from table_name;
> etc
> Any ideas? Like I mentioned, maybe I'm trying to do things that is not
> supposed to be possible with osql (which would really suck).
> - manzoor
>|||Hi Hassan,
From your posting it looks like 'sa' password is blank (that is incase you
are not giving any password when OSQL utility prompts).
Best practice is to change the 'sa' pwd to something else, as it gives
access to anybody in your network, with sql client.
If you are not using blank pwd, please ignore this message.
Thanks
Yogish|||thanx a million!!!!
- manzoor
Wednesday, March 7, 2012
osql or isql to run a batch remotely
Hello,
I have a collection of SQL Scripts that I would like to execute using a
batch file from a remote machine. Does anyone have any suggestions? I
think that I could use osql or isql, but I have never done that before. I
would appreciate any assistance.
Stewart
Stewart Saathoff wrote:
> Hello,
> I have a collection of SQL Scripts that I would like to execute using
> a batch file from a remote machine. Does anyone have any
> suggestions? I think that I could use osql or isql, but I have never
> done that before. I would appreciate any assistance.
> Stewart
I'm unclear about what is where...
Where is the file you want to execute located?
Do you want to run this file from a remote client or do you want to run
the file as though it were running directly on the server?
You can kick off OSQL from a stored procedure or a SQL Agent job on the
server. You could kick off OSQL from a client PC and execute a script
file that resides on the client PC. I would say that if the script file
is large, you'll get better performance running it from the server.
David Gugick
Imceda Software
www.imceda.com
|||ok, Let me be more clear.
I have a very large SQL Statement that needs to be run on the server.
Ideally the client will sit on their workstation and double-click on a file.
That file should execute the SQL statement on the server. I am pretty
positive that I can do all of this using osql, however I am unclear how I
can do this using a batch file. I don't want the users to have to type a
considerable amount and I definately do not want them to have to learn osql
or sql commands to do this...
Stewart
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%237j3Oby1EHA.524@.TK2MSFTNGP09.phx.gbl...
> Stewart Saathoff wrote:
> I'm unclear about what is where...
> Where is the file you want to execute located?
> Do you want to run this file from a remote client or do you want to run
> the file as though it were running directly on the server?
> You can kick off OSQL from a stored procedure or a SQL Agent job on the
> server. You could kick off OSQL from a client PC and execute a script file
> that resides on the client PC. I would say that if the script file is
> large, you'll get better performance running it from the server.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
|||Stewart Saathoff wrote:
> ok, Let me be more clear.
> I have a very large SQL Statement that needs to be run on the server.
> Ideally the client will sit on their workstation and double-click on
> a file. That file should execute the SQL statement on the server. I
> am pretty positive that I can do all of this using osql, however I am
> unclear how I can do this using a batch file. I don't want the users
> to have to type a considerable amount and I definately do not want
> them to have to learn osql or sql commands to do this...
> Stewart
>
If you have to run the SQL batch from a client PC, you can use OSQL.
There's an option for submitting a file to run. The command-line
interface is fairly straightforward and documented in BOL.
David Gugick
Imceda Software
www.imceda.com
|||<snip>
> I am pretty positive that I can do all of this using
> osql, however I am unclear how I can do this using a
> batch file.
<snip>
Stewart,
Assuming you get this to work at the command prompt...
osql -SBigBox -Uuser -Ppwd -ddbname -i somefile.sql -o somefile.log
You can just paste it into a BAT file: that's it. You can use @.ECHO OFF,
print out message, etc to pretty it up but that's pretty much all you need.
You would need a file with your SQL statement where the BAT file runs
(ideally the same folder). If that's not acceptable, then you could put the
statement in a stored proc and call the proc by name instead of using the
input file.
Craig
|||Thank you all for your help. Everything works great.
"Craig Kelly" <cnkelly.nospam@.nospam.net> wrote in message
news:yY9rd.1007069$Gx4.741632@.bgtnsc04-news.ops.worldnet.att.net...
> <snip>
>
> <snip>
> Stewart,
> Assuming you get this to work at the command prompt...
> osql -SBigBox -Uuser -Ppwd -ddbname -i somefile.sql -o somefile.log
> You can just paste it into a BAT file: that's it. You can use @.ECHO OFF,
> print out message, etc to pretty it up but that's pretty much all you
> need.
> You would need a file with your SQL statement where the BAT file runs
> (ideally the same folder). If that's not acceptable, then you could put
> the statement in a stored proc and call the proc by name instead of using
> the input file.
> Craig
>
I have a collection of SQL Scripts that I would like to execute using a
batch file from a remote machine. Does anyone have any suggestions? I
think that I could use osql or isql, but I have never done that before. I
would appreciate any assistance.
Stewart
Stewart Saathoff wrote:
> Hello,
> I have a collection of SQL Scripts that I would like to execute using
> a batch file from a remote machine. Does anyone have any
> suggestions? I think that I could use osql or isql, but I have never
> done that before. I would appreciate any assistance.
> Stewart
I'm unclear about what is where...
Where is the file you want to execute located?
Do you want to run this file from a remote client or do you want to run
the file as though it were running directly on the server?
You can kick off OSQL from a stored procedure or a SQL Agent job on the
server. You could kick off OSQL from a client PC and execute a script
file that resides on the client PC. I would say that if the script file
is large, you'll get better performance running it from the server.
David Gugick
Imceda Software
www.imceda.com
|||ok, Let me be more clear.
I have a very large SQL Statement that needs to be run on the server.
Ideally the client will sit on their workstation and double-click on a file.
That file should execute the SQL statement on the server. I am pretty
positive that I can do all of this using osql, however I am unclear how I
can do this using a batch file. I don't want the users to have to type a
considerable amount and I definately do not want them to have to learn osql
or sql commands to do this...
Stewart
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%237j3Oby1EHA.524@.TK2MSFTNGP09.phx.gbl...
> Stewart Saathoff wrote:
> I'm unclear about what is where...
> Where is the file you want to execute located?
> Do you want to run this file from a remote client or do you want to run
> the file as though it were running directly on the server?
> You can kick off OSQL from a stored procedure or a SQL Agent job on the
> server. You could kick off OSQL from a client PC and execute a script file
> that resides on the client PC. I would say that if the script file is
> large, you'll get better performance running it from the server.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
|||Stewart Saathoff wrote:
> ok, Let me be more clear.
> I have a very large SQL Statement that needs to be run on the server.
> Ideally the client will sit on their workstation and double-click on
> a file. That file should execute the SQL statement on the server. I
> am pretty positive that I can do all of this using osql, however I am
> unclear how I can do this using a batch file. I don't want the users
> to have to type a considerable amount and I definately do not want
> them to have to learn osql or sql commands to do this...
> Stewart
>
If you have to run the SQL batch from a client PC, you can use OSQL.
There's an option for submitting a file to run. The command-line
interface is fairly straightforward and documented in BOL.
David Gugick
Imceda Software
www.imceda.com
|||<snip>
> I am pretty positive that I can do all of this using
> osql, however I am unclear how I can do this using a
> batch file.
<snip>
Stewart,
Assuming you get this to work at the command prompt...
osql -SBigBox -Uuser -Ppwd -ddbname -i somefile.sql -o somefile.log
You can just paste it into a BAT file: that's it. You can use @.ECHO OFF,
print out message, etc to pretty it up but that's pretty much all you need.
You would need a file with your SQL statement where the BAT file runs
(ideally the same folder). If that's not acceptable, then you could put the
statement in a stored proc and call the proc by name instead of using the
input file.
Craig
|||Thank you all for your help. Everything works great.
"Craig Kelly" <cnkelly.nospam@.nospam.net> wrote in message
news:yY9rd.1007069$Gx4.741632@.bgtnsc04-news.ops.worldnet.att.net...
> <snip>
>
> <snip>
> Stewart,
> Assuming you get this to work at the command prompt...
> osql -SBigBox -Uuser -Ppwd -ddbname -i somefile.sql -o somefile.log
> You can just paste it into a BAT file: that's it. You can use @.ECHO OFF,
> print out message, etc to pretty it up but that's pretty much all you
> need.
> You would need a file with your SQL statement where the BAT file runs
> (ideally the same folder). If that's not acceptable, then you could put
> the statement in a stored proc and call the proc by name instead of using
> the input file.
> Craig
>
OSQL is Unable to see SQL Server and MSDE 2000 on the same machine
I have installed SQL Server and MSDE 2000 on my laptop under Windows XP. But I am not able to access the MSDE 2000 instance via OSQL. When I issue the command "osql -L" it lists only the SQL server (named as VSDOTNET). The MSDE 2000 instance is named as M
SSQLSERVER. The enterprise manager does not see MSSQLSERVER either. When I use the command "osql -Slocalhost\mssqlserver -Usa" and enter the password, I get the error message "[DBNETLIB]Invalid Connection.." The SQLMODE is set to mixed mode. I can access
MSSQLSERVER through a third party software (DB2KManager) but not through OSQL. Any suggestion would be greatly appreciated.
hi
"Surya Yadav" <Surya.Yadav@.ttu.edu> ha scritto nel messaggio
news:ED1D3FFF-4398-4407-8676-A79A31018BC0@.microsoft.com...
> I have installed SQL Server and MSDE 2000 on my laptop under Windows XP.
But I am not able to
>access the MSDE 2000 instance via OSQL. When I issue the command "osql -L"
it lists only the SQL >server (named as VSDOTNET). The MSDE 2000 instance is
named as MSSQLSERVER. The >enterprise manager does not see MSSQLSERVER
either. When I use the command "osql ->Slocalhost\mssqlserver -Usa" and
enter the password, I get the error message "[DBNETLIB]Invalid
>Connection.." The SQLMODE is set to mixed mode. I can access MSSQLSERVER
through a third >party software (DB2KManager) but not through OSQL. Any
suggestion would be greatly appreciated.
when installing a named instance, it's full name is
ComputerName\InstanceName or (local)\InstanceName or LocalHost\InstanceName,
those , your instance will be known as
YourCoumpeterName\VSDOTNET
(Local)\VSDOTNET
Localhost\VSDOTNET
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi,
Can you please explain it again? What am I doing wrong when I type "osql -Slocalhost\mssqlserver -Usa" ? The service is running as MSSQLSERVER when I browse under the Services icon from the Administrative tools. At the installation time I did not specify
an instance name. Setup.exe created the default instance as MSSQLSERVER. Thanks.
|||hi,
"Surya Yadav" <surya.yadav@.ttu.edu> ha scritto nel messaggio
news:0ED30CB4-1E7C-4CDC-9BAF-FA3F0742C9F0@.microsoft.com...
> Hi,
> Can you please explain it again? What am I doing wrong when I type
"osql -Slocalhost\mssqlserver -
> Usa" ? The service is running as MSSQLSERVER when I browse under the
Services icon from the
> Administrative tools. At the installation time I did not specify an
instance name. Setup.exe created the
> default instance as MSSQLSERVER. Thanks.
you said your named instance was named VSDOTNET... in this case, the full
instance name is
ComputerName\InstanceName = YourComputerName\VSDOTNET
if the installed instance is the default instance, then it's name is just
(Local)
and/or
YourComputerName
c:\>osql -S(local) -Usa
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi I have the same problem:
Installed MSDE with default instance and could then connect to it from
QSQL.
Then I uninstalled it and installed with a named instance. Now I cant
connect:
With "osql -U sa -S servername\instancename" command... -
"[DBMSLPCN]SQL Server does not exist or access denied.
[DBMSLPCN]ConnectionOpen (Connect())."
But the SQL server Manager icon next to the clock indicate that it is
running...
Is the port 1050 correct - from the log file below..
Any help / ideas will be much appreciated. More detail follow below:
I use "MSDE2000A" with the service pack 3a
My install options was:
[Options]
INSTANCENAME="instancename"
TARGETDIR="E:\SQLServer_instancename"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
In the error log file I found these:
====================================
2004-05-08 14:41:14.06 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-05-08 14:41:14.06 server All rights reserved.
2004-05-08 14:41:14.06 server Server Process ID is 2700.
2004-05-08 14:41:14.06 server Logging SQL Server messages in file
'E:\SQLServer_instancenameMSSQL$instancename\LOG\E RRORLOG'.
2004-05-08 14:41:14.06 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2004-05-08 14:41:14.21 server SQL Server configured for thread mode
processing.
2004-05-08 14:41:14.21 server Using dynamic lock allocation. [500]
Lock Blocks, [1000] Lock Owner Blocks.
2004-05-08 14:41:14.26 spid4 Starting up database 'master'.
2004-05-08 14:41:14.32 server Using 'SSNETLIB.DLL' version
'8.0.766'.
2004-05-08 14:41:14.32 spid5 Starting up database 'model'.
2004-05-08 14:41:14.32 spid4 Server name is
'servername\instancename'.
2004-05-08 14:41:14.32 spid4 Skipping startup of clean database id
4
2004-05-08 14:41:14.34 server SQL server listening on 192.168.1.99:
1050.
2004-05-08 14:41:14.34 server SQL server listening on 127.0.0.1:
1050.
2004-05-08 14:41:14.37 spid5 Clearing tempdb database.
2004-05-08 14:41:14.40 spid5 Starting up database 'tempdb'.
2004-05-08 14:41:14.42 spid4 Recovery complete.
2004-05-08 14:41:14.42 spid4 SQL global counter collection task is
created.
2004-05-08 14:41:16.60 server SQL server listening on TCP, Shared
Memory, Named Pipes.
2004-05-08 14:41:16.60 server SQL Server is ready for client
connections
SSQLSERVER. The enterprise manager does not see MSSQLSERVER either. When I use the command "osql -Slocalhost\mssqlserver -Usa" and enter the password, I get the error message "[DBNETLIB]Invalid Connection.." The SQLMODE is set to mixed mode. I can access
MSSQLSERVER through a third party software (DB2KManager) but not through OSQL. Any suggestion would be greatly appreciated.
hi
"Surya Yadav" <Surya.Yadav@.ttu.edu> ha scritto nel messaggio
news:ED1D3FFF-4398-4407-8676-A79A31018BC0@.microsoft.com...
> I have installed SQL Server and MSDE 2000 on my laptop under Windows XP.
But I am not able to
>access the MSDE 2000 instance via OSQL. When I issue the command "osql -L"
it lists only the SQL >server (named as VSDOTNET). The MSDE 2000 instance is
named as MSSQLSERVER. The >enterprise manager does not see MSSQLSERVER
either. When I use the command "osql ->Slocalhost\mssqlserver -Usa" and
enter the password, I get the error message "[DBNETLIB]Invalid
>Connection.." The SQLMODE is set to mixed mode. I can access MSSQLSERVER
through a third >party software (DB2KManager) but not through OSQL. Any
suggestion would be greatly appreciated.
when installing a named instance, it's full name is
ComputerName\InstanceName or (local)\InstanceName or LocalHost\InstanceName,
those , your instance will be known as
YourCoumpeterName\VSDOTNET
(Local)\VSDOTNET
Localhost\VSDOTNET
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi,
Can you please explain it again? What am I doing wrong when I type "osql -Slocalhost\mssqlserver -Usa" ? The service is running as MSSQLSERVER when I browse under the Services icon from the Administrative tools. At the installation time I did not specify
an instance name. Setup.exe created the default instance as MSSQLSERVER. Thanks.
|||hi,
"Surya Yadav" <surya.yadav@.ttu.edu> ha scritto nel messaggio
news:0ED30CB4-1E7C-4CDC-9BAF-FA3F0742C9F0@.microsoft.com...
> Hi,
> Can you please explain it again? What am I doing wrong when I type
"osql -Slocalhost\mssqlserver -
> Usa" ? The service is running as MSSQLSERVER when I browse under the
Services icon from the
> Administrative tools. At the installation time I did not specify an
instance name. Setup.exe created the
> default instance as MSSQLSERVER. Thanks.
you said your named instance was named VSDOTNET... in this case, the full
instance name is
ComputerName\InstanceName = YourComputerName\VSDOTNET
if the installed instance is the default instance, then it's name is just
(Local)
and/or
YourComputerName
c:\>osql -S(local) -Usa
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi I have the same problem:
Installed MSDE with default instance and could then connect to it from
QSQL.
Then I uninstalled it and installed with a named instance. Now I cant
connect:
With "osql -U sa -S servername\instancename" command... -
"[DBMSLPCN]SQL Server does not exist or access denied.
[DBMSLPCN]ConnectionOpen (Connect())."
But the SQL server Manager icon next to the clock indicate that it is
running...
Is the port 1050 correct - from the log file below..
Any help / ideas will be much appreciated. More detail follow below:
I use "MSDE2000A" with the service pack 3a
My install options was:
[Options]
INSTANCENAME="instancename"
TARGETDIR="E:\SQLServer_instancename"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
In the error log file I found these:
====================================
2004-05-08 14:41:14.06 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-05-08 14:41:14.06 server All rights reserved.
2004-05-08 14:41:14.06 server Server Process ID is 2700.
2004-05-08 14:41:14.06 server Logging SQL Server messages in file
'E:\SQLServer_instancenameMSSQL$instancename\LOG\E RRORLOG'.
2004-05-08 14:41:14.06 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2004-05-08 14:41:14.21 server SQL Server configured for thread mode
processing.
2004-05-08 14:41:14.21 server Using dynamic lock allocation. [500]
Lock Blocks, [1000] Lock Owner Blocks.
2004-05-08 14:41:14.26 spid4 Starting up database 'master'.
2004-05-08 14:41:14.32 server Using 'SSNETLIB.DLL' version
'8.0.766'.
2004-05-08 14:41:14.32 spid5 Starting up database 'model'.
2004-05-08 14:41:14.32 spid4 Server name is
'servername\instancename'.
2004-05-08 14:41:14.32 spid4 Skipping startup of clean database id
4
2004-05-08 14:41:14.34 server SQL server listening on 192.168.1.99:
1050.
2004-05-08 14:41:14.34 server SQL server listening on 127.0.0.1:
1050.
2004-05-08 14:41:14.37 spid5 Clearing tempdb database.
2004-05-08 14:41:14.40 spid5 Starting up database 'tempdb'.
2004-05-08 14:41:14.42 spid4 Recovery complete.
2004-05-08 14:41:14.42 spid4 SQL global counter collection task is
created.
2004-05-08 14:41:16.60 server SQL server listening on TCP, Shared
Memory, Named Pipes.
2004-05-08 14:41:16.60 server SQL Server is ready for client
connections
osql connection to server on a different domain
I would like to be able to run a script from my machine that would go out and
change the sa passwords on all SQL Server Instances on our 3 different
domains.
We have Dev, Test and Prod domains.
When I do an osql -L I only see the SQL servers on that domain.
Is there anyway I can see servers on the other domains.
e.g INTTEST\Testmachine is on a different domain, can I get to it in osql
Any help appreciated.
MPM
Hi,
That depends up on the way your Trust relation ship is set between domains.
Please contact your system administrator.
Thanks
Hari
SQL Server MVP
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:1280490D-08C4-424D-9202-C4F023C5236C@.microsoft.com...
>I would like to be able to run a script from my machine that would go out
>and
> change the sa passwords on all SQL Server Instances on our 3 different
> domains.
> We have Dev, Test and Prod domains.
> When I do an osql -L I only see the SQL servers on that domain.
> Is there anyway I can see servers on the other domains.
> e.g INTTEST\Testmachine is on a different domain, can I get to it in osql
> Any help appreciated.
> MPM
change the sa passwords on all SQL Server Instances on our 3 different
domains.
We have Dev, Test and Prod domains.
When I do an osql -L I only see the SQL servers on that domain.
Is there anyway I can see servers on the other domains.
e.g INTTEST\Testmachine is on a different domain, can I get to it in osql
Any help appreciated.
MPM
Hi,
That depends up on the way your Trust relation ship is set between domains.
Please contact your system administrator.
Thanks
Hari
SQL Server MVP
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:1280490D-08C4-424D-9202-C4F023C5236C@.microsoft.com...
>I would like to be able to run a script from my machine that would go out
>and
> change the sa passwords on all SQL Server Instances on our 3 different
> domains.
> We have Dev, Test and Prod domains.
> When I do an osql -L I only see the SQL servers on that domain.
> Is there anyway I can see servers on the other domains.
> e.g INTTEST\Testmachine is on a different domain, can I get to it in osql
> Any help appreciated.
> MPM
osql connection to server on a different domain
I would like to be able to run a script from my machine that would go out an
d
change the sa passwords on all SQL Server Instances on our 3 different
domains.
We have Dev, Test and Prod domains.
When I do an osql -L I only see the SQL servers on that domain.
Is there anyway I can see servers on the other domains.
e.g INTTEST\Testmachine is on a different domain, can I get to it in osql
Any help appreciated.
MPMHi,
That depends up on the way your Trust relation ship is set between domains.
Please contact your system administrator.
Thanks
Hari
SQL Server MVP
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:1280490D-08C4-424D-9202-C4F023C5236C@.microsoft.com...
>I would like to be able to run a script from my machine that would go out
>and
> change the sa passwords on all SQL Server Instances on our 3 different
> domains.
> We have Dev, Test and Prod domains.
> When I do an osql -L I only see the SQL servers on that domain.
> Is there anyway I can see servers on the other domains.
> e.g INTTEST\Testmachine is on a different domain, can I get to it in osql
> Any help appreciated.
> MPM
d
change the sa passwords on all SQL Server Instances on our 3 different
domains.
We have Dev, Test and Prod domains.
When I do an osql -L I only see the SQL servers on that domain.
Is there anyway I can see servers on the other domains.
e.g INTTEST\Testmachine is on a different domain, can I get to it in osql
Any help appreciated.
MPMHi,
That depends up on the way your Trust relation ship is set between domains.
Please contact your system administrator.
Thanks
Hari
SQL Server MVP
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:1280490D-08C4-424D-9202-C4F023C5236C@.microsoft.com...
>I would like to be able to run a script from my machine that would go out
>and
> change the sa passwords on all SQL Server Instances on our 3 different
> domains.
> We have Dev, Test and Prod domains.
> When I do an osql -L I only see the SQL servers on that domain.
> Is there anyway I can see servers on the other domains.
> e.g INTTEST\Testmachine is on a different domain, can I get to it in osql
> Any help appreciated.
> MPM
osql connection to server on a different domain
I would like to be able to run a script from my machine that would go out and
change the sa passwords on all SQL Server Instances on our 3 different
domains.
We have Dev, Test and Prod domains.
When I do an osql -L I only see the SQL servers on that domain.
Is there anyway I can see servers on the other domains.
e.g INTTEST\Testmachine is on a different domain, can I get to it in osql
Any help appreciated.
MPMHi,
That depends up on the way your Trust relation ship is set between domains.
Please contact your system administrator.
Thanks
Hari
SQL Server MVP
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:1280490D-08C4-424D-9202-C4F023C5236C@.microsoft.com...
>I would like to be able to run a script from my machine that would go out
>and
> change the sa passwords on all SQL Server Instances on our 3 different
> domains.
> We have Dev, Test and Prod domains.
> When I do an osql -L I only see the SQL servers on that domain.
> Is there anyway I can see servers on the other domains.
> e.g INTTEST\Testmachine is on a different domain, can I get to it in osql
> Any help appreciated.
> MPM
change the sa passwords on all SQL Server Instances on our 3 different
domains.
We have Dev, Test and Prod domains.
When I do an osql -L I only see the SQL servers on that domain.
Is there anyway I can see servers on the other domains.
e.g INTTEST\Testmachine is on a different domain, can I get to it in osql
Any help appreciated.
MPMHi,
That depends up on the way your Trust relation ship is set between domains.
Please contact your system administrator.
Thanks
Hari
SQL Server MVP
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:1280490D-08C4-424D-9202-C4F023C5236C@.microsoft.com...
>I would like to be able to run a script from my machine that would go out
>and
> change the sa passwords on all SQL Server Instances on our 3 different
> domains.
> We have Dev, Test and Prod domains.
> When I do an osql -L I only see the SQL servers on that domain.
> Is there anyway I can see servers on the other domains.
> e.g INTTEST\Testmachine is on a different domain, can I get to it in osql
> Any help appreciated.
> MPM
Saturday, February 25, 2012
osql
I tried to issue this utitlity with T-SQL in my machine, but it asked me the
system administrator's password, how do I know this password at my local SQL
Server ?Alan wrote:
> I tried to issue this utitlity with T-SQL in my machine, but it asked
> me the system administrator's password, how do I know this password
> at my local SQL Server ?
Specify your loing credentials when you call osql. See BOL for more
information.
--
David Gugick
Imceda Software
www.imceda.com|||Alan
You may be able to use the -E switch to connect using a trusted connection.
ie. OSQL -Sservername -E
For a full list of OSQL switches refer to the osql Utility in SQL Server
Books on Line or run OSQL /? from the command line.
--
--
Peter Ward
WARDY IT Solutions
--
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> I tried to issue this utitlity with T-SQL in my machine, but it asked me
the
> system administrator's password, how do I know this password at my local
SQL
> Server ?
>|||YOu may also use a standard SQL login like
osql -SServername -UyourSQLlogin -PPassword
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"P. Ward" <peter@.online.wardyit.com> wrote in message
news:%23aB1XQ9yEHA.2192@.TK2MSFTNGP14.phx.gbl...
> Alan
> You may be able to use the -E switch to connect using a trusted
connection.
> ie. OSQL -Sservername -E
> For a full list of OSQL switches refer to the osql Utility in SQL Server
> Books on Line or run OSQL /? from the command line.
> --
> --
> Peter Ward
> WARDY IT Solutions
> --
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> > I tried to issue this utitlity with T-SQL in my machine, but it asked me
> the
> > system administrator's password, how do I know this password at my local
> SQL
> > Server ?
> >
> >
>
system administrator's password, how do I know this password at my local SQL
Server ?Alan wrote:
> I tried to issue this utitlity with T-SQL in my machine, but it asked
> me the system administrator's password, how do I know this password
> at my local SQL Server ?
Specify your loing credentials when you call osql. See BOL for more
information.
--
David Gugick
Imceda Software
www.imceda.com|||Alan
You may be able to use the -E switch to connect using a trusted connection.
ie. OSQL -Sservername -E
For a full list of OSQL switches refer to the osql Utility in SQL Server
Books on Line or run OSQL /? from the command line.
--
--
Peter Ward
WARDY IT Solutions
--
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> I tried to issue this utitlity with T-SQL in my machine, but it asked me
the
> system administrator's password, how do I know this password at my local
SQL
> Server ?
>|||YOu may also use a standard SQL login like
osql -SServername -UyourSQLlogin -PPassword
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"P. Ward" <peter@.online.wardyit.com> wrote in message
news:%23aB1XQ9yEHA.2192@.TK2MSFTNGP14.phx.gbl...
> Alan
> You may be able to use the -E switch to connect using a trusted
connection.
> ie. OSQL -Sservername -E
> For a full list of OSQL switches refer to the osql Utility in SQL Server
> Books on Line or run OSQL /? from the command line.
> --
> --
> Peter Ward
> WARDY IT Solutions
> --
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> > I tried to issue this utitlity with T-SQL in my machine, but it asked me
> the
> > system administrator's password, how do I know this password at my local
> SQL
> > Server ?
> >
> >
>
osql
I tried to issue this utitlity with T-SQL in my machine, but it asked me the
system administrator's password, how do I know this password at my local SQL
Server ?
Alan wrote:
> I tried to issue this utitlity with T-SQL in my machine, but it asked
> me the system administrator's password, how do I know this password
> at my local SQL Server ?
Specify your loing credentials when you call osql. See BOL for more
information.
David Gugick
Imceda Software
www.imceda.com
|||Alan
You may be able to use the -E switch to connect using a trusted connection.
ie. OSQL -Sservername -E
For a full list of OSQL switches refer to the osql Utility in SQL Server
Books on Line or run OSQL /? from the command line.
--
Peter Ward
WARDY IT Solutions
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> I tried to issue this utitlity with T-SQL in my machine, but it asked me
the
> system administrator's password, how do I know this password at my local
SQL
> Server ?
>
|||YOu may also use a standard SQL login like
osql -SServername -UyourSQLlogin -PPassword
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"P. Ward" <peter@.online.wardyit.com> wrote in message
news:%23aB1XQ9yEHA.2192@.TK2MSFTNGP14.phx.gbl...
> Alan
> You may be able to use the -E switch to connect using a trusted
connection.
> ie. OSQL -Sservername -E
> For a full list of OSQL switches refer to the osql Utility in SQL Server
> Books on Line or run OSQL /? from the command line.
> --
> --
> Peter Ward
> WARDY IT Solutions
> --
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> the
> SQL
>
system administrator's password, how do I know this password at my local SQL
Server ?
Alan wrote:
> I tried to issue this utitlity with T-SQL in my machine, but it asked
> me the system administrator's password, how do I know this password
> at my local SQL Server ?
Specify your loing credentials when you call osql. See BOL for more
information.
David Gugick
Imceda Software
www.imceda.com
|||Alan
You may be able to use the -E switch to connect using a trusted connection.
ie. OSQL -Sservername -E
For a full list of OSQL switches refer to the osql Utility in SQL Server
Books on Line or run OSQL /? from the command line.
--
Peter Ward
WARDY IT Solutions
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> I tried to issue this utitlity with T-SQL in my machine, but it asked me
the
> system administrator's password, how do I know this password at my local
SQL
> Server ?
>
|||YOu may also use a standard SQL login like
osql -SServername -UyourSQLlogin -PPassword
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"P. Ward" <peter@.online.wardyit.com> wrote in message
news:%23aB1XQ9yEHA.2192@.TK2MSFTNGP14.phx.gbl...
> Alan
> You may be able to use the -E switch to connect using a trusted
connection.
> ie. OSQL -Sservername -E
> For a full list of OSQL switches refer to the osql Utility in SQL Server
> Books on Line or run OSQL /? from the command line.
> --
> --
> Peter Ward
> WARDY IT Solutions
> --
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> the
> SQL
>
osql
I tried to issue this utitlity with T-SQL in my machine, but it asked me the
system administrator's password, how do I know this password at my local SQL
Server ?Alan wrote:
> I tried to issue this utitlity with T-SQL in my machine, but it asked
> me the system administrator's password, how do I know this password
> at my local SQL Server ?
Specify your loing credentials when you call osql. See BOL for more
information.
David Gugick
Imceda Software
www.imceda.com|||Alan
You may be able to use the -E switch to connect using a trusted connection.
ie. OSQL -Sservername -E
For a full list of OSQL switches refer to the osql Utility in SQL Server
Books on Line or run OSQL /? from the command line.
--
Peter Ward
WARDY IT Solutions
--
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> I tried to issue this utitlity with T-SQL in my machine, but it asked me
the
> system administrator's password, how do I know this password at my local
SQL
> Server ?
>|||YOu may also use a standard SQL login like
osql -SServername -UyourSQLlogin -PPassword
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"P. Ward" <peter@.online.wardyit.com> wrote in message
news:%23aB1XQ9yEHA.2192@.TK2MSFTNGP14.phx.gbl...
> Alan
> You may be able to use the -E switch to connect using a trusted
connection.
> ie. OSQL -Sservername -E
> For a full list of OSQL switches refer to the osql Utility in SQL Server
> Books on Line or run OSQL /? from the command line.
> --
> --
> Peter Ward
> WARDY IT Solutions
> --
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> the
> SQL
>
system administrator's password, how do I know this password at my local SQL
Server ?Alan wrote:
> I tried to issue this utitlity with T-SQL in my machine, but it asked
> me the system administrator's password, how do I know this password
> at my local SQL Server ?
Specify your loing credentials when you call osql. See BOL for more
information.
David Gugick
Imceda Software
www.imceda.com|||Alan
You may be able to use the -E switch to connect using a trusted connection.
ie. OSQL -Sservername -E
For a full list of OSQL switches refer to the osql Utility in SQL Server
Books on Line or run OSQL /? from the command line.
--
Peter Ward
WARDY IT Solutions
--
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> I tried to issue this utitlity with T-SQL in my machine, but it asked me
the
> system administrator's password, how do I know this password at my local
SQL
> Server ?
>|||YOu may also use a standard SQL login like
osql -SServername -UyourSQLlogin -PPassword
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"P. Ward" <peter@.online.wardyit.com> wrote in message
news:%23aB1XQ9yEHA.2192@.TK2MSFTNGP14.phx.gbl...
> Alan
> You may be able to use the -E switch to connect using a trusted
connection.
> ie. OSQL -Sservername -E
> For a full list of OSQL switches refer to the osql Utility in SQL Server
> Books on Line or run OSQL /? from the command line.
> --
> --
> Peter Ward
> WARDY IT Solutions
> --
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> the
> SQL
>
Subscribe to:
Posts (Atom)