Getting SQL 2000 templates into SQL2005/Management Studio


    Sponsored Links


  • 1. how do you set up an admin account?
    In a recent installation of 2005, I have been burned by the fact that I didn't set up something along the lines of SQL 2000's sa account. But in my defense, 2005 didn't ask me to do so. Now it won't let me into the account that I did set up, and I am probably going to have to uninstall SQL and reinstall. So when I do reinstall, where can I set up such an account?
  • 2. SQL Server 2000 new install using x64
    We are trying to build a new server that has Xeon Dual DP Processors. We have installed Windows 2003 Server Enterprise 64-bit When we try to install SQL Server 2000 Enterprise we get an error that we are running running on a 64-bit OS. I know SP4 supports this OS, but how can we install SP4, if we can't install the base SQL server software first? -- Preston
  • 3. SQL 2000 Standard and SQL 2005 Developer - Co-exist
    I have SQL Server 2000 standard edition installed on Windows 2003 server. Now I want to install SQL 2005 Developer edition on the same machine. Will this be a problem? BTW, this is a test machine. I may have read somewhere that SQL 2005 Developer edition can not be installed on the same machine with SQL 2000 Developer edition. Is this true?
  • 4. =?Utf-8?Q?SQL_Server_Installation_=E2=80=93_Settin?= =?Utf-8?Q?g_CALs?=
    I have successfully installed SQL Server 2005 Standard Edition. I have purchased 25 Device CALs for the SQL Server. Where do I enter that (CAL) information in SQL Server or Windows? Sorry if the question seems silly, or the answer obvious, but I have been banging my head on this one for a day now. Thank you for your help, -Tim

Getting SQL 2000 templates into SQL2005/Management Studio

Postby Steen Persson (DK) » Thu, 02 Mar 2006 17:49:10 GMT


Does anybody know if there's an easy way to import old query templates 
to be used in SQL 2005 /Management Studio? I know how to make new 
folders and templates manually, but I can't see how I can get my old one 
in there without having to do it "by hand".


Similar Threads:

1.bewa SQL2005 management studio not 2000 compatible

using 2005 management studio i made changes to an 8 step job on SQL 2000
server. I inserted a new step into position 8  and then tried to save it.
SQL2005 management told me that some feature was not supported on SQL 2000
so i pressed cancel. at this point both SQL 2005 management studio and SQL
200) enterprise management both report a 4 step job.

It is going to take me hours to restore the 8 step job from a backup so that
it can be re-inserted into the live DB.

what a fiasco.


2.SQL2005-Management studio & Studio Express?

myPC had been installed the SQL Express and Mangement Studio Express.
I can use it very well.
However, When I install & setup SQL Server2005
I can't find the Management Studio ..[Only see the Studio Express]

Management Studio Express didn't got the "Import/ Export" function.

How can I install the Management Studio ??
Thanks in advance

3.Template Explorer - SQL Server Management Studio

Hi,  I have a question related to the new template explorer in SSMS.  In 
Query Analyzer, we were able to set a workgroup template folder location for 
storing common templates among all developers.  

In SSMS, I see no such setting.  Additionally, when creating new templates, 
they have to be on the hard drive in some drawn out awful path:

C:\Documents and Settings\xxxxx\Application Data\Microsoft\Microsoft SQL 

Is there no way to set the location of workgroup-level templates?  If so, 
this is a major step in the wrong direction for developer productivity.  
Currently, we have to copy our workgroup templates folder into the path 
stated above to have them show up.  This of course introduces the issue of 
keeping the local copy updated, etc. etc.

Any ideas on having a workgroup template folder?


4.Templates in Management Studio

5.SQL Server Management Studio gets disconnected

6. Management Studio along side Management Studio Express

7. sql2005 Management studio - cant see our web server(sql2k)

8. SQL2005 - Server Management Studio



Who is online

Users browsing this forum: No registered users and 58 guest