What other applications outside Microsoft products, use MSDE?
Hi,
You're asking a question here that isn't possible to answer. There are a
huge number of software vendors that now use the MSDE as one of their forms
of deployment. A large percentage of SQL Server based applications could be
deployed against the MSDE at the lower end of the market. It's a similar
question to asking "What other applications outside Microsoft products, use
SQL Server?".
Sorry there isn't a simple answer.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Moj_Sharp Labs" <anonymous@.discussions.microsoft.com> wrote in message
news:D1298C09-2F40-4CBA-86F7-96BA7DC09CC5@.microsoft.com...
> What other applications outside Microsoft products, use MSDE?
|||sourcegear's version control system, vault, integrates with msde for
smaller based development shops which do not want to purchase a full sql
server license.
http://www.sourcegear.com/vault/
jeff clausius
sourcegear
"=?Utf-8?B?TW9qX1NoYXJwIExhYnM=?=" <anonymous@.discussions.microsoft.com>
wrote in news:D1298C09-2F40-4CBA-86F7-96BA7DC09CC5@.microsoft.com:
> What other applications outside Microsoft products, use MSDE?
Showing posts with label msde. Show all posts
Showing posts with label msde. Show all posts
Tuesday, March 20, 2012
Monday, March 12, 2012
ot: upgrading msde to SQL Server 2005 Express Edition
has anybody tried to do that yet? any experiences? how-tos?I just moved an MSDE database to SQL2005 Express with noproblems. I created a new instance with SQL2005 Express thendetached the DB from the MSDE instance moved the files and attached itto the Express instance. Everything appears to be working (thoughit is on a dev box).
Only issue to resolve now is backing up the database automatically,Express doesn't have an agent and I haven't found out how to back upthe DB.
HTH
Antony
|||
With back up I have started a sep thread in another forum to try and sort this out.
http://forums.asp.net/1107445/ShowPost.aspx
Antony
Only issue to resolve now is backing up the database automatically,Express doesn't have an agent and I haven't found out how to back upthe DB.
HTH
Antony
|||
thanks'.
backup: i was reading something about the windows task scheduler ...
|||NPWith back up I have started a sep thread in another forum to try and sort this out.
http://forums.asp.net/1107445/ShowPost.aspx
Antony
osql will not come up MSDE (sp3) or earlier
When I try to run osql, I get the following error:
c:\program files\Microsoft SQL Server\80\Tools\Binn\
> osql -E -d CCOP or osql -U sa -P AStrongPassword -d CCOP
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
I can start the instance "CCOP" from sqlmangr without any
issue, but when I try to run osql against the database, I
can never get past the startup
-d is the switch for the database name, not the instance name. Use the -S
switch to specify the instance name.
If you are not sure of the instance name, issue a osql -L for a list of SQL
Server instances.
See
http://msdn.microsoft.com/library/de...ta_01_2r1e.asp
for more information on running the osql utility.
Terri Morton
MVP - ASP/ASP.NET
"Ed H" <anonymous@.discussions.microsoft.com> wrote in message
news:0f4301c4ff5e$4c209930$a401280a@.phx.gbl...
> When I try to run osql, I get the following error:
> c:\program files\Microsoft SQL Server\80\Tools\Binn\
>
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> I can start the instance "CCOP" from sqlmangr without any
> issue, but when I try to run osql against the database, I
> can never get past the startup
|||
>--Original Message--
>-d is the switch for the database name, not the instance
name. Use the -S
>switch to specify the instance name.
>If you are not sure of the instance name, issue a osql -
L for a list of SQL
>Server instances.
>See
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/acdata/ac_8_mta_01_2r1e.asp
>for more information on running the osql utility.
>Terri Morton
>MVP - ASP/ASP.NET
>"Ed H" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:0f4301c4ff5e$4c209930$a401280a@.phx.gbl...
CCOP[vbcol=seagreen]
denied.[vbcol=seagreen]
any[vbcol=seagreen]
database, I
>
>.
> Thx Terri. I had to re-install amoung other things.
The MSDN Help was a very valuable.
c:\program files\Microsoft SQL Server\80\Tools\Binn\
> osql -E -d CCOP or osql -U sa -P AStrongPassword -d CCOP
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
I can start the instance "CCOP" from sqlmangr without any
issue, but when I try to run osql against the database, I
can never get past the startup
-d is the switch for the database name, not the instance name. Use the -S
switch to specify the instance name.
If you are not sure of the instance name, issue a osql -L for a list of SQL
Server instances.
See
http://msdn.microsoft.com/library/de...ta_01_2r1e.asp
for more information on running the osql utility.
Terri Morton
MVP - ASP/ASP.NET
"Ed H" <anonymous@.discussions.microsoft.com> wrote in message
news:0f4301c4ff5e$4c209930$a401280a@.phx.gbl...
> When I try to run osql, I get the following error:
> c:\program files\Microsoft SQL Server\80\Tools\Binn\
>
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> I can start the instance "CCOP" from sqlmangr without any
> issue, but when I try to run osql against the database, I
> can never get past the startup
|||
>--Original Message--
>-d is the switch for the database name, not the instance
name. Use the -S
>switch to specify the instance name.
>If you are not sure of the instance name, issue a osql -
L for a list of SQL
>Server instances.
>See
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/acdata/ac_8_mta_01_2r1e.asp
>for more information on running the osql utility.
>Terri Morton
>MVP - ASP/ASP.NET
>"Ed H" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:0f4301c4ff5e$4c209930$a401280a@.phx.gbl...
CCOP[vbcol=seagreen]
denied.[vbcol=seagreen]
any[vbcol=seagreen]
database, I
>
>.
> Thx Terri. I had to re-install amoung other things.
The MSDN Help was a very valuable.
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
OSQL prompts for password
Hello,
I have a batch file setup for backing up an msde 2000 database but the only
way it will run is by inserting -Usa -Ppassword. I don't want to expose the
sa password and I would like to use windows authentication so I've included
the -E switch. However, it prompts for a password and no matter what I put
in it fails with invalid password and my user login name. The password that
I enter is correct and the server is setup with Windows Authentication. The
batch file is called from an application and I don't want the user to to
have to enter a password, I just want the process to run when started.
Here's How I'm calling the sql script.
OSQL -E -iTestBackup.sql
TIA
Vic
Problem Solved! The switch should be uppercase E and I had lower case which
means echo.
I have a batch file setup for backing up an msde 2000 database but the only
way it will run is by inserting -Usa -Ppassword. I don't want to expose the
sa password and I would like to use windows authentication so I've included
the -E switch. However, it prompts for a password and no matter what I put
in it fails with invalid password and my user login name. The password that
I enter is correct and the server is setup with Windows Authentication. The
batch file is called from an application and I don't want the user to to
have to enter a password, I just want the process to run when started.
Here's How I'm calling the sql script.
OSQL -E -iTestBackup.sql
TIA
Vic
Problem Solved! The switch should be uppercase E and I had lower case which
means echo.
OSQL prompts for password
Hello,
I have a batch file setup for backing up an msde 2000 database but the only
way it will run is by inserting -Usa -Ppassword. I don't want to expose the
sa password and I would like to use windows authentication so I've included
the -E switch. However, it prompts for a password and no matter what I put
in it fails with invalid password and my user login name. The password that
I enter is correct and the server is setup with Windows Authentication. The
batch file is called from an application and I don't want the user to to
have to enter a password, I just want the process to run when started.
Here's How I'm calling the sql script.
OSQL -E -iTestBackup.sql
TIA
VicProblem Solved! The switch should be uppercase E and I had lower case which
means echo.
I have a batch file setup for backing up an msde 2000 database but the only
way it will run is by inserting -Usa -Ppassword. I don't want to expose the
sa password and I would like to use windows authentication so I've included
the -E switch. However, it prompts for a password and no matter what I put
in it fails with invalid password and my user login name. The password that
I enter is correct and the server is setup with Windows Authentication. The
batch file is called from an application and I don't want the user to to
have to enter a password, I just want the process to run when started.
Here's How I'm calling the sql script.
OSQL -E -iTestBackup.sql
TIA
VicProblem Solved! The switch should be uppercase E and I had lower case which
means echo.
OSQL prompts for password
Hello,
I have a batch file setup for backing up an msde 2000 database but the only
way it will run is by inserting -Usa -Ppassword. I don't want to expose the
sa password and I would like to use windows authentication so I've included
the -E switch. However, it prompts for a password and no matter what I put
in it fails with invalid password and my user login name. The password that
I enter is correct and the server is setup with Windows Authentication. The
batch file is called from an application and I don't want the user to to
have to enter a password, I just want the process to run when started.
Here's How I'm calling the sql script.
OSQL -E -iTestBackup.sql
TIA
VicProblem Solved! The switch should be uppercase E and I had lower case which
means echo.
I have a batch file setup for backing up an msde 2000 database but the only
way it will run is by inserting -Usa -Ppassword. I don't want to expose the
sa password and I would like to use windows authentication so I've included
the -E switch. However, it prompts for a password and no matter what I put
in it fails with invalid password and my user login name. The password that
I enter is correct and the server is setup with Windows Authentication. The
batch file is called from an application and I don't want the user to to
have to enter a password, I just want the process to run when started.
Here's How I'm calling the sql script.
OSQL -E -iTestBackup.sql
TIA
VicProblem Solved! The switch should be uppercase E and I had lower case which
means echo.
Wednesday, March 7, 2012
osql login with an instance
Our software installs a copy of MSDE 2000 on the clients computer during
install. On several of the computers I can not log in to the server via
osql (or my software).
The problem seems to be referencing the instance. The instance is {computer
name}\RR, so for example the guy I currently have trouble with his computer
name is AUTOMGR so I should be able to log in with:
OSQL -S AUTOMGR\RR -E
but when I try it returns:
Login failed for user 'AUTOMGR\Greg'.
Same if I try -U sa -P XXXXXX instead of -E
Where Greg I think is his login name.
So it ignores my instance name and uses Greg, I have this happening with
several of my customers.
Does anyone have any ideas?
Thanks in advance,
Rob
That was the whole error, I copied and pasted the screen when it happened,
this is from that session:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Greg>hostname
AUTOMGR
C:\Documents and Settings\Greg>osql -S automgr\rr -E
Login failed for user 'AUTOMGR\Greg'.
C:\Documents and Settings\Greg>
RR should be our instance. The instance looks to be installed when I look
at the folders.
If this is not enough info, then I will need to wait until another user
reports it and I can investigate further.
If that is so, do you have an things you think I should look at?
e.g. How the registry looks, folder structure, is it in add and remove
programs, etc.
Thanks,
Rob
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:4vvr0mF1e0dvpU1@.mid.individual.net...
> hi,
> Rob wrote:
> 'AUTOMGR\Greg' is not related to the istance (default or named) but
> actually is the WinNT login name..
> can you please provide the "full" exception message?
> thank you
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
|||I will check in to this. thanks for you help.
BTW- I really like your DbaMgr2K; thanks.
-Rob
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:50028gF1e4bv2U1@.mid.individual.net...
> hi,
> Rob wrote:
> ok... by default MSDE setup generates a group login for
> Bulitin\Administrators, so that all local WinNT login members of that
> group are allowed to connect to the installed instance.. but other kind of
> WinNT logins are not granted login permissions as well... is "Greg" member
> of that WinNT group?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
install. On several of the computers I can not log in to the server via
osql (or my software).
The problem seems to be referencing the instance. The instance is {computer
name}\RR, so for example the guy I currently have trouble with his computer
name is AUTOMGR so I should be able to log in with:
OSQL -S AUTOMGR\RR -E
but when I try it returns:
Login failed for user 'AUTOMGR\Greg'.
Same if I try -U sa -P XXXXXX instead of -E
Where Greg I think is his login name.
So it ignores my instance name and uses Greg, I have this happening with
several of my customers.
Does anyone have any ideas?
Thanks in advance,
Rob
That was the whole error, I copied and pasted the screen when it happened,
this is from that session:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Greg>hostname
AUTOMGR
C:\Documents and Settings\Greg>osql -S automgr\rr -E
Login failed for user 'AUTOMGR\Greg'.
C:\Documents and Settings\Greg>
RR should be our instance. The instance looks to be installed when I look
at the folders.
If this is not enough info, then I will need to wait until another user
reports it and I can investigate further.
If that is so, do you have an things you think I should look at?
e.g. How the registry looks, folder structure, is it in add and remove
programs, etc.
Thanks,
Rob
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:4vvr0mF1e0dvpU1@.mid.individual.net...
> hi,
> Rob wrote:
> 'AUTOMGR\Greg' is not related to the istance (default or named) but
> actually is the WinNT login name..
> can you please provide the "full" exception message?
> thank you
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
|||I will check in to this. thanks for you help.
BTW- I really like your DbaMgr2K; thanks.
-Rob
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:50028gF1e4bv2U1@.mid.individual.net...
> hi,
> Rob wrote:
> ok... by default MSDE setup generates a group login for
> Bulitin\Administrators, so that all local WinNT login members of that
> group are allowed to connect to the installed instance.. but other kind of
> WinNT logins are not granted login permissions as well... is "Greg" member
> of that WinNT group?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
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 fails silently
Hello,
I have a InstallShield program that installs MSDE and then creates a new
database in it. To set up the new database on MSDE I run OSQL. Most of the
time, OSQL works OK. But, sometimes it fails and doesn't print out any
error messages (in the output file).
Has anyone seen this intermittant silent failure behavior before?
The OSQL command I use is:
OSQL.EXE -E -b -i SetupRTEDatabase.sql -o SetupRTEDatabase.log
Regards,
RobertHi Robert
You don't say if you check ERRORLEVEL after the call?
How large the input file?
Have you tried the -e parameter to see the commands?
John
"Robert Wheadon" wrote:
> Hello,
> I have a InstallShield program that installs MSDE and then creates a new
> database in it. To set up the new database on MSDE I run OSQL. Most of t
he
> time, OSQL works OK. But, sometimes it fails and doesn't print out any
> error messages (in the output file).
> Has anyone seen this intermittant silent failure behavior before?
> The OSQL command I use is:
> OSQL.EXE -E -b -i SetupRTEDatabase.sql -o SetupRTEDatabase.log
> Regards,
> Robert
>
>|||Hello John,
> You don't say if you check ERRORLEVEL after the call?
>
Yes, I do. When OSQL decides to fail, I get an ERRORLEVEL of 1.
> How large the input file?
>
10 KB
> Have you tried the -e parameter to see the commands?
>
No. I hadn't thought of that.|||Hi
Non zero values of ERRORLEVEL indicate and error. Have you checked the
output for Msg?
OSQL can have issues with larger files, you may want to split your script
into multiple files and run them separately.
You may also want to specify -n to get cleaner output.
John
"Robert Wheadon" wrote:
> Hello John,
>
> Yes, I do. When OSQL decides to fail, I get an ERRORLEVEL of 1.
>
> 10 KB
>
> No. I hadn't thought of that.
>
>|||I've sorted this one out. See my post "OSQL returns error code of 1 -
intermittently.
SysInternals' FileMonitor and ProcessMonitor tools were helpful in finding
the problem.
"Robert Wheadon" <robert.wheadon@.monitorbm.co.nz> wrote in message
news:eslJ5B3UGHA.4772@.TK2MSFTNGP14.phx.gbl...
> Hello John,
>
> Yes, I do. When OSQL decides to fail, I get an ERRORLEVEL of 1.
>
> 10 KB
>
> No. I hadn't thought of that.
>
I have a InstallShield program that installs MSDE and then creates a new
database in it. To set up the new database on MSDE I run OSQL. Most of the
time, OSQL works OK. But, sometimes it fails and doesn't print out any
error messages (in the output file).
Has anyone seen this intermittant silent failure behavior before?
The OSQL command I use is:
OSQL.EXE -E -b -i SetupRTEDatabase.sql -o SetupRTEDatabase.log
Regards,
RobertHi Robert
You don't say if you check ERRORLEVEL after the call?
How large the input file?
Have you tried the -e parameter to see the commands?
John
"Robert Wheadon" wrote:
> Hello,
> I have a InstallShield program that installs MSDE and then creates a new
> database in it. To set up the new database on MSDE I run OSQL. Most of t
he
> time, OSQL works OK. But, sometimes it fails and doesn't print out any
> error messages (in the output file).
> Has anyone seen this intermittant silent failure behavior before?
> The OSQL command I use is:
> OSQL.EXE -E -b -i SetupRTEDatabase.sql -o SetupRTEDatabase.log
> Regards,
> Robert
>
>|||Hello John,
> You don't say if you check ERRORLEVEL after the call?
>
Yes, I do. When OSQL decides to fail, I get an ERRORLEVEL of 1.
> How large the input file?
>
10 KB
> Have you tried the -e parameter to see the commands?
>
No. I hadn't thought of that.|||Hi
Non zero values of ERRORLEVEL indicate and error. Have you checked the
output for Msg?
OSQL can have issues with larger files, you may want to split your script
into multiple files and run them separately.
You may also want to specify -n to get cleaner output.
John
"Robert Wheadon" wrote:
> Hello John,
>
> Yes, I do. When OSQL decides to fail, I get an ERRORLEVEL of 1.
>
> 10 KB
>
> No. I hadn't thought of that.
>
>|||I've sorted this one out. See my post "OSQL returns error code of 1 -
intermittently.
SysInternals' FileMonitor and ProcessMonitor tools were helpful in finding
the problem.
"Robert Wheadon" <robert.wheadon@.monitorbm.co.nz> wrote in message
news:eslJ5B3UGHA.4772@.TK2MSFTNGP14.phx.gbl...
> Hello John,
>
> Yes, I do. When OSQL decides to fail, I get an ERRORLEVEL of 1.
>
> 10 KB
>
> No. I hadn't thought of that.
>
OSQL compact database
please help
Osql command?
how can I compact a msde database
like I do with access database
osql -E -Q "DBCC SHRINKDATABASE (db_name)"
Jacco Schalkwijk
SQL Server MVP
"Carlos AZ" <CarlosAZ@.discussions.microsoft.com> wrote in message
news:5D9C3029-BA92-4954-BB2A-C683C1D09591@.microsoft.com...
> please help
> Osql command?
> how can I compact a msde database
> like I do with access database
>
|||Hi,
To add on to Jacco, do the steps below shrinking:-
1. Backup the transaction log if the database is not SIMPLE recovery
2. Use either DBCC SHRINKDATABASE or DBCC SHRINKFILE (See books online for
usage)
Thanks
Hari
SQL Server DBA
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:ux%23r82nPFHA.1392@.TK2MSFTNGP10.phx.gbl...
> osql -E -Q "DBCC SHRINKDATABASE (db_name)"
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Carlos AZ" <CarlosAZ@.discussions.microsoft.com> wrote in message
> news:5D9C3029-BA92-4954-BB2A-C683C1D09591@.microsoft.com...
>
Osql command?
how can I compact a msde database
like I do with access database
osql -E -Q "DBCC SHRINKDATABASE (db_name)"
Jacco Schalkwijk
SQL Server MVP
"Carlos AZ" <CarlosAZ@.discussions.microsoft.com> wrote in message
news:5D9C3029-BA92-4954-BB2A-C683C1D09591@.microsoft.com...
> please help
> Osql command?
> how can I compact a msde database
> like I do with access database
>
|||Hi,
To add on to Jacco, do the steps below shrinking:-
1. Backup the transaction log if the database is not SIMPLE recovery
2. Use either DBCC SHRINKDATABASE or DBCC SHRINKFILE (See books online for
usage)
Thanks
Hari
SQL Server DBA
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:ux%23r82nPFHA.1392@.TK2MSFTNGP10.phx.gbl...
> osql -E -Q "DBCC SHRINKDATABASE (db_name)"
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Carlos AZ" <CarlosAZ@.discussions.microsoft.com> wrote in message
> news:5D9C3029-BA92-4954-BB2A-C683C1D09591@.microsoft.com...
>
Saturday, February 25, 2012
Osql
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 ?
peetthrough a *.bat file?|||through a *.bat file?
Ok, how ?
From what I see I have to do the following :
'**************** sample ********************
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
D:\>osql -S PEETSPC\PEETSQL -U sa
Password:
1> sp_attach_single_file_db "TEST","D:\DB\TEST.MDF"
2> go
New log file 'D:\DB\TEST_log.LDF' was created.
1> exit
D:\>osql -S PEETSPC\PEETSQL -U sa -d TEST
Password:
1> sp_addlogin test, mypass, TEST
2> sp_adduser test, test, db_owner
3> go
1> sp_addlogin test, mypass, TEST
2> go
New login created.
1> sp_adduser test, test, db_owner
2> go
Granted database access to 'test'.
'test' added to role 'db_owner'.
1> exit
D:\>
How can I do this using a bat file ?
I know what a bat file is, but I do not see how I can get a bat file to do the above. Please help me out if you can :-)
peet|||*bump*
anyone ?|||You need two separate files. The first one I'll calll test.sql will contain:sp_attach_single_file_db "TEST","D:\DB\TEST.MDF"
go
USE TEST
GO
sp_addlogin test, mypass, TEST
sp_adduser test, test, db_owner
go
sp_addlogin test, mypass, TEST
go
sp_adduser test, test, db_owner
goThe second file I'll call test.bat:osql -S PEETSPC\PEETSQL -U sa - P myPass=123 -i test.sql -o test.rptWhen you run the batch file, it will create the database, add the logins and users, and put the output into the test.rpt file for your reading pleasure.
-PatP
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 ?
peetthrough a *.bat file?|||through a *.bat file?
Ok, how ?
From what I see I have to do the following :
'**************** sample ********************
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
D:\>osql -S PEETSPC\PEETSQL -U sa
Password:
1> sp_attach_single_file_db "TEST","D:\DB\TEST.MDF"
2> go
New log file 'D:\DB\TEST_log.LDF' was created.
1> exit
D:\>osql -S PEETSPC\PEETSQL -U sa -d TEST
Password:
1> sp_addlogin test, mypass, TEST
2> sp_adduser test, test, db_owner
3> go
1> sp_addlogin test, mypass, TEST
2> go
New login created.
1> sp_adduser test, test, db_owner
2> go
Granted database access to 'test'.
'test' added to role 'db_owner'.
1> exit
D:\>
How can I do this using a bat file ?
I know what a bat file is, but I do not see how I can get a bat file to do the above. Please help me out if you can :-)
peet|||*bump*
anyone ?|||You need two separate files. The first one I'll calll test.sql will contain:sp_attach_single_file_db "TEST","D:\DB\TEST.MDF"
go
USE TEST
GO
sp_addlogin test, mypass, TEST
sp_adduser test, test, db_owner
go
sp_addlogin test, mypass, TEST
go
sp_adduser test, test, db_owner
goThe second file I'll call test.bat:osql -S PEETSPC\PEETSQL -U sa - P myPass=123 -i test.sql -o test.rptWhen you run the batch file, it will create the database, add the logins and users, and put the output into the test.rpt file for your reading pleasure.
-PatP
Subscribe to:
Posts (Atom)