Renaming a diagram in SQL Server Management Studio

Hello, I have MS SQL 2005 installed on my server. When I tried to rename a
diagram, I received an error. Is it possible to rename a diagram, or I need
to create a new one and copy the contents? Does this problem exist only in my
installation, or does anyone else have the same problem? Thank you for
response. Here is the error message (renaming Diagram1 to Diagram2):
TITLE: Microsoft SQL Server Management Studio
Unable to rename Diagram2. (ObjectExplorer)
ADDITIONAL INFORMATION:
Could not find stored procedure 'dbo.sp_renamediagram'. (Microsoft SQL
Server, Error: 2812)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=2812&LinkId=20476[/url]
BUTTONS:
OK
On Mar 4, 4:31 pm, Paul J <P...@.discussions.microsoft.com> wrote:
> Hello, I have MS SQL 2005 installed on my server. When I tried to rename a
> diagram, I received an error. Is it possible to rename a diagram, or I need
> to create a new one and copy the contents? Does this problem exist only in my
> installation, or does anyone else have the same problem? Thank you for
> response. Here is the error message (renaming Diagram1 to Diagram2):
> TITLE: Microsoft SQL Server Management Studio
> --
> Unable to rename Diagram2. (ObjectExplorer)
> --
> ADDITIONAL INFORMATION:
> Could not find stored procedure 'dbo.sp_renamediagram'. (Microsoft SQL
> Server, Error: 2812)
> For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=...
> --
> BUTTONS:
> OK
> --
You should be able to rename a diagram.
When you created the first diagram in the database you should have
seen a message that database objects needed for diagrams would be
created and the following ojects should have been created:
sp_helpdiagramdefinition
sp_creatediagram
sp_renamediagram
sp_alterdiagram
sp_dropdiagram
fn_diagramobjects
sp_upgraddiagrams
sysdiagrams
PK__sysdiagrams__ID
UK_principal_name
sp_helpdiagrams
|||Paul J (PaulJ@.discussions.microsoft.com) writes:
> Hello, I have MS SQL 2005 installed on my server. When I tried to rename
> a diagram, I received an error. Is it possible to rename a diagram, or I
> need to create a new one and copy the contents? Does this problem exist
> only in my installation, or does anyone else have the same problem?
> Thank you for response. Here is the error message (renaming Diagram1 to
> Diagram2):
> TITLE: Microsoft SQL Server Management Studio
> --
> Unable to rename Diagram2. (ObjectExplorer)
>
To add to Steve's post, create some other database and add diagrams there.
Then do this from a query window:
sp_helptext sp_renamediagram
Copy and paste, and the run the script in the database you are having
problem with. This should work. (But I have not actually tested.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||"Erland Sommarskog" wrote:
> To add to Steve's post, create some other database and add diagrams there.
> Then do this from a query window:
> sp_helptext sp_renamediagram
> Copy and paste, and the run the script in the database you are having
> problem with. This should work. (But I have not actually tested.)
>
>
I already had the procedure there. But it doesn't work even after launching
the script... It works in new DB, so I will switch my objects data to the new
one. I still don't know what's wrong, but I believe it won't happen again :-)
If you still think you can help me with this issue, feel free to ask me for
all information you need. Resolving of this problem would save me much time.
Thank you
|||Paul J (PaulJ@.discussions.microsoft.com) writes:
> I already had the procedure there. But it doesn't work even after
> launching the script... It works in new DB, so I will switch my objects
> data to the new one. I still don't know what's wrong, but I believe it
> won't happen again :-) If you still think you can help me with this
> issue, feel free to ask me for all information you need. Resolving of
> this problem would save me much time.
What does
SELECT schema_id, schema_name(schema_id)
FROM sys.objects WHERE name = 'sp_renamediagram'
return?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||1 dbo
"Erland Sommarskog" wrote:

> Paul J (PaulJ@.discussions.microsoft.com) writes:
> What does
> SELECT schema_id, schema_name(schema_id)
> FROM sys.objects WHERE name = 'sp_renamediagram'
> return?
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>

Rename of stored proc in EM/Manage Studio does not work as expecte

I normally rename stored procedures through script, so I never noticed this
before, but if you use EM (2000) or Server Management Studio (2005) to renam
e
a stored procedure the name changes in the GUI, but the actually name used t
o
execute it does not. So, if I start with a stored procedure named 'a' it
executes using EXEC a. Now, I rename it through the GUI to b and EXEC a
still works and EXEC b fails. If you open the stored procedure for editing
you can see that in the code the stored procedure name has not been changed.
Whereas if you rename a view of function the name within the code is actuall
y
changed.
Can anyone explain this behavior?> So, if I start with a stored procedure named 'a' it
> executes using EXEC a. Now, I rename it through the GUI to b and EXEC a
> still works and EXEC b fails.
This is not what I am seeing. I created a proc named aa in tempdb. I renamed
it to a using EM. EM
submitted the following SQL:
EXEC sp_rename N'[dbo].[aa]', N'a', N'object'
I can now execute a. If I try to execute aa, I get "could not find stored pr
ocedure".
My guess is that you have procs with same name but different owners. Check s
ysobjects.
Also, be aware that sp_rename does not change the source code for the proced
ure (see syscomments),
the original name will be in the source code.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Byron" <Byron@.discussions.microsoft.com> wrote in message
news:3102CE8C-BA55-49C2-AB12-65BF91CDF87E@.microsoft.com...
>I normally rename stored procedures through script, so I never noticed this
> before, but if you use EM (2000) or Server Management Studio (2005) to ren
ame
> a stored procedure the name changes in the GUI, but the actually name used
to
> execute it does not. So, if I start with a stored procedure named 'a' it
> executes using EXEC a. Now, I rename it through the GUI to b and EXEC a
> still works and EXEC b fails. If you open the stored procedure for editin
g
> you can see that in the code the stored procedure name has not been change
d.
> Whereas if you rename a view of function the name within the code is actua
lly
> changed.
> Can anyone explain this behavior?sql

Rename of stored proc in EM/Manage Studio does not work as expecte

I normally rename stored procedures through script, so I never noticed this
before, but if you use EM (2000) or Server Management Studio (2005) to rename
a stored procedure the name changes in the GUI, but the actually name used to
execute it does not. So, if I start with a stored procedure named 'a' it
executes using EXEC a. Now, I rename it through the GUI to b and EXEC a
still works and EXEC b fails. If you open the stored procedure for editing
you can see that in the code the stored procedure name has not been changed.
Whereas if you rename a view of function the name within the code is actually
changed.
Can anyone explain this behavior?> So, if I start with a stored procedure named 'a' it
> executes using EXEC a. Now, I rename it through the GUI to b and EXEC a
> still works and EXEC b fails.
This is not what I am seeing. I created a proc named aa in tempdb. I renamed it to a using EM. EM
submitted the following SQL:
EXEC sp_rename N'[dbo].[aa]', N'a', N'object'
I can now execute a. If I try to execute aa, I get "could not find stored procedure".
My guess is that you have procs with same name but different owners. Check sysobjects.
Also, be aware that sp_rename does not change the source code for the procedure (see syscomments),
the original name will be in the source code.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Byron" <Byron@.discussions.microsoft.com> wrote in message
news:3102CE8C-BA55-49C2-AB12-65BF91CDF87E@.microsoft.com...
>I normally rename stored procedures through script, so I never noticed this
> before, but if you use EM (2000) or Server Management Studio (2005) to rename
> a stored procedure the name changes in the GUI, but the actually name used to
> execute it does not. So, if I start with a stored procedure named 'a' it
> executes using EXEC a. Now, I rename it through the GUI to b and EXEC a
> still works and EXEC b fails. If you open the stored procedure for editing
> you can see that in the code the stored procedure name has not been changed.
> Whereas if you rename a view of function the name within the code is actually
> changed.
> Can anyone explain this behavior?

rename a table

Is it possible to rename a table with T-SQL?

I can do it by rightclicking in the SQL management studio and selecting the rename menu option...

so what is the corresponding T-sql command?

thanks in advance, have a nice day

Carl

use sp_rename

Syntex,

sp_rename 'oldname' , 'newname'

|||

Thanks ManiD this is THE answer to my question... and clicking the modify button on this system stored procedure has learned me a lot new T-SQL procedures and way of working.

Thanks again and have a nice day

Carl

sql

removing SQL Server 2005 (multiple Visual Studio versions)

I know that my entry which follows is rather long and complicated, but I am
hoping someone can offer helpful recommendations to my two questions at the
bottom. I have tried to research this and figure it out on my own, but I am
far from a computer SME, especially when it comes to behind-the-scenes stuff,
and am afraid to attempt doing this on my own, out of fear of screwing my
situation up beyond repair. I have followed one recommendation from someone
in a Microsoft forum, but have not received a response in quite some time to
a question I posed regarding the current status. I felt I should pass along
all the information I can, thus the length and complexity of this message.
So here’s my situation…
I have several versions of Visual Studio on my machine, and am looking to
uninstall EVERYTHING correctly to ensure a good installation of newly
purchased Visual Studio 2005 Professional Edition thereafter. I have found
several entries on the MS site (such as
http://msdn2.microsoft.com/en-us/vstudio/aa718687.aspx and
http://msdn2.microsoft.com/en-us/vstudio/aa718704.aspx) which recommend how
to remove previous installations, however, there are some differences in
their recommended order of removal of individual components. On my PC are:
Visual Studio .NET
Microsoft Development Environment 2002 (Version 7.0.9466)
Microsoft NET Framework 1.0 (Version 1.0.3705)
Installed Products:
Microsoft Visual C#.NET
Visual Studio .NET 2003
Microsoft Development Environment 2003 (Version 7.1.3088)
Microsoft NET Framework 1.1 (Version 1.1.4322 SP1)
Installed Products:
Microsoft Visual Basic.NET
Microsoft Visual C#.NET
Microsoft Visual C++.NET
Microsoft Visual J#.NET
etc.
Visual Studio 2005 – Team Suite edition trial download for which the
evaluation period ended, so I am unable to obtain environment information via
opening the program.
Here is the list of programs/components on my PC displayed by the ADD/REMOVE
PROGRAMS utility. I have indicated before each component the version of
Visual Studio to which I believe it belongs. Please note that I do have SQL
Server 2000, and if possible, would prefer to NOT have to uninstall it, as I
have several working databases on it:
(2002) "Microsoft .NET Compact Framework 1.0 SP3 Developer"
(2005) "Microsoft .NET Compact Framework 2.0"
(2002) “Microsoft .NET Framework 1.0 Hotfix (KB930494)”
(2002) “Microsoft .NET Framework 1.0 Hotfix (KB887998)”
(2003) “Microsoft .NET Framework 1.1”
(2003) “Microsoft .NET Framework 1.1 Hotfix (KB928366)”
(2005) "Microsoft .NET Framework 2.0"
(2005) “Security Update for Microsoft .NET Framework 2.0 (KB928365)”
(?) "Microsoft Device Emulator version 1.0 – ENU"”
(2005) "Microsoft Document Explorer 2005"
"Microsoft SQL Server 2000"
(2005) “Microsoft SQL Server 2005 Mobile [ENU] Developer Tools”
(2005) "Microsoft SQL Server Native Client"
(2002) “Microsoft Visual C#.NET Standard - English"
(2003) "Microsoft Visual J# .NET Redistributable Package 1.1"
(2005) "Microsoft Visual J# Redistributable Package 2.0"
(2003) “Microsoft Visual Studio .NET Enterprise Architect 2003 – English”
(2005) "Microsoft Visual Studio 2005 Team Suite - ENU”
(2005) “Microsoft Visual Studio 2005 Team Suite – ENU Service Pack 1
(KB926601) (2005) “Security update for Microsoft Visual Studio
2005 Team Suite – ENU
(KB937061)
(2005) "Microsoft Visual Studio 2005 Tools for Office System 2005 Runtime"
(2005) "MSDN Library for Visual Studio 2005 BETA”
(2003) "Microsoft MSXML 4.0 SP2 (KB936181)
(2003) "Microsoft MSXML 4.0 SP2 (KB927978)
(2003) "Microsoft MSXML 4.0 SP2 (KB925672)
Following the Microsoft forum's recommendation, I used ADD/REMOVE programs to
remove SQL Server 2005, which resulted in the following components being
removed from the ADD/REMOVE programs list:
(2005) "Microsoft SQL Server 2005”
(2005) "Microsoft MSXML 6.0 SDK and Parser"
(2005) Microsoft SQL Server VSS Writer (version 9.00.3042.00)
(2005) Microsoft SQL Server Setup Support Files (English) (version 9.00.
3042.00)
Now my questions...
1) I've tried to figure out why “Microsoft SQL Server 2005 Mobile [ENU]
Developer Tools” is still on my machine, and I'm not sure how best to remove
it. Oddly, although it's listed in ADD/REMOVE programs, the Windows folder
contains only another folder labeled "Samples", which in turn contains only a
third folder holding a .zip file named NorthWindOleDb.zip.
There was no error message output to the screen by the removal of Sql Server
2005, but the MSDN article in the knowledge base states that "if these steps
did not uninstall all the components", to follow a series of subsequent steps
"Make sure that the Microsoft SQL Server Setup Support Files component is
installed...double-click the Servers\setup\sqlsupport.msi file on the
original SQL Server 2005 installation media." The problem is that I have a
trial download, and the disc I created to hold it causes my machine to freeze
up when I insert it in the drive. There was no error message output to the
screen by the removal of Sql Server 2005, so, should I just use Add/Remove
programs to remove it from my machine (without the presence of Setup Support
Files), or would deleting the folder via Windows Explorer be OK?
2) Can I retain SQL Server 2000 and have a successful installation of VS 2005
Pro Edition, which is supposed to have SQL Server 2005 included? (per
MSDN it's apparently OK for "Microsoft SQL Server Native Client" to currently
be on my machine...: "Do not uninstall the Microsoft SQL Server Native Client
component if you have SQL Server 2000 components installed.")
Thanks in advance for your time and help!
Hi
If you want to have different development environments on a machine you may
want to consider virtual machines.
Your post does not say if you have tried to remove “Microsoft SQL Server
2005 Mobile [ENU] Developer Tools” using the add/remove programs but that
should be ok as it is listed as a separate installation.
I believe the SQL 2000 components are in reference to the backward
compatibility components for SQL 2005. The native driver should not be
necessary for SQL 2000 although having it installed should not cause any
issues.
For your SQL 2000 databases make sure that you have good backups of all the
databases (including system dbs), then if you do need to remove it and
re-install you don't have to worry about logins, jobs etc.
John
"gandecoe" wrote:

> I know that my entry which follows is rather long and complicated, but I am
> hoping someone can offer helpful recommendations to my two questions at the
> bottom. I have tried to research this and figure it out on my own, but I am
> far from a computer SME, especially when it comes to behind-the-scenes stuff,
> and am afraid to attempt doing this on my own, out of fear of screwing my
> situation up beyond repair. I have followed one recommendation from someone
> in a Microsoft forum, but have not received a response in quite some time to
> a question I posed regarding the current status. I felt I should pass along
> all the information I can, thus the length and complexity of this message.
> So here’s my situation…
> I have several versions of Visual Studio on my machine, and am looking to
> uninstall EVERYTHING correctly to ensure a good installation of newly
> purchased Visual Studio 2005 Professional Edition thereafter. I have found
> several entries on the MS site (such as
> http://msdn2.microsoft.com/en-us/vstudio/aa718687.aspx and
> http://msdn2.microsoft.com/en-us/vstudio/aa718704.aspx) which recommend how
> to remove previous installations, however, there are some differences in
> their recommended order of removal of individual components. On my PC are:
> Visual Studio .NET
> Microsoft Development Environment 2002 (Version 7.0.9466)
> Microsoft NET Framework 1.0 (Version 1.0.3705)
> Installed Products:
> Microsoft Visual C#.NET
> Visual Studio .NET 2003
> Microsoft Development Environment 2003 (Version 7.1.3088)
> Microsoft NET Framework 1.1 (Version 1.1.4322 SP1)
> Installed Products:
> Microsoft Visual Basic.NET
> Microsoft Visual C#.NET
> Microsoft Visual C++.NET
> Microsoft Visual J#.NET
> etc.
> Visual Studio 2005 – Team Suite edition trial download for which the
> evaluation period ended, so I am unable to obtain environment information via
> opening the program.
> Here is the list of programs/components on my PC displayed by the ADD/REMOVE
> PROGRAMS utility. I have indicated before each component the version of
> Visual Studio to which I believe it belongs. Please note that I do have SQL
> Server 2000, and if possible, would prefer to NOT have to uninstall it, as I
> have several working databases on it:
> (2002) "Microsoft .NET Compact Framework 1.0 SP3 Developer"
> (2005) "Microsoft .NET Compact Framework 2.0"
> (2002) “Microsoft .NET Framework 1.0 Hotfix (KB930494)”
> (2002) “Microsoft .NET Framework 1.0 Hotfix (KB887998)”
> (2003) “Microsoft .NET Framework 1.1”
> (2003) “Microsoft .NET Framework 1.1 Hotfix (KB928366)”
> (2005) "Microsoft .NET Framework 2.0"
> (2005) “Security Update for Microsoft .NET Framework 2.0 (KB928365)”
> (?) "Microsoft Device Emulator version 1.0 – ENU"”
> (2005) "Microsoft Document Explorer 2005"
> "Microsoft SQL Server 2000"
> (2005) “Microsoft SQL Server 2005 Mobile [ENU] Developer Tools”
> (2005) "Microsoft SQL Server Native Client"
> (2002) “Microsoft Visual C#.NET Standard - English"
> (2003) "Microsoft Visual J# .NET Redistributable Package 1.1"
> (2005) "Microsoft Visual J# Redistributable Package 2.0"
> (2003) “Microsoft Visual Studio .NET Enterprise Architect 2003 – English”
> (2005) "Microsoft Visual Studio 2005 Team Suite - ENU”
> (2005) “Microsoft Visual Studio 2005 Team Suite – ENU Service Pack 1
> (KB926601) (2005) “Security update for Microsoft Visual Studio
> 2005 Team Suite – ENU
> (KB937061)
> (2005) "Microsoft Visual Studio 2005 Tools for Office System 2005 Runtime"
> (2005) "MSDN Library for Visual Studio 2005 BETA”
> (2003) "Microsoft MSXML 4.0 SP2 (KB936181)
> (2003) "Microsoft MSXML 4.0 SP2 (KB927978)
> (2003) "Microsoft MSXML 4.0 SP2 (KB925672)
> Following the Microsoft forum's recommendation, I used ADD/REMOVE programs to
> remove SQL Server 2005, which resulted in the following components being
> removed from the ADD/REMOVE programs list:
> (2005) "Microsoft SQL Server 2005”
> (2005) "Microsoft MSXML 6.0 SDK and Parser"
> (2005) Microsoft SQL Server VSS Writer (version 9.00.3042.00)
> (2005) Microsoft SQL Server Setup Support Files (English) (version 9.00.
> 3042.00)
> Now my questions...
> 1) I've tried to figure out why “Microsoft SQL Server 2005 Mobile [ENU]
> Developer Tools” is still on my machine, and I'm not sure how best to remove
> it. Oddly, although it's listed in ADD/REMOVE programs, the Windows folder
> contains only another folder labeled "Samples", which in turn contains only a
> third folder holding a .zip file named NorthWindOleDb.zip.
> There was no error message output to the screen by the removal of Sql Server
> 2005, but the MSDN article in the knowledge base states that "if these steps
> did not uninstall all the components", to follow a series of subsequent steps
> "Make sure that the Microsoft SQL Server Setup Support Files component is
> installed...double-click the Servers\setup\sqlsupport.msi file on the
> original SQL Server 2005 installation media." The problem is that I have a
> trial download, and the disc I created to hold it causes my machine to freeze
> up when I insert it in the drive. There was no error message output to the
> screen by the removal of Sql Server 2005, so, should I just use Add/Remove
> programs to remove it from my machine (without the presence of Setup Support
> Files), or would deleting the folder via Windows Explorer be OK?
> 2) Can I retain SQL Server 2000 and have a successful installation of VS 2005
> Pro Edition, which is supposed to have SQL Server 2005 included? (per
> MSDN it's apparently OK for "Microsoft SQL Server Native Client" to currently
> be on my machine...: "Do not uninstall the Microsoft SQL Server Native Client
> component if you have SQL Server 2000 components installed.")
> Thanks in advance for your time and help!
>

removing SQL Server 2005 (multiple Visual Studio versions)

I know that my entry which follows is rather long and complicated, but I am
hoping someone can offer helpful recommendations to my two questions at the
bottom. I have tried to research this and figure it out on my own, but I am
far from a computer SME, especially when it comes to behind-the-scenes stuff,
and am afraid to attempt doing this on my own, out of fear of screwing my
situation up beyond repair. I have followed one recommendation from someone
in a Microsoft forum, but have not received a response in quite some time to
a question I posed regarding the current status. I felt I should pass along
all the information I can, thus the length and complexity of this message.
So hereâ's my situationâ?¦
I have several versions of Visual Studio on my machine, and am looking to
uninstall EVERYTHING correctly to ensure a good installation of newly
purchased Visual Studio 2005 Professional Edition thereafter. I have found
several entries on the MS site (such as
http://msdn2.microsoft.com/en-us/vstudio/aa718687.aspx and
http://msdn2.microsoft.com/en-us/vstudio/aa718704.aspx) which recommend how
to remove previous installations, however, there are some differences in
their recommended order of removal of individual components. On my PC are:
Visual Studio .NET
Microsoft Development Environment 2002 (Version 7.0.9466)
Microsoft NET Framework 1.0 (Version 1.0.3705)
Installed Products:
Microsoft Visual C#.NET
Visual Studio .NET 2003
Microsoft Development Environment 2003 (Version 7.1.3088)
Microsoft NET Framework 1.1 (Version 1.1.4322 SP1)
Installed Products:
Microsoft Visual Basic.NET
Microsoft Visual C#.NET
Microsoft Visual C++.NET
Microsoft Visual J#.NET
etc.
Visual Studio 2005 â' Team Suite edition trial download for which the
evaluation period ended, so I am unable to obtain environment information via
opening the program.
Here is the list of programs/components on my PC displayed by the ADD/REMOVE
PROGRAMS utility. I have indicated before each component the version of
Visual Studio to which I believe it belongs. Please note that I do have SQL
Server 2000, and if possible, would prefer to NOT have to uninstall it, as I
have several working databases on it:
(2002) "Microsoft .NET Compact Framework 1.0 SP3 Developer"
(2005) "Microsoft .NET Compact Framework 2.0"
(2002) â'Microsoft .NET Framework 1.0 Hotfix (KB930494)â'
(2002) â'Microsoft .NET Framework 1.0 Hotfix (KB887998)â'
(2003) â'Microsoft .NET Framework 1.1â'
(2003) â'Microsoft .NET Framework 1.1 Hotfix (KB928366)â'
(2005) "Microsoft .NET Framework 2.0"
(2005) â'Security Update for Microsoft .NET Framework 2.0 (KB928365)â'
(') "Microsoft Device Emulator version 1.0 â' ENU"â'
(2005) "Microsoft Document Explorer 2005"
"Microsoft SQL Server 2000"
(2005) â'Microsoft SQL Server 2005 Mobile [ENU] Developer Toolsâ'
(2005) "Microsoft SQL Server Native Client"
(2002) â'Microsoft Visual C#.NET Standard - English"
(2003) "Microsoft Visual J# .NET Redistributable Package 1.1"
(2005) "Microsoft Visual J# Redistributable Package 2.0"
(2003) â'Microsoft Visual Studio .NET Enterprise Architect 2003 â' Englishâ'
(2005) "Microsoft Visual Studio 2005 Team Suite - ENUâ'
(2005) â'Microsoft Visual Studio 2005 Team Suite â' ENU Service Pack 1
(KB926601) (2005) â'Security update for Microsoft Visual Studio
2005 Team Suite â' ENU
(KB937061)
(2005) "Microsoft Visual Studio 2005 Tools for Office System 2005 Runtime"
(2005) "MSDN Library for Visual Studio 2005 BETAâ'
(2003) "Microsoft MSXML 4.0 SP2 (KB936181)
(2003) "Microsoft MSXML 4.0 SP2 (KB927978)
(2003) "Microsoft MSXML 4.0 SP2 (KB925672)
Following the Microsoft forum's recommendation, I used ADD/REMOVE programs to
remove SQL Server 2005, which resulted in the following components being
removed from the ADD/REMOVE programs list:
(2005) "Microsoft SQL Server 2005â'
(2005) "Microsoft MSXML 6.0 SDK and Parser"
(2005) Microsoft SQL Server VSS Writer (version 9.00.3042.00)
(2005) Microsoft SQL Server Setup Support Files (English) (version 9.00.
3042.00)
Now my questions...
1) I've tried to figure out why â'Microsoft SQL Server 2005 Mobile [ENU]
Developer Toolsâ' is still on my machine, and I'm not sure how best to remove
it. Oddly, although it's listed in ADD/REMOVE programs, the Windows folder
contains only another folder labeled "Samples", which in turn contains only a
third folder holding a .zip file named NorthWindOleDb.zip.
There was no error message output to the screen by the removal of Sql Server
2005, but the MSDN article in the knowledge base states that "if these steps
did not uninstall all the components", to follow a series of subsequent steps
"Make sure that the Microsoft SQL Server Setup Support Files component is
installed...double-click the Servers\setup\sqlsupport.msi file on the
original SQL Server 2005 installation media." The problem is that I have a
trial download, and the disc I created to hold it causes my machine to freeze
up when I insert it in the drive. There was no error message output to the
screen by the removal of Sql Server 2005, so, should I just use Add/Remove
programs to remove it from my machine (without the presence of Setup Support
Files), or would deleting the folder via Windows Explorer be OK?
2) Can I retain SQL Server 2000 and have a successful installation of VS 2005
Pro Edition, which is supposed to have SQL Server 2005 included? (per
MSDN it's apparently OK for "Microsoft SQL Server Native Client" to currently
be on my machine...: "Do not uninstall the Microsoft SQL Server Native Client
component if you have SQL Server 2000 components installed.")
Thanks in advance for your time and help!Hi
If you want to have different development environments on a machine you may
want to consider virtual machines.
Your post does not say if you have tried to remove â'Microsoft SQL Server
2005 Mobile [ENU] Developer Toolsâ' using the add/remove programs but that
should be ok as it is listed as a separate installation.
I believe the SQL 2000 components are in reference to the backward
compatibility components for SQL 2005. The native driver should not be
necessary for SQL 2000 although having it installed should not cause any
issues.
For your SQL 2000 databases make sure that you have good backups of all the
databases (including system dbs), then if you do need to remove it and
re-install you don't have to worry about logins, jobs etc.
John
"gandecoe" wrote:
> I know that my entry which follows is rather long and complicated, but I am
> hoping someone can offer helpful recommendations to my two questions at the
> bottom. I have tried to research this and figure it out on my own, but I am
> far from a computer SME, especially when it comes to behind-the-scenes stuff,
> and am afraid to attempt doing this on my own, out of fear of screwing my
> situation up beyond repair. I have followed one recommendation from someone
> in a Microsoft forum, but have not received a response in quite some time to
> a question I posed regarding the current status. I felt I should pass along
> all the information I can, thus the length and complexity of this message.
> So hereâ's my situationâ?¦
> I have several versions of Visual Studio on my machine, and am looking to
> uninstall EVERYTHING correctly to ensure a good installation of newly
> purchased Visual Studio 2005 Professional Edition thereafter. I have found
> several entries on the MS site (such as
> http://msdn2.microsoft.com/en-us/vstudio/aa718687.aspx and
> http://msdn2.microsoft.com/en-us/vstudio/aa718704.aspx) which recommend how
> to remove previous installations, however, there are some differences in
> their recommended order of removal of individual components. On my PC are:
> Visual Studio .NET
> Microsoft Development Environment 2002 (Version 7.0.9466)
> Microsoft NET Framework 1.0 (Version 1.0.3705)
> Installed Products:
> Microsoft Visual C#.NET
> Visual Studio .NET 2003
> Microsoft Development Environment 2003 (Version 7.1.3088)
> Microsoft NET Framework 1.1 (Version 1.1.4322 SP1)
> Installed Products:
> Microsoft Visual Basic.NET
> Microsoft Visual C#.NET
> Microsoft Visual C++.NET
> Microsoft Visual J#.NET
> etc.
> Visual Studio 2005 â' Team Suite edition trial download for which the
> evaluation period ended, so I am unable to obtain environment information via
> opening the program.
> Here is the list of programs/components on my PC displayed by the ADD/REMOVE
> PROGRAMS utility. I have indicated before each component the version of
> Visual Studio to which I believe it belongs. Please note that I do have SQL
> Server 2000, and if possible, would prefer to NOT have to uninstall it, as I
> have several working databases on it:
> (2002) "Microsoft .NET Compact Framework 1.0 SP3 Developer"
> (2005) "Microsoft .NET Compact Framework 2.0"
> (2002) â'Microsoft .NET Framework 1.0 Hotfix (KB930494)â'
> (2002) â'Microsoft .NET Framework 1.0 Hotfix (KB887998)â'
> (2003) â'Microsoft .NET Framework 1.1â'
> (2003) â'Microsoft .NET Framework 1.1 Hotfix (KB928366)â'
> (2005) "Microsoft .NET Framework 2.0"
> (2005) â'Security Update for Microsoft .NET Framework 2.0 (KB928365)â'
> (') "Microsoft Device Emulator version 1.0 â' ENU"â'
> (2005) "Microsoft Document Explorer 2005"
> "Microsoft SQL Server 2000"
> (2005) â'Microsoft SQL Server 2005 Mobile [ENU] Developer Toolsâ'
> (2005) "Microsoft SQL Server Native Client"
> (2002) â'Microsoft Visual C#.NET Standard - English"
> (2003) "Microsoft Visual J# .NET Redistributable Package 1.1"
> (2005) "Microsoft Visual J# Redistributable Package 2.0"
> (2003) â'Microsoft Visual Studio .NET Enterprise Architect 2003 â' Englishâ'
> (2005) "Microsoft Visual Studio 2005 Team Suite - ENUâ'
> (2005) â'Microsoft Visual Studio 2005 Team Suite â' ENU Service Pack 1
> (KB926601) (2005) â'Security update for Microsoft Visual Studio
> 2005 Team Suite â' ENU
> (KB937061)
> (2005) "Microsoft Visual Studio 2005 Tools for Office System 2005 Runtime"
> (2005) "MSDN Library for Visual Studio 2005 BETAâ'
> (2003) "Microsoft MSXML 4.0 SP2 (KB936181)
> (2003) "Microsoft MSXML 4.0 SP2 (KB927978)
> (2003) "Microsoft MSXML 4.0 SP2 (KB925672)
> Following the Microsoft forum's recommendation, I used ADD/REMOVE programs to
> remove SQL Server 2005, which resulted in the following components being
> removed from the ADD/REMOVE programs list:
> (2005) "Microsoft SQL Server 2005â'
> (2005) "Microsoft MSXML 6.0 SDK and Parser"
> (2005) Microsoft SQL Server VSS Writer (version 9.00.3042.00)
> (2005) Microsoft SQL Server Setup Support Files (English) (version 9.00.
> 3042.00)
> Now my questions...
> 1) I've tried to figure out why â'Microsoft SQL Server 2005 Mobile [ENU]
> Developer Toolsâ' is still on my machine, and I'm not sure how best to remove
> it. Oddly, although it's listed in ADD/REMOVE programs, the Windows folder
> contains only another folder labeled "Samples", which in turn contains only a
> third folder holding a .zip file named NorthWindOleDb.zip.
> There was no error message output to the screen by the removal of Sql Server
> 2005, but the MSDN article in the knowledge base states that "if these steps
> did not uninstall all the components", to follow a series of subsequent steps
> "Make sure that the Microsoft SQL Server Setup Support Files component is
> installed...double-click the Servers\setup\sqlsupport.msi file on the
> original SQL Server 2005 installation media." The problem is that I have a
> trial download, and the disc I created to hold it causes my machine to freeze
> up when I insert it in the drive. There was no error message output to the
> screen by the removal of Sql Server 2005, so, should I just use Add/Remove
> programs to remove it from my machine (without the presence of Setup Support
> Files), or would deleting the folder via Windows Explorer be OK?
> 2) Can I retain SQL Server 2000 and have a successful installation of VS 2005
> Pro Edition, which is supposed to have SQL Server 2005 included? (per
> MSDN it's apparently OK for "Microsoft SQL Server Native Client" to currently
> be on my machine...: "Do not uninstall the Microsoft SQL Server Native Client
> component if you have SQL Server 2000 components installed.")
> Thanks in advance for your time and help!
>

removing SQL Server 2005 (multiple Visual Studio versions)

I know that my entry which follows is rather long and complicated, but I am
hoping someone can offer helpful recommendations to my two questions at the
bottom. I have tried to research this and figure it out on my own, but I am
far from a computer SME, especially when it comes to behind-the-scenes stuff
,
and am afraid to attempt doing this on my own, out of fear of screwing my
situation up beyond repair. I have followed one recommendation from someon
e
in a Microsoft forum, but have not received a response in quite some time to
a question I posed regarding the current status. I felt I should pass alon
g
all the information I can, thus the length and complexity of this message.
So here’s my situation…
I have several versions of Visual Studio on my machine, and am looking to
uninstall EVERYTHING correctly to ensure a good installation of newly
purchased Visual Studio 2005 Professional Edition thereafter. I have found
several entries on the MS site (such as
http://msdn2.microsoft.com/en-us/vstudio/aa718687.aspx and
http://msdn2.microsoft.com/en-us/vstudio/aa718704.aspx) which recommend how
to remove previous installations, however, there are some differences in
their recommended order of removal of individual components. On my PC are:
Visual Studio .NET
Microsoft Development Environment 2002 (Version 7.0.9466)
Microsoft NET Framework 1.0 (Version 1.0.3705)
Installed Products:
Microsoft Visual C#.NET
Visual Studio .NET 2003
Microsoft Development Environment 2003 (Version 7.1.3088)
Microsoft NET Framework 1.1 (Version 1.1.4322 SP1)
Installed Products:
Microsoft Visual Basic.NET
Microsoft Visual C#.NET
Microsoft Visual C++.NET
Microsoft Visual J#.NET
etc.
Visual Studio 2005 – Team Suite edition trial download for which the
evaluation period ended, so I am unable to obtain environment information vi
a
opening the program.
Here is the list of programs/components on my PC displayed by the ADD/REMOVE
PROGRAMS utility. I have indicated before each component the version of
Visual Studio to which I believe it belongs. Please note that I do have SQL
Server 2000, and if possible, would prefer to NOT have to uninstall it, as I
have several working databases on it:
(2002) "Microsoft .NET Compact Framework 1.0 SP3 Developer"
(2005) "Microsoft .NET Compact Framework 2.0"
(2002) “Microsoft .NET Framework 1.0 Hotfix (KB930494)”
(2002) “Microsoft .NET Framework 1.0 Hotfix (KB887998)”
(2003) “Microsoft .NET Framework 1.1”
(2003) “Microsoft .NET Framework 1.1 Hotfix (KB928366)”
(2005) "Microsoft .NET Framework 2.0"
(2005) “Security Update for Microsoft .NET Framework 2.0 (KB928365)”
(') "Microsoft Device Emulator version 1.0 – ENU"”
(2005) "Microsoft Document Explorer 2005"
"Microsoft SQL Server 2000"
(2005) “Microsoft SQL Server 2005 Mobile [ENU] Developer Tools”
(2005) "Microsoft SQL Server Native Client"
(2002) “Microsoft Visual C#.NET Standard - English"
(2003) "Microsoft Visual J# .NET Redistributable Package 1.1"
(2005) "Microsoft Visual J# Redistributable Package 2.0"
(2003) “Microsoft Visual Studio .NET Enterprise Architect 2003 – Engl
ish”
(2005) "Microsoft Visual Studio 2005 Team Suite - ENU”
(2005) “Microsoft Visual Studio 2005 Team Suite – ENU Service Pack 1
(KB926601) (2005) “Security update for Microsoft Visual Stud
io
2005 Team Suite – ENU
(KB937061)
(2005) "Microsoft Visual Studio 2005 Tools for Office System 2005 Runtime"
(2005) "MSDN Library for Visual Studio 2005 BETA”
(2003) "Microsoft MSXML 4.0 SP2 (KB936181)
(2003) "Microsoft MSXML 4.0 SP2 (KB927978)
(2003) "Microsoft MSXML 4.0 SP2 (KB925672)
Following the Microsoft forum's recommendation, I used ADD/REMOVE programs t
o
remove SQL Server 2005, which resulted in the following components being
removed from the ADD/REMOVE programs list:
(2005) "Microsoft SQL Server 2005”
(2005) "Microsoft MSXML 6.0 SDK and Parser"
(2005) Microsoft SQL Server VSS Writer (version 9.00.3042.00)
(2005) Microsoft SQL Server Setup Support Files (English) (version 9.0
0.
3042.00)
Now my questions...
1) I've tried to figure out why “Microsoft SQL Server 2005 Mobile [E
NU]
Developer Tools” is still on my machine, and I'm not sure how best to remo
ve
it. Oddly, although it's listed in ADD/REMOVE programs, the Windows folder
contains only another folder labeled "Samples", which in turn contains only
a
third folder holding a .zip file named NorthWindOleDb.zip.
There was no error message output to the screen by the removal of Sql Server
2005, but the MSDN article in the knowledge base states that "if these steps
did not uninstall all the components", to follow a series of subsequent step
s
"Make sure that the Microsoft SQL Server Setup Support Files component is
installed...double-click the Servers\setup\sqlsupport.msi file on the
original SQL Server 2005 installation media." The problem is that I have a
trial download, and the disc I created to hold it causes my machine to freez
e
up when I insert it in the drive. There was no error message output to the
screen by the removal of Sql Server 2005, so, should I just use Add/Remove
programs to remove it from my machine (without the presence of Setup Support
Files), or would deleting the folder via Windows Explorer be OK?
2) Can I retain SQL Server 2000 and have a successful installation of VS 200
5
Pro Edition, which is supposed to have SQL Server 2005 included? (per
MSDN it's apparently OK for "Microsoft SQL Server Native Client" to currentl
y
be on my machine...: "Do not uninstall the Microsoft SQL Server Native Clien
t
component if you have SQL Server 2000 components installed.")
Thanks in advance for your time and help!Hi
If you want to have different development environments on a machine you may
want to consider virtual machines.
Your post does not say if you have tried to remove “Microsoft SQL Server
2005 Mobile [ENU] Developer Tools” using the add/remove programs but t
hat
should be ok as it is listed as a separate installation.
I believe the SQL 2000 components are in reference to the backward
compatibility components for SQL 2005. The native driver should not be
necessary for SQL 2000 although having it installed should not cause any
issues.
For your SQL 2000 databases make sure that you have good backups of all the
databases (including system dbs), then if you do need to remove it and
re-install you don't have to worry about logins, jobs etc.
John
"gandecoe" wrote:

> I know that my entry which follows is rather long and complicated, but I a
m
> hoping someone can offer helpful recommendations to my two questions at th
e
> bottom. I have tried to research this and figure it out on my own, but I
am
> far from a computer SME, especially when it comes to behind-the-scenes stu
ff,
> and am afraid to attempt doing this on my own, out of fear of screwing my
> situation up beyond repair. I have followed one recommendation from some
one
> in a Microsoft forum, but have not received a response in quite some time
to
> a question I posed regarding the current status. I felt I should pass al
ong
> all the information I can, thus the length and complexity of this message.
> So here’s my situation…
> I have several versions of Visual Studio on my machine, and am looking to
> uninstall EVERYTHING correctly to ensure a good installation of newly
> purchased Visual Studio 2005 Professional Edition thereafter. I have foun
d
> several entries on the MS site (such as
> http://msdn2.microsoft.com/en-us/vstudio/aa718687.aspx and
> http://msdn2.microsoft.com/en-us/vstudio/aa718704.aspx) which recommend ho
w
> to remove previous installations, however, there are some differences in
> their recommended order of removal of individual components. On my PC are
:
> Visual Studio .NET
> Microsoft Development Environment 2002 (Version 7.0.9466
)
> Microsoft NET Framework 1.0 (Version 1.0.3705)
> Installed Products:
> Microsoft Visual C#.NET
> Visual Studio .NET 2003
> Microsoft Development Environment 2003 (Version 7.1.3088
)
> Microsoft NET Framework 1.1 (Version 1.1.4322 SP1)
> Installed Products:
> Microsoft Visual Basic.NET
> Microsoft Visual C#.NET
> Microsoft Visual C++.NET
> Microsoft Visual J#.NET
> etc.
> Visual Studio 2005 – Team Suite edition trial download for which the
> evaluation period ended, so I am unable to obtain environment information
via
> opening the program.
> Here is the list of programs/components on my PC displayed by the ADD/REMO
VE
> PROGRAMS utility. I have indicated before each component the version of
> Visual Studio to which I believe it belongs. Please note that I do have S
QL
> Server 2000, and if possible, would prefer to NOT have to uninstall it, as
I
> have several working databases on it:
> (2002) "Microsoft .NET Compact Framework 1.0 SP3 Developer"
> (2005) "Microsoft .NET Compact Framework 2.0"
> (2002) “Microsoft .NET Framework 1.0 Hotfix (KB930494)”
> (2002) “Microsoft .NET Framework 1.0 Hotfix (KB887998)”
> (2003) “Microsoft .NET Framework 1.1”
> (2003) “Microsoft .NET Framework 1.1 Hotfix (KB928366)”
> (2005) "Microsoft .NET Framework 2.0"
> (2005) “Security Update for Microsoft .NET Framework 2.0 (KB928365)
> (') "Microsoft Device Emulator version 1.0 – ENU"”
> (2005) "Microsoft Document Explorer 2005"
> "Microsoft SQL Server 2000"
> (2005) “Microsoft SQL Server 2005 Mobile [ENU] Developer Tools”
> (2005) "Microsoft SQL Server Native Client"
> (2002) “Microsoft Visual C#.NET Standard - English"
> (2003) "Microsoft Visual J# .NET Redistributable Package 1.1"
> (2005) "Microsoft Visual J# Redistributable Package 2.0"
> (2003) “Microsoft Visual Studio .NET Enterprise Architect 2003 – En
glish”
> (2005) "Microsoft Visual Studio 2005 Team Suite - ENU”
> (2005) “Microsoft Visual Studio 2005 Team Suite – ENU Service Pack 1
> (KB926601) (2005) “Security update for Microsoft Visual St
udio
> 2005 Team Suite – ENU
> (KB937061)
> (2005) "Microsoft Visual Studio 2005 Tools for Office System 2005 Runtim
e"
> (2005) "MSDN Library for Visual Studio 2005 BETA”
> (2003) "Microsoft MSXML 4.0 SP2 (KB936181)
> (2003) "Microsoft MSXML 4.0 SP2 (KB927978)
> (2003) "Microsoft MSXML 4.0 SP2 (KB925672)
> Following the Microsoft forum's recommendation, I used ADD/REMOVE programs
to
> remove SQL Server 2005, which resulted in the following components being
> removed from the ADD/REMOVE programs list:
> (2005) "Microsoft SQL Server 2005”
> (2005) "Microsoft MSXML 6.0 SDK and Parser"
> (2005) Microsoft SQL Server VSS Writer (version 9.00.3042.00)
> (2005) Microsoft SQL Server Setup Support Files (English) (version 9
.00.
> 3042.00)
> Now my questions...
> 1) I've tried to figure out why “Microsoft SQL Server 2005 Mobile [
;ENU]
> Developer Tools” is still on my machine, and I'm not sure how best to re
move
> it. Oddly, although it's listed in ADD/REMOVE programs, the Windows folde
r
> contains only another folder labeled "Samples", which in turn contains onl
y a
> third folder holding a .zip file named NorthWindOleDb.zip.
> There was no error message output to the screen by the removal of Sql Serv
er
> 2005, but the MSDN article in the knowledge base states that "if these ste
ps
> did not uninstall all the components", to follow a series of subsequent st
eps
> "Make sure that the Microsoft SQL Server Setup Support Files component is
> installed...double-click the Servers\setup\sqlsupport.msi file on the
> original SQL Server 2005 installation media." The problem is that I have
a
> trial download, and the disc I created to hold it causes my machine to fre
eze
> up when I insert it in the drive. There was no error message output to th
e
> screen by the removal of Sql Server 2005, so, should I just use Add/Remove
> programs to remove it from my machine (without the presence of Setup Suppo
rt
> Files), or would deleting the folder via Windows Explorer be OK?
> 2) Can I retain SQL Server 2000 and have a successful installation of VS 2
005
> Pro Edition, which is supposed to have SQL Server 2005 included? (per
> MSDN it's apparently OK for "Microsoft SQL Server Native Client" to curren
tly
> be on my machine...: "Do not uninstall the Microsoft SQL Server Native Cli
ent
> component if you have SQL Server 2000 components installed.")
> Thanks in advance for your time and help!
>

Removing Databases

Using SQL Server Management Studio, I see 4 entries, master, model, msdb and temdb, under Databases -> System Databases. Which of these can I safely remove, if any?

Thank you

Hi there,

I don't think you should remove any of them....Each of the system databases is there for a purpose and removing one or more will adversely affect your database server (possibly to the point of inoperability).

Below is a link to adescription of the purpose of each system database:
System Databases

Hope that helps a bit or sheds some light on the matter, but sorry if it doesn't
|||Why should one delete the system databases ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Nate,

Thank you for the reponse, it helped quite a bit. I am new to SQL Express and I wasn't sure what those Db's were for, so the link is very helpful.