This is a dumb question but I need to ask. Does SQL Server
2000 MSDE version comes with 'pubs' and 'Northwind'
databases '
Thanks.Hi Dan,
No, They will not be installed on setup. You can get the install scripts
from C:\Program Files\Microsoft SQL Server\MSSQL\Install.
They file names are:
instpubs.sql
instnwnd.sql
Otherwise get the latest scripts from microsoft site
http://www.microsoft.com/downloads/...&displaylang=en
Use OSQL frommd prompt to execute the script to create database and objects.
Thanks
Hari
SQL Server MVP
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:113c01c53c39$182a3970$a401280a@.phx.gbl...
> This is a dumb question but I need to ask. Does SQL Server
> 2000 MSDE version comes with 'pubs' and 'Northwind'
> databases '
> Thanks.|||Thanks.........
>--Original Message--
>Hi Dan,
>No, They will not be installed on setup. You can get the
install scripts
>from C:\Program Files\Microsoft SQL Server\MSSQL\Install.
>They file names are:
>instpubs.sql
>instnwnd.sql
>Otherwise get the latest scripts from microsoft site
>http://www.microsoft.com/downloads/details.aspx?
FamilyId=06616212-0356-46A0-8DA2-
EEBC53A68034&displaylang=en
>Use OSQL frommd prompt to execute the script to create
database and objects.
>Thanks
>Hari
>SQL Server MVP
>
>"Dan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:113c01c53c39$182a3970$a401280a@.phx.gbl...
Server[vbcol=seagreen]
>
>.
>
Showing posts with label msde. Show all posts
Showing posts with label msde. Show all posts
Sunday, March 11, 2012
dumb question
Hello, I'm an MSDE n00b but I do have a basic understanding of SQL Server
2000. I have used Enterprise manager to create/manage users/permissions and
replication before. I am however not familiar with MSDE. I am using MSDE
because I'm playing with asp.net. Since there is no user interface I am
lost. I created my tables and stored procedures via the Web Matrix asp.net
development tool.
1) I need to configure the MSDE 2000 installation user access. Its currently
setup for integrated windows authentication, which I want to keep. But how
do I add/manage the users and their permissions. For example with Enterprise
Manager, even with Integrated authentication, you have to add the
users/groups from your windows domain before SQL server can use them. Do I
need to do this in MSDE? how?
2) how can I view current user accounts on the system? and their
permissions?
3) while I'm at it here... how can I retrieve the currently logged in user
from my asp.net web application?
any info is appreciated. Thanks.
If you have a copy of Enterprise Manager on a different machine you should be
able to connect to the msde install and see it in the familar enterprise
manager.
"djc" wrote:
> Hello, I'm an MSDE n00b but I do have a basic understanding of SQL Server
> 2000. I have used Enterprise manager to create/manage users/permissions and
> replication before. I am however not familiar with MSDE. I am using MSDE
> because I'm playing with asp.net. Since there is no user interface I am
> lost. I created my tables and stored procedures via the Web Matrix asp.net
> development tool.
> 1) I need to configure the MSDE 2000 installation user access. Its currently
> setup for integrated windows authentication, which I want to keep. But how
> do I add/manage the users and their permissions. For example with Enterprise
> Manager, even with Integrated authentication, you have to add the
> users/groups from your windows domain before SQL server can use them. Do I
> need to do this in MSDE? how?
> 2) how can I view current user accounts on the system? and their
> permissions?
> 3) while I'm at it here... how can I retrieve the currently logged in user
> from my asp.net web application?
> any info is appreciated. Thanks.
>
>
|||hi,
txghia58 wrote:
> If you have a copy of Enterprise Manager on a different machine you
> should be able to connect to the msde install and see it in the
> familar enterprise manager.
bu only in development/test scenario... you are not licensed to use SQL
Server Client Tools in production...
you have to resort on home made tools and/or 3rd party tools to manage MSDE
in production...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
2000. I have used Enterprise manager to create/manage users/permissions and
replication before. I am however not familiar with MSDE. I am using MSDE
because I'm playing with asp.net. Since there is no user interface I am
lost. I created my tables and stored procedures via the Web Matrix asp.net
development tool.
1) I need to configure the MSDE 2000 installation user access. Its currently
setup for integrated windows authentication, which I want to keep. But how
do I add/manage the users and their permissions. For example with Enterprise
Manager, even with Integrated authentication, you have to add the
users/groups from your windows domain before SQL server can use them. Do I
need to do this in MSDE? how?
2) how can I view current user accounts on the system? and their
permissions?
3) while I'm at it here... how can I retrieve the currently logged in user
from my asp.net web application?
any info is appreciated. Thanks.
If you have a copy of Enterprise Manager on a different machine you should be
able to connect to the msde install and see it in the familar enterprise
manager.
"djc" wrote:
> Hello, I'm an MSDE n00b but I do have a basic understanding of SQL Server
> 2000. I have used Enterprise manager to create/manage users/permissions and
> replication before. I am however not familiar with MSDE. I am using MSDE
> because I'm playing with asp.net. Since there is no user interface I am
> lost. I created my tables and stored procedures via the Web Matrix asp.net
> development tool.
> 1) I need to configure the MSDE 2000 installation user access. Its currently
> setup for integrated windows authentication, which I want to keep. But how
> do I add/manage the users and their permissions. For example with Enterprise
> Manager, even with Integrated authentication, you have to add the
> users/groups from your windows domain before SQL server can use them. Do I
> need to do this in MSDE? how?
> 2) how can I view current user accounts on the system? and their
> permissions?
> 3) while I'm at it here... how can I retrieve the currently logged in user
> from my asp.net web application?
> any info is appreciated. Thanks.
>
>
|||hi,
txghia58 wrote:
> If you have a copy of Enterprise Manager on a different machine you
> should be able to connect to the msde install and see it in the
> familar enterprise manager.
bu only in development/test scenario... you are not licensed to use SQL
Server Client Tools in production...
you have to resort on home made tools and/or 3rd party tools to manage MSDE
in production...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Dumb Question
This is a dumb question but I need to ask. Does SQL Server
2000 MSDE version comes with 'pubs' and 'Northwind'
databases ?
Thanks.
Hi Dan,
No, They will not be installed on setup. You can get the install scripts
from C:\Program Files\Microsoft SQL Server\MSSQL\Install.
They file names are:
instpubs.sql
instnwnd.sql
Otherwise get the latest scripts from microsoft site
http://www.microsoft.com/downloads/d...displaylang=en
Use OSQL frommd prompt to execute the script to create database and objects.
Thanks
Hari
SQL Server MVP
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:113c01c53c39$182a3970$a401280a@.phx.gbl...
> This is a dumb question but I need to ask. Does SQL Server
> 2000 MSDE version comes with 'pubs' and 'Northwind'
> databases ?
> Thanks.
|||Thanks.........
>--Original Message--
>Hi Dan,
>No, They will not be installed on setup. You can get the
install scripts
>from C:\Program Files\Microsoft SQL Server\MSSQL\Install.
>They file names are:
>instpubs.sql
>instnwnd.sql
>Otherwise get the latest scripts from microsoft site
>http://www.microsoft.com/downloads/details.aspx?
FamilyId=06616212-0356-46A0-8DA2-
EEBC53A68034&displaylang=en
>Use OSQL frommd prompt to execute the script to create
database and objects.
>Thanks
>Hari
>SQL Server MVP
>
>"Dan" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:113c01c53c39$182a3970$a401280a@.phx.gbl...
Server
>
>.
>
2000 MSDE version comes with 'pubs' and 'Northwind'
databases ?
Thanks.
Hi Dan,
No, They will not be installed on setup. You can get the install scripts
from C:\Program Files\Microsoft SQL Server\MSSQL\Install.
They file names are:
instpubs.sql
instnwnd.sql
Otherwise get the latest scripts from microsoft site
http://www.microsoft.com/downloads/d...displaylang=en
Use OSQL frommd prompt to execute the script to create database and objects.
Thanks
Hari
SQL Server MVP
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:113c01c53c39$182a3970$a401280a@.phx.gbl...
> This is a dumb question but I need to ask. Does SQL Server
> 2000 MSDE version comes with 'pubs' and 'Northwind'
> databases ?
> Thanks.
|||Thanks.........
>--Original Message--
>Hi Dan,
>No, They will not be installed on setup. You can get the
install scripts
>from C:\Program Files\Microsoft SQL Server\MSSQL\Install.
>They file names are:
>instpubs.sql
>instnwnd.sql
>Otherwise get the latest scripts from microsoft site
>http://www.microsoft.com/downloads/details.aspx?
FamilyId=06616212-0356-46A0-8DA2-
EEBC53A68034&displaylang=en
>Use OSQL frommd prompt to execute the script to create
database and objects.
>Thanks
>Hari
>SQL Server MVP
>
>"Dan" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:113c01c53c39$182a3970$a401280a@.phx.gbl...
Server
>
>.
>
Dumb Question
This is a dumb question but I need to ask. Does SQL Server
2000 MSDE version comes with 'pubs' and 'Northwind'
databases '
Thanks.Hi Dan,
No, They will not be installed on setup. You can get the install scripts
from C:\Program Files\Microsoft SQL Server\MSSQL\Install.
They file names are:
instpubs.sql
instnwnd.sql
Otherwise get the latest scripts from microsoft site
http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en
Use OSQL frommd prompt to execute the script to create database and objects.
Thanks
Hari
SQL Server MVP
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:113c01c53c39$182a3970$a401280a@.phx.gbl...
> This is a dumb question but I need to ask. Does SQL Server
> 2000 MSDE version comes with 'pubs' and 'Northwind'
> databases '
> Thanks.|||Thanks.........
>--Original Message--
>Hi Dan,
>No, They will not be installed on setup. You can get the
install scripts
>from C:\Program Files\Microsoft SQL Server\MSSQL\Install.
>They file names are:
>instpubs.sql
>instnwnd.sql
>Otherwise get the latest scripts from microsoft site
>http://www.microsoft.com/downloads/details.aspx?
FamilyId=06616212-0356-46A0-8DA2-
EEBC53A68034&displaylang=en
>Use OSQL frommd prompt to execute the script to create
database and objects.
>Thanks
>Hari
>SQL Server MVP
>
>"Dan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:113c01c53c39$182a3970$a401280a@.phx.gbl...
>> This is a dumb question but I need to ask. Does SQL
Server
>> 2000 MSDE version comes with 'pubs' and 'Northwind'
>> databases '
>> Thanks.
>
>.
>
2000 MSDE version comes with 'pubs' and 'Northwind'
databases '
Thanks.Hi Dan,
No, They will not be installed on setup. You can get the install scripts
from C:\Program Files\Microsoft SQL Server\MSSQL\Install.
They file names are:
instpubs.sql
instnwnd.sql
Otherwise get the latest scripts from microsoft site
http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en
Use OSQL frommd prompt to execute the script to create database and objects.
Thanks
Hari
SQL Server MVP
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:113c01c53c39$182a3970$a401280a@.phx.gbl...
> This is a dumb question but I need to ask. Does SQL Server
> 2000 MSDE version comes with 'pubs' and 'Northwind'
> databases '
> Thanks.|||Thanks.........
>--Original Message--
>Hi Dan,
>No, They will not be installed on setup. You can get the
install scripts
>from C:\Program Files\Microsoft SQL Server\MSSQL\Install.
>They file names are:
>instpubs.sql
>instnwnd.sql
>Otherwise get the latest scripts from microsoft site
>http://www.microsoft.com/downloads/details.aspx?
FamilyId=06616212-0356-46A0-8DA2-
EEBC53A68034&displaylang=en
>Use OSQL frommd prompt to execute the script to create
database and objects.
>Thanks
>Hari
>SQL Server MVP
>
>"Dan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:113c01c53c39$182a3970$a401280a@.phx.gbl...
>> This is a dumb question but I need to ask. Does SQL
Server
>> 2000 MSDE version comes with 'pubs' and 'Northwind'
>> databases '
>> Thanks.
>
>.
>
Sunday, February 19, 2012
DTS with SQL Express
We have build a conversion for our customers to convert their data from our existing database system to Microsoft SQL. We've tested it with MSDE and SQL Server 2000. We based this conversion off of 183 separate DTS scripts saved as VB 6 files. We then heavily customized them to produce a final EXE in VB 6 that our end-users can run. They answer a few questions and then poof, SQL database. Works great.
Now enter SQL Server and SQL Express 2005. With no support for DTS in Express we expect out VB application will fail to execute. As 80% of our customers are MSDE/SQLExpress level customers, this is a real problem for us.
What are my options here?
When SQL Server 2005 ships, we will simultaneously release a "Backward Compatibility" redist. It will be available on the web and will contain, among other things, the same updated DTS 2000 binaries that are installed with SQL 2005.
|||That is really fantastic news. Thank you.
Subscribe to:
Posts (Atom)