Managing SQL 2000 databases on Vista...

I have one database at an ISP running on a SQL 2000 server. Under Windows XP Pro, I installed SQL 2000 administrative tools then I could use the database manager as well as the query tool to manage my database.

I have upgraded my machine to Windows Vista Ultimate. SQL 2000 client services won't install under Windows Vista.

Under Windows Vista, I was able to create an ODBC component that connected successfully to the SQL 2000 remote database, but I no longer have a transaction tool or a gui to manage the tables.

My goals are simple: I want to be able to view/add/drop tables and data using some sort of GUI. I would also like to have some sort of SQL transaction client. I don't need to do any high level database management, just view/change/add/delete tables in the one database that I own on that server.

My isp is NOT going to upgrade their SQL. I do not own Microsoft Access or Microsoft Excel. What FREE software options do I have, given my goals?

You can use SQL Server Management Studio Express, which you can obtain for free at http://msdn.microsoft.com/vstudio/express/sql/download/

Thanks,

Peter Saddow

|||That works absolutely perfectly. Thank you!
|||Although now I have another question since I've played with it a bit.

Is there an easy way to import and export data from tables using this tool? Like... if the data was in a comma delimited text file, for example? So far I've not been able to find a way to do this... I can edit the table data which is good but what if i have a massive text file I want to import....?
|||

You can use the bcp utility: http://msdn2.microsoft.com/en-us/library/ms162802.aspx

Additional, you can download the eval version of the full SQL Server product.

Thanks,

Peter Saddow

|||The BCP utility is part of the database install disk for SQL server. I only have the 2000 version, not the 2005 version.

Downloading Eval version isnt' a permanent solution...

I did purchase MS Office Excel 2007... and I can create an ODBC link to the database and grab table data... but if I edit the table I can't seem to find a way to get it to save those changes back to the table directly?
|||Hmm anybody? No response yet....

Managing SQL 2000 databases on Vista...

I have one database at an ISP running on a SQL 2000 server. Under Windows XP Pro, I installed SQL 2000 administrative tools then I could use the database manager as well as the query tool to manage my database.

I have upgraded my machine to Windows Vista Ultimate. SQL 2000 client services won't install under Windows Vista.

Under Windows Vista, I was able to create an ODBC component that connected successfully to the SQL 2000 remote database, but I no longer have a transaction tool or a gui to manage the tables.

My goals are simple: I want to be able to view/add/drop tables and data using some sort of GUI. I would also like to have some sort of SQL transaction client. I don't need to do any high level database management, just view/change/add/delete tables in the one database that I own on that server.

My isp is NOT going to upgrade their SQL. I do not own Microsoft Access or Microsoft Excel. What FREE software options do I have, given my goals?

You can use SQL Server Management Studio Express, which you can obtain for free at http://msdn.microsoft.com/vstudio/express/sql/download/

Thanks,

Peter Saddow

|||That works absolutely perfectly. Thank you!|||Although now I have another question since I've played with it a bit.

Is there an easy way to import and export data from tables using this tool? Like... if the data was in a comma delimited text file, for example? So far I've not been able to find a way to do this... I can edit the table data which is good but what if i have a massive text file I want to import....?|||

You can use the bcp utility: http://msdn2.microsoft.com/en-us/library/ms162802.aspx

Additional, you can download the eval version of the full SQL Server product.

Thanks,

Peter Saddow

|||The BCP utility is part of the database install disk for SQL server. I only have the 2000 version, not the 2005 version.

Downloading Eval version isnt' a permanent solution...

I did purchase MS Office Excel 2007... and I can create an ODBC link to the database and grab table data... but if I edit the table I can't seem to find a way to get it to save those changes back to the table directly?|||Hmm anybody? No response yet....

Managing SQL 2000 databases on Vista...

I have one database at an ISP running on a SQL 2000 server. Under Windows XP Pro, I installed SQL 2000 administrative tools then I could use the database manager as well as the query tool to manage my database.

I have upgraded my machine to Windows Vista Ultimate. SQL 2000 client services won't install under Windows Vista.

Under Windows Vista, I was able to create an ODBC component that connected successfully to the SQL 2000 remote database, but I no longer have a transaction tool or a gui to manage the tables.

My goals are simple: I want to be able to view/add/drop tables and data using some sort of GUI. I would also like to have some sort of SQL transaction client. I don't need to do any high level database management, just view/change/add/delete tables in the one database that I own on that server.

My isp is NOT going to upgrade their SQL. I do not own Microsoft Access or Microsoft Excel. What FREE software options do I have, given my goals?

You can use SQL Server Management Studio Express, which you can obtain for free at http://msdn.microsoft.com/vstudio/express/sql/download/

Thanks,

Peter Saddow

|||That works absolutely perfectly. Thank you!|||Although now I have another question since I've played with it a bit.

Is there an easy way to import and export data from tables using this tool? Like... if the data was in a comma delimited text file, for example? So far I've not been able to find a way to do this... I can edit the table data which is good but what if i have a massive text file I want to import....?|||

You can use the bcp utility: http://msdn2.microsoft.com/en-us/library/ms162802.aspx

Additional, you can download the eval version of the full SQL Server product.

Thanks,

Peter Saddow

|||The BCP utility is part of the database install disk for SQL server. I only have the 2000 version, not the 2005 version.

Downloading Eval version isnt' a permanent solution...

I did purchase MS Office Excel 2007... and I can create an ODBC link to the database and grab table data... but if I edit the table I can't seem to find a way to get it to save those changes back to the table directly?|||Hmm anybody? No response yet....

Managing PK/FK Relationships with the Tools

Ah, why doesn't SQL Server Management Studio (SSMS) or Visual Studio's Server Explorer permit me to set PK/FK constraints on the tables? They're supported in SQL Everywhere (SQL Ev), but I don't see a way to set them up.

Why don't these tools support scripting the database tables to SQL? Is this planned?

Bill,

Obviously Microsoft will have to address the why, but in terms of the how, there is a nice third party tool that might help you out. See www.primeworks.pt.

You are correct though, the degree to which you can manage constraints on SQL Mobile databases in SQL Server 2005 Management Studio is limited unless you write the DDL yourself. VS2005 is even more limited.

Darren

|||I took a quick look at the primeworks utilities. Yes, I think that's probably the best answer. Thankfully, the third-party community can step in where MS falls short. Hopefully the "Data Dude" (I hate that name) code will help, but it's gross overkill for most SQLCE developers--it's like sending a patient to an ICU for a stubbed toe.

Management tools SQL2005 and table ovner name dbo.tablename.

Hei all
Using the new SQL Server2005 Management tools to view and edit
tables/storedprosedures it automatically prefix the table and SP names with
the ovner name. We usually type the first letters of the tablename to find
the table name. Now we have to start with dbo.tablename every time. Is there
a setting to get rid of this ovner name in this list?
thanx all
geirFor 'normal' users in the database, you can specify a default schema:
use master
create login user1 with password = 'bla'
use adventureworks
create user user1
alter user user1 with default_schema = person
Given that proper permissions are in place, user1 can now:
select * from address
where the actually table name is person.address.
Default schema is ignored for members of 'sysadmin'. All members of the
sysadmin fixed server role have a default schema of dbo.
Hope this helps,
Hans
"Geir Holme" <geir@.multicase.no> wrote in message
news:%231jTdJMgGHA.5088@.TK2MSFTNGP02.phx.gbl...
> Hei all
> Using the new SQL Server2005 Management tools to view and edit
> tables/storedprosedures it automatically prefix the table and SP names
> with the ovner name. We usually type the first letters of the tablename to
> find the table name. Now we have to start with dbo.tablename every time.
> Is there a setting to get rid of this ovner name in this list?
> thanx all
> geir
>|||Hi Hans.
Thanx for your reply.
Mabe I don't explain good enough. The short version is:
In the Management tools (Enterprice manger on sql2000) I don't want to see
the owner of the tables and SP' in the list. Can I remove this.
Why?
Because when I want to look up a table I just writes the name and it
"autosearches" the tablename. In SQL2005 I have to start with dbo.tablename
every time. I want to scip dbo. and just write the tablename to find my
table and edit it. The same for procedures.
regards
geir
"Hans Dingemans" <hans_dingemans@.hotmail.com> wrote in message
news:%23m0$VnMgGHA.1204@.TK2MSFTNGP02.phx.gbl...
> For 'normal' users in the database, you can specify a default schema:
> use master
> create login user1 with password = 'bla'
> use adventureworks
> create user user1
> alter user user1 with default_schema = person
> Given that proper permissions are in place, user1 can now:
> select * from address
> where the actually table name is person.address.
> Default schema is ignored for members of 'sysadmin'. All members of the
> sysadmin fixed server role have a default schema of dbo.
> Hope this helps,
> Hans
> "Geir Holme" <geir@.multicase.no> wrote in message
> news:%231jTdJMgGHA.5088@.TK2MSFTNGP02.phx.gbl...
>> Hei all
>> Using the new SQL Server2005 Management tools to view and edit
>> tables/storedprosedures it automatically prefix the table and SP names
>> with the ovner name. We usually type the first letters of the tablename
>> to find the table name. Now we have to start with dbo.tablename every
>> time. Is there a setting to get rid of this ovner name in this list?
>> thanx all
>> geir
>

Management tools is installed but i cant find it...

Hello
I just installed Visual Studio 2005 Rc1, after that i installed Sql server
2005 september ctp.
Everything worked out fine and i installed everyprogram and all the tools
from sql server 2005 september ctp.
But when i try to find management studio i cant find it... its not under
Start Menu\Programs\Microsoft SQL Server 2005 CTP
the only thing thats under Microsoft SQL Server 2005 CTP is configuration
tools...
do i need to do some configuration to make management studio works?
On Fri, 7 Oct 2005 05:43:02 -0700, Diffen
<Diffen@.discussions.microsoft.com> wrote:

>Hello
>I just installed Visual Studio 2005 Rc1, after that i installed Sql server
>2005 september ctp.
>Everything worked out fine and i installed everyprogram and all the tools
>from sql server 2005 september ctp.
>But when i try to find management studio i cant find it... its not under
>Start Menu\Programs\Microsoft SQL Server 2005 CTP
>the only thing thats under Microsoft SQL Server 2005 CTP is configuration
>tools...
>do i need to do some configuration to make management studio works?
>
One common cause for not having the SQL Server Management Studio is
that you installed SQL Server Express Edition. It doesn't have SQL
Server Management Studio.
Another possibility is that you didn't choose to install SQL Server
Management Studio during Setup.
If you don't already have it, find a copy of SQL Server 2005 Developer
Edition (or above). Click the Advanced button during setup and study
the options for installation on the Advanced screen carefully.
Then you should be in good shape.
Andrew Watt
MVP - InfoPath
|||Hello Andrew.
When i installed the VS2005 RC1 i choosed to install sql 2005 express. but
after i finished that installation i installed sql server 2005 september ctp
(standard edition) in an new instance.
i have removed the sql 2005 september ctp and installed it again but its
still not there.
when im installing sql server 2005 september ctp im choosing all the
checkbox when i come to the point where i get the question what programs i
want to install.
when i read your answere i wonder if i should remove both vs2005 rc1 and sql
server 2005 september ctp. then install vs 2005 rc1 withour sql 2005 express
and then install sql server 2005 september ctp again.
Best regards
J?rgen
"Andrew Watt [MVP - InfoPath]" wrote:

> On Fri, 7 Oct 2005 05:43:02 -0700, Diffen
> <Diffen@.discussions.microsoft.com> wrote:
> One common cause for not having the SQL Server Management Studio is
> that you installed SQL Server Express Edition. It doesn't have SQL
> Server Management Studio.
> Another possibility is that you didn't choose to install SQL Server
> Management Studio during Setup.
> If you don't already have it, find a copy of SQL Server 2005 Developer
> Edition (or above). Click the Advanced button during setup and study
> the options for installation on the Advanced screen carefully.
> Then you should be in good shape.
> Andrew Watt
> MVP - InfoPath
>
|||Jorgen,
As a first step make sure you click the Advanced button during SQL
Server 2005 setup.
On the advanced screen make sure you notice the visual difference
between the install this component and the install this component and
all its subcomponent options.
It's easy to miss out some desired subcomponents.
If that works, then fine.
But if not ...
The recommended install order is SQL Server 2005 then Visual Studo
2005. So if the simpler approach doesn't work that looks like the way
to go.
Check after installing SQL Server that SQL Server Management Studio
has installed. It should be in Start|All Programs|Microsoft SQL Server
2005 CTP.
Andrew Watt
MVP - InfoPath
On Fri, 7 Oct 2005 14:01:33 -0700, Diffen
<Diffen@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hello Andrew.
>When i installed the VS2005 RC1 i choosed to install sql 2005 express. but
>after i finished that installation i installed sql server 2005 september ctp
>(standard edition) in an new instance.
>i have removed the sql 2005 september ctp and installed it again but its
>still not there.
>when im installing sql server 2005 september ctp im choosing all the
>checkbox when i come to the point where i get the question what programs i
>want to install.
>when i read your answere i wonder if i should remove both vs2005 rc1 and sql
>server 2005 september ctp. then install vs 2005 rc1 withour sql 2005 express
>and then install sql server 2005 september ctp again.
>Best regards
>Jrgen
>"Andrew Watt [MVP - InfoPath]" wrote:
|||Andrew,
Thank you very much for you quick support.
The problem was solved when i choosed advanced options in the setup just as
you suggested.
I reinstalled sql 2005 and vs 2005 rc1 and all worked out really fine.
Thanks allot!
"Andrew Watt [MVP - InfoPath]" wrote:

> Jorgen,
> As a first step make sure you click the Advanced button during SQL
> Server 2005 setup.
> On the advanced screen make sure you notice the visual difference
> between the install this component and the install this component and
> all its subcomponent options.
> It's easy to miss out some desired subcomponents.
> If that works, then fine.
> But if not ...
> The recommended install order is SQL Server 2005 then Visual Studo
> 2005. So if the simpler approach doesn't work that looks like the way
> to go.
> Check after installing SQL Server that SQL Server Management Studio
> has installed. It should be in Start|All Programs|Microsoft SQL Server
> 2005 CTP.
> Andrew Watt
> MVP - InfoPath
> On Fri, 7 Oct 2005 14:01:33 -0700, Diffen
> <Diffen@.discussions.microsoft.com> wrote:
>
>
|||You're welcome.
Andrew Watt
MVP - InfoPath
On Sat, 8 Oct 2005 04:31:02 -0700, Diffen
<Diffen@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Andrew,
>Thank you very much for you quick support.
>The problem was solved when i choosed advanced options in the setup just as
>you suggested.
>I reinstalled sql 2005 and vs 2005 rc1 and all worked out really fine.
>Thanks allot!
>"Andrew Watt [MVP - InfoPath]" wrote:

Management Tools in SQL SERVER 2005

Hi Team,

Is there any management tools in SQL SERVER 2005? I just installed my standard edition and also developer version in different computer, but seems that both versions doesn't support management tools such as query analyzer.

Can anyone explain to me...

Thanks.

Copy both to your harddrive and rerun setup and choose the repair option and when you get to select components choose Management tools the new Enterprise Manager is called Management Studio and install it in both. Then right click at the top of Management Studio to register the Standard Edition with the Developer Edition because it is the Enterprise Edition with no deployment restriction. Hope this helps.

|||

Thanks Caddre,

I found it.

management tools for sql 2005?

what tools are available to manage sql server 2005 (std version) databases if
you don't have a copy of SQL Server 2005? i.e. connecting to a remote sql
server 2005 system for development.
Thanks!
"mp3nomad" <mp3nomad@.discussions.microsoft.com> wrote in message
news:8855D067-2042-4A4F-AD0B-8B918C52CB0E@.microsoft.com...
> what tools are available to manage sql server 2005 (std version) databases
> if
> you don't have a copy of SQL Server 2005? i.e. connecting to a remote sql
> server 2005 system for development.
> Thanks!
I don't know what third party tools have been announced yet but if you are
licensed to use SQL Server Standard Ed then you are licensed to install the
SQL Server Management Studio so I suggest you install it. Get it from
whoever manages the server or download it if you are an MSDN subscriber.
David Portas
SQL Server MVP
|||thanks David.
"David Portas" wrote:

> "mp3nomad" <mp3nomad@.discussions.microsoft.com> wrote in message
> news:8855D067-2042-4A4F-AD0B-8B918C52CB0E@.microsoft.com...
> I don't know what third party tools have been announced yet but if you are
> licensed to use SQL Server Standard Ed then you are licensed to install the
> SQL Server Management Studio so I suggest you install it. Get it from
> whoever manages the server or download it if you are an MSDN subscriber.
> --
> David Portas
> SQL Server MVP
> --
>
>

management tools for sql 2005?

what tools are available to manage sql server 2005 (std version) databases if
you don't have a copy of SQL Server 2005? i.e. connecting to a remote sql
server 2005 system for development.
Thanks!"mp3nomad" <mp3nomad@.discussions.microsoft.com> wrote in message
news:8855D067-2042-4A4F-AD0B-8B918C52CB0E@.microsoft.com...
> what tools are available to manage sql server 2005 (std version) databases
> if
> you don't have a copy of SQL Server 2005? i.e. connecting to a remote sql
> server 2005 system for development.
> Thanks!
I don't know what third party tools have been announced yet but if you are
licensed to use SQL Server Standard Ed then you are licensed to install the
SQL Server Management Studio so I suggest you install it. Get it from
whoever manages the server or download it if you are an MSDN subscriber.
--
David Portas
SQL Server MVP
--|||thanks David.
"David Portas" wrote:
> "mp3nomad" <mp3nomad@.discussions.microsoft.com> wrote in message
> news:8855D067-2042-4A4F-AD0B-8B918C52CB0E@.microsoft.com...
> > what tools are available to manage sql server 2005 (std version) databases
> > if
> > you don't have a copy of SQL Server 2005? i.e. connecting to a remote sql
> > server 2005 system for development.
> >
> > Thanks!
> I don't know what third party tools have been announced yet but if you are
> licensed to use SQL Server Standard Ed then you are licensed to install the
> SQL Server Management Studio so I suggest you install it. Get it from
> whoever manages the server or download it if you are an MSDN subscriber.
> --
> David Portas
> SQL Server MVP
> --
>
>

management tools for sql 2005?

what tools are available to manage sql server 2005 (std version) databases i
f
you don't have a copy of SQL Server 2005? i.e. connecting to a remote sql
server 2005 system for development.
Thanks!"mp3nomad" <mp3nomad@.discussions.microsoft.com> wrote in message
news:8855D067-2042-4A4F-AD0B-8B918C52CB0E@.microsoft.com...
> what tools are available to manage sql server 2005 (std version) databases
> if
> you don't have a copy of SQL Server 2005? i.e. connecting to a remote sql
> server 2005 system for development.
> Thanks!
I don't know what third party tools have been announced yet but if you are
licensed to use SQL Server Standard Ed then you are licensed to install the
SQL Server Management Studio so I suggest you install it. Get it from
whoever manages the server or download it if you are an MSDN subscriber.
David Portas
SQL Server MVP
--|||thanks David.
"David Portas" wrote:

> "mp3nomad" <mp3nomad@.discussions.microsoft.com> wrote in message
> news:8855D067-2042-4A4F-AD0B-8B918C52CB0E@.microsoft.com...
> I don't know what third party tools have been announced yet but if you are
> licensed to use SQL Server Standard Ed then you are licensed to install th
e
> SQL Server Management Studio so I suggest you install it. Get it from
> whoever manages the server or download it if you are an MSDN subscriber.
> --
> David Portas
> SQL Server MVP
> --
>
>

Management Stusio install via SMS

s there a way to only install sql management studio via SMS?

I found the article on the unattend install, but I do not want the connectivity tools, etc.

I only need the management studio portion installed, nothing elsre. Has anyone accomplished this?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478384&SiteID=1|||

I replied to that post, but it did not really help me out.

I do not know the msi

|||

IS SSMSE (SQL Server Management Studio Express) any help here?

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

|||

The full Management Studio application is able to manage all our SQL Server products - including SQL Server, Analysis Services, Integration Services, and SQL Server Agent. Because of its scope, SSMS has a lot of dependencies under the covers that end needing most of the components you aren't interested in running in order to start.

We tailored Management Studio Express to not have all those dependencies, so the install is fairly small and doesn't bring in anything other than what's needed to work with the SQL Server relational engine. Management Studio Express is missing functionality from the full SSMS that some users use frequently, like the ability to work with SQL Server Agent and SSIS, which prevents it from working with maintenance plans, importing and exporting data using a wizard, and using a wizard to copy databases. If you don't use that functionality, SSMSE might work well for you.

You can download SSMS Express here: http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en

Hope this helps,
Steve

Management Stusio install via SMS

s there a way to only install sql management studio via SMS?

I found the article on the unattend install, but I do not want the connectivity tools, etc.

I only need the management studio portion installed, nothing elsre. Has anyone accomplished this?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478384&SiteID=1|||

I replied to that post, but it did not really help me out.

I do not know the msi

|||

IS SSMSE (SQL Server Management Studio Express) any help here?

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

|||

The full Management Studio application is able to manage all our SQL Server products - including SQL Server, Analysis Services, Integration Services, and SQL Server Agent. Because of its scope, SSMS has a lot of dependencies under the covers that end needing most of the components you aren't interested in running in order to start.

We tailored Management Studio Express to not have all those dependencies, so the install is fairly small and doesn't bring in anything other than what's needed to work with the SQL Server relational engine. Management Studio Express is missing functionality from the full SSMS that some users use frequently, like the ability to work with SQL Server Agent and SSIS, which prevents it from working with maintenance plans, importing and exporting data using a wizard, and using a wizard to copy databases. If you don't use that functionality, SSMSE might work well for you.

You can download SSMS Express here: http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en

Hope this helps,
Steve

Management Studio, Save as... dialog before running External Tools

Hi.

In Management Studio I have defined some external tools. When I call my external tool from Tools menu and I have query scripts that are not saved I get "Save File As..." dialog for EVERY not saved script before running my External Tool. This is frustrating because sometimes I have a lot of not saved scripts and my External Tool doesn't need saved script files. How to run External tool in Mangement Studio without this frustrating "Save File As..." dialog box?

Kamil

I get the same thing. I can click cancel and the tool still opens, but it is annoying.