Hi All,
I have just installed EM for SQL Server 2000 and so have no registered servers in the console list. We have about 50 servers which we support and so I would rather import my colleagues list rather than registering them all manually. Is there ay way to do this ?
Many thanks
AndyUSE THIS AT YOUR OWN RISK. Works for me !! I accept no responsibility for anything :)
Well, this is a solution I would not attribute to myself , coz i did never invent it myself.
Register all your servers in one Enterprise Manager.
Then go to these keys :
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\SuperSocketNetLib\LastConnect]
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X]
and export them.
Share the .reg files with your colleagues. Enjoy|||Enigma,
Thanks a lot... this worked a treat.
Cheers
Andysql
Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts
Friday, March 30, 2012
Wednesday, March 21, 2012
Migrate Reporting Services Databases
I am upgrading the server that houses the SQL Reporting Services
databases (RSwwebservice, IIS and Report Manager are on another box).
The new server will have the same name (fqdn) as the old one.
Any issue with simply backin up the SQL RS dbs and restoring them the
new new server?
Thanks!Make sure to backup & restore the encryption key!
See also:
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_4915.asp
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_98xh.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1106780668.274285.107650@.z14g2000cwz.googlegroups.com...
> I am upgrading the server that houses the SQL Reporting Services
> databases (RSwwebservice, IIS and Report Manager are on another box).
> The new server will have the same name (fqdn) as the old one.
> Any issue with simply backin up the SQL RS dbs and restoring them the
> new new server?
> Thanks!
>|||Thanks.
I am not moving the Reporting Services Front end (i.e IIS, Report
Manager, etc..) do I still need to backup/restore the encryption key?|||If you only move the backend database, but not the RS webservice it is not
required to backup and restore the encryption keys. Nonetheless, you should
always backup the keys right after installation of RS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1106840440.083283.232730@.c13g2000cwb.googlegroups.com...
> Thanks.
> I am not moving the Reporting Services Front end (i.e IIS, Report
> Manager, etc..) do I still need to backup/restore the encryption key?
>|||I am having a similar problem - we currently have sql server reporting server
and sql server standard on the same machine. I have loaded the sql reporting
services onto a new machine that also has sql server running. All I want to
do is move the database from the old machine to the new machine - when i do
the backup and restore i see the folders and all my reports but I can not run
any of the reports - i have tried to reactivate using rsactivate and rsconfig
without success. Can I just use DTS to copy the data from the old sql server
database to the new?
"Jim" wrote:
> I am upgrading the server that houses the SQL Reporting Services
> databases (RSwwebservice, IIS and Report Manager are on another box).
> The new server will have the same name (fqdn) as the old one.
> Any issue with simply backin up the SQL RS dbs and restoring them the
> new new server?
> Thanks!
>sql
databases (RSwwebservice, IIS and Report Manager are on another box).
The new server will have the same name (fqdn) as the old one.
Any issue with simply backin up the SQL RS dbs and restoring them the
new new server?
Thanks!Make sure to backup & restore the encryption key!
See also:
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_4915.asp
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_98xh.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1106780668.274285.107650@.z14g2000cwz.googlegroups.com...
> I am upgrading the server that houses the SQL Reporting Services
> databases (RSwwebservice, IIS and Report Manager are on another box).
> The new server will have the same name (fqdn) as the old one.
> Any issue with simply backin up the SQL RS dbs and restoring them the
> new new server?
> Thanks!
>|||Thanks.
I am not moving the Reporting Services Front end (i.e IIS, Report
Manager, etc..) do I still need to backup/restore the encryption key?|||If you only move the backend database, but not the RS webservice it is not
required to backup and restore the encryption keys. Nonetheless, you should
always backup the keys right after installation of RS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1106840440.083283.232730@.c13g2000cwb.googlegroups.com...
> Thanks.
> I am not moving the Reporting Services Front end (i.e IIS, Report
> Manager, etc..) do I still need to backup/restore the encryption key?
>|||I am having a similar problem - we currently have sql server reporting server
and sql server standard on the same machine. I have loaded the sql reporting
services onto a new machine that also has sql server running. All I want to
do is move the database from the old machine to the new machine - when i do
the backup and restore i see the folders and all my reports but I can not run
any of the reports - i have tried to reactivate using rsactivate and rsconfig
without success. Can I just use DTS to copy the data from the old sql server
database to the new?
"Jim" wrote:
> I am upgrading the server that houses the SQL Reporting Services
> databases (RSwwebservice, IIS and Report Manager are on another box).
> The new server will have the same name (fqdn) as the old one.
> Any issue with simply backin up the SQL RS dbs and restoring them the
> new new server?
> Thanks!
>sql
Monday, February 20, 2012
Microsoft SQL Server Management Studio SP2 upgrade
Hi
Having an issue after sp2 install on SQl 2005. The problem I am having is
when I try to open the Maintenance Plans applet in system manager. I get the
following error:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
--
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
--
BUTTONS:
OK
--
I do not see any of the previse jobs the only thing I get is this error.
Any help is appreciated.
Dell Poweredge 1950
Windows 2003 STD sp2
Intel Xeon 3.2
4.0 gb Ram
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCPDid you upgrade the client tools but not the server instance (database
services)?
--
Aaron Bertrand
SQL Server MVP
"jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> Hi
> Having an issue after sp2 install on SQl 2005. The problem I am having is
> when I try to open the Maintenance Plans applet in system manager. I get
> the
> following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'from_msx'.
> Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I do not see any of the previse jobs the only thing I get is this error.
> Any help is appreciated.
> Dell Poweredge 1950
> Windows 2003 STD sp2
> Intel Xeon 3.2
> 4.0 gb Ram
> --
> Joel Cavazos
> Network Administrator
> MCSE, MCSA, MCP|||Aaron
Going back thur the update summary log I did find that thier was a error in
the update process regarding the database services the error is:
----
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could
not be started. Verify that you have sufficient privileges to start system
services. The error code is (1067) The process terminated unexpectedly.
----
Sorry I totally missed this.
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCP
"Aaron Bertrand [SQL Server MVP]" wrote:
> Did you upgrade the client tools but not the server instance (database
> services)?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
> news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> > Hi
> >
> > Having an issue after sp2 install on SQl 2005. The problem I am having is
> > when I try to open the Maintenance Plans applet in system manager. I get
> > the
> > following error:
> >
> > TITLE: Microsoft SQL Server Management Studio
> > --
> >
> > Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> >
> > Invalid column name 'from_msx'.
> > Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
> >
> > --
> > BUTTONS:
> >
> > OK
> > --
> >
> > I do not see any of the previse jobs the only thing I get is this error.
> > Any help is appreciated.
> >
> > Dell Poweredge 1950
> > Windows 2003 STD sp2
> > Intel Xeon 3.2
> > 4.0 gb Ram
> > --
> > Joel Cavazos
> > Network Administrator
> > MCSE, MCSA, MCP
>
>
Having an issue after sp2 install on SQl 2005. The problem I am having is
when I try to open the Maintenance Plans applet in system manager. I get the
following error:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
--
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
--
BUTTONS:
OK
--
I do not see any of the previse jobs the only thing I get is this error.
Any help is appreciated.
Dell Poweredge 1950
Windows 2003 STD sp2
Intel Xeon 3.2
4.0 gb Ram
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCPDid you upgrade the client tools but not the server instance (database
services)?
--
Aaron Bertrand
SQL Server MVP
"jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> Hi
> Having an issue after sp2 install on SQl 2005. The problem I am having is
> when I try to open the Maintenance Plans applet in system manager. I get
> the
> following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'from_msx'.
> Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I do not see any of the previse jobs the only thing I get is this error.
> Any help is appreciated.
> Dell Poweredge 1950
> Windows 2003 STD sp2
> Intel Xeon 3.2
> 4.0 gb Ram
> --
> Joel Cavazos
> Network Administrator
> MCSE, MCSA, MCP|||Aaron
Going back thur the update summary log I did find that thier was a error in
the update process regarding the database services the error is:
----
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could
not be started. Verify that you have sufficient privileges to start system
services. The error code is (1067) The process terminated unexpectedly.
----
Sorry I totally missed this.
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCP
"Aaron Bertrand [SQL Server MVP]" wrote:
> Did you upgrade the client tools but not the server instance (database
> services)?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
> news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> > Hi
> >
> > Having an issue after sp2 install on SQl 2005. The problem I am having is
> > when I try to open the Maintenance Plans applet in system manager. I get
> > the
> > following error:
> >
> > TITLE: Microsoft SQL Server Management Studio
> > --
> >
> > Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> >
> > Invalid column name 'from_msx'.
> > Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
> >
> > --
> > BUTTONS:
> >
> > OK
> > --
> >
> > I do not see any of the previse jobs the only thing I get is this error.
> > Any help is appreciated.
> >
> > Dell Poweredge 1950
> > Windows 2003 STD sp2
> > Intel Xeon 3.2
> > 4.0 gb Ram
> > --
> > Joel Cavazos
> > Network Administrator
> > MCSE, MCSA, MCP
>
>
Microsoft SQL Server Management Studio SP2 upgrade
Hi
Having an issue after sp2 install on SQl 2005. The problem I am having is
when I try to open the Maintenance Plans applet in system manager. I get th
e
following error:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
BUTTONS:
OK
--
I do not see any of the previse jobs the only thing I get is this error.
Any help is appreciated.
Dell Poweredge 1950
Windows 2003 STD sp2
Intel Xeon 3.2
4.0 gb Ram
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCPDid you upgrade the client tools but not the server instance (database
services)?
Aaron Bertrand
SQL Server MVP
"jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> Hi
> Having an issue after sp2 install on SQl 2005. The problem I am having is
> when I try to open the Maintenance Plans applet in system manager. I get
> the
> following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'from_msx'.
> Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I do not see any of the previse jobs the only thing I get is this error.
> Any help is appreciated.
> Dell Poweredge 1950
> Windows 2003 STD sp2
> Intel Xeon 3.2
> 4.0 gb Ram
> --
> Joel Cavazos
> Network Administrator
> MCSE, MCSA, MCP|||Aaron
Going back thur the update summary log I did find that thier was a error in
the update process regarding the database services the error is:
----
--
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could
not be started. Verify that you have sufficient privileges to start system
services. The error code is (1067) The process terminated unexpectedly.
----
--
Sorry I totally missed this.
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCP
"Aaron Bertrand [SQL Server MVP]" wrote:
> Did you upgrade the client tools but not the server instance (database
> services)?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
> news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
>
>
Having an issue after sp2 install on SQl 2005. The problem I am having is
when I try to open the Maintenance Plans applet in system manager. I get th
e
following error:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
BUTTONS:
OK
--
I do not see any of the previse jobs the only thing I get is this error.
Any help is appreciated.
Dell Poweredge 1950
Windows 2003 STD sp2
Intel Xeon 3.2
4.0 gb Ram
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCPDid you upgrade the client tools but not the server instance (database
services)?
Aaron Bertrand
SQL Server MVP
"jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> Hi
> Having an issue after sp2 install on SQl 2005. The problem I am having is
> when I try to open the Maintenance Plans applet in system manager. I get
> the
> following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'from_msx'.
> Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I do not see any of the previse jobs the only thing I get is this error.
> Any help is appreciated.
> Dell Poweredge 1950
> Windows 2003 STD sp2
> Intel Xeon 3.2
> 4.0 gb Ram
> --
> Joel Cavazos
> Network Administrator
> MCSE, MCSA, MCP|||Aaron
Going back thur the update summary log I did find that thier was a error in
the update process regarding the database services the error is:
----
--
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could
not be started. Verify that you have sufficient privileges to start system
services. The error code is (1067) The process terminated unexpectedly.
----
--
Sorry I totally missed this.
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCP
"Aaron Bertrand [SQL Server MVP]" wrote:
> Did you upgrade the client tools but not the server instance (database
> services)?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
> news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
>
>
Microsoft SQL Server Management Studio
I have recently moved from a Microsoft SQL Server 2000 to a SQL Server
2005.
In the good old Enterprise Manager, when I imported a table from a SQL
server to another, I could choose "Copy objects and data between SQL
Server
databases". When choosen, all primary keys, and default values was
copied.
My question is:
Is it possible to do the same in Microsoft SQL Server Management Studio
with
SQL Server 2005? And how do I do it?
I have tried using the "SELECT * INTO NewTable FROM OldTable"
statement, but
it just drops all information about primary keys and default values.
Best Regards
Right click on the database in Object Explorer and choose "All Tasks". Then
choose export and follow the wizard.
Andrew J. Kelly SQL MVP
<pd@.acskive.dk> wrote in message
news:1143018478.487953.10000@.i40g2000cwc.googlegro ups.com...
>I have recently moved from a Microsoft SQL Server 2000 to a SQL Server
> 2005.
> In the good old Enterprise Manager, when I imported a table from a SQL
> server to another, I could choose "Copy objects and data between SQL
> Server
> databases". When choosen, all primary keys, and default values was
> copied.
> My question is:
> Is it possible to do the same in Microsoft SQL Server Management Studio
> with
> SQL Server 2005? And how do I do it?
> I have tried using the "SELECT * INTO NewTable FROM OldTable"
> statement, but
> it just drops all information about primary keys and default values.
>
> Best Regards
>
2005.
In the good old Enterprise Manager, when I imported a table from a SQL
server to another, I could choose "Copy objects and data between SQL
Server
databases". When choosen, all primary keys, and default values was
copied.
My question is:
Is it possible to do the same in Microsoft SQL Server Management Studio
with
SQL Server 2005? And how do I do it?
I have tried using the "SELECT * INTO NewTable FROM OldTable"
statement, but
it just drops all information about primary keys and default values.
Best Regards
Right click on the database in Object Explorer and choose "All Tasks". Then
choose export and follow the wizard.
Andrew J. Kelly SQL MVP
<pd@.acskive.dk> wrote in message
news:1143018478.487953.10000@.i40g2000cwc.googlegro ups.com...
>I have recently moved from a Microsoft SQL Server 2000 to a SQL Server
> 2005.
> In the good old Enterprise Manager, when I imported a table from a SQL
> server to another, I could choose "Copy objects and data between SQL
> Server
> databases". When choosen, all primary keys, and default values was
> copied.
> My question is:
> Is it possible to do the same in Microsoft SQL Server Management Studio
> with
> SQL Server 2005? And how do I do it?
> I have tried using the "SELECT * INTO NewTable FROM OldTable"
> statement, but
> it just drops all information about primary keys and default values.
>
> Best Regards
>
Microsoft SQL Server maintenance plan
On a server running Windows NT 4.0 and Microsoft SQL Server 7 I have set up a database maintenance plan through Enterprise Manager to perform backups, database consistency checks and update statistics. The job fails to start and Event ID:208 is generated within the application log component of the event viewer log. I have set the SqlServerAgent service to start as user sqlservice, a user with administrator rights and as the system account and have logged in as these accounts to run the maintenance plan jobs with the same result.
I have performed this task before on a number of servers without encountering this problem.
ThanksDoes this also occur if you:
specify the sa account or equivalent (if running mixed authentication), use local administrator equivalent accounts,
use domain administrator equivalent accounts?
Also, did you also stop and start the services following each account change?|||Originally posted by DBA
Does this also occur if you:
specify the sa account or equivalent (if running mixed authentication), use local administrator equivalent accounts,
use domain administrator equivalent accounts?
Also, did you also stop and start the services following each account change?
Have used the sa account, domain administrator equivalent account and local administrator equivalent account with same result.
Services were cycled after each change.|||This is not helpful but at this point it could possibly be an issue of maint dlls becomming corrupt / unregistered, etc., some kind of security issue, a service pack or hot fix issue (up to date?), or something else entirely. Some things to think about may include:
Do any maint jobs run? Have any ever run sucesfully? Do non-maint jobs run fine? What is common about those that do / do not? Is the server stand alone, domain member DC, etc. (what kind of domain, any domain issues going on, etc.)? You may wish to try some interactive testing, have you tried:
copying the information from each maint. job into QA and running it interactively from QA with different accounts (note successes, failures, error messages, run a profile / trace while doing so for any that do not immediatly fail.)|||Originally posted by DBA
This is not helpful but at this point it could possibly be an issue of maint dlls becomming corrupt / unregistered, etc., some kind of security issue, a service pack or hot fix issue (up to date?), or something else entirely. Some things to think about may include:
Do any maint jobs run? Have any ever run sucesfully? Do non-maint jobs run fine? What is common about those that do / do not? Is the server stand alone, domain member DC, etc. (what kind of domain, any domain issues going on, etc.)? You may wish to try some interactive testing, have you tried:
copying the information from each maint. job into QA and running it interactively from QA with different accounts (note successes, failures, error messages, run a profile / trace while doing so for any that do not immediatly fail.)
This problem has now been resolved, further research led me to discover that the sqlmaint executable on this server was missing. I do not know the reason for this however as soon as I placed a copy in the Microsoft SQL Server binn directory, I was able to successfully execute the maintenance plan jobs.
Thank you for your prompt assistance.|||RE:
This problem has now been resolved, further research led me to discover that the sqlmaint executable on this server was missing. I do not know the reason for this however as soon as I placed a copy in the Microsoft SQL Server binn directory, I was able to successfully execute the maintenance plan jobs.
Thank you for your prompt assistance.
You are welcome.
It is kind of interesting that: "the sqlmaint executable on this server was missing"; I remember some similar complaints about issues with sql maint plans failing to execute that were apparently addressed by overwriting the sqlmaint files (exe, rll, etc). That was what led me to mention that it might possibly be an issue of corrupted maint exe, rlls, etc. (makes one wonder if something, or some rarely performed process corrupts and / or deletes them).
I have performed this task before on a number of servers without encountering this problem.
ThanksDoes this also occur if you:
specify the sa account or equivalent (if running mixed authentication), use local administrator equivalent accounts,
use domain administrator equivalent accounts?
Also, did you also stop and start the services following each account change?|||Originally posted by DBA
Does this also occur if you:
specify the sa account or equivalent (if running mixed authentication), use local administrator equivalent accounts,
use domain administrator equivalent accounts?
Also, did you also stop and start the services following each account change?
Have used the sa account, domain administrator equivalent account and local administrator equivalent account with same result.
Services were cycled after each change.|||This is not helpful but at this point it could possibly be an issue of maint dlls becomming corrupt / unregistered, etc., some kind of security issue, a service pack or hot fix issue (up to date?), or something else entirely. Some things to think about may include:
Do any maint jobs run? Have any ever run sucesfully? Do non-maint jobs run fine? What is common about those that do / do not? Is the server stand alone, domain member DC, etc. (what kind of domain, any domain issues going on, etc.)? You may wish to try some interactive testing, have you tried:
copying the information from each maint. job into QA and running it interactively from QA with different accounts (note successes, failures, error messages, run a profile / trace while doing so for any that do not immediatly fail.)|||Originally posted by DBA
This is not helpful but at this point it could possibly be an issue of maint dlls becomming corrupt / unregistered, etc., some kind of security issue, a service pack or hot fix issue (up to date?), or something else entirely. Some things to think about may include:
Do any maint jobs run? Have any ever run sucesfully? Do non-maint jobs run fine? What is common about those that do / do not? Is the server stand alone, domain member DC, etc. (what kind of domain, any domain issues going on, etc.)? You may wish to try some interactive testing, have you tried:
copying the information from each maint. job into QA and running it interactively from QA with different accounts (note successes, failures, error messages, run a profile / trace while doing so for any that do not immediatly fail.)
This problem has now been resolved, further research led me to discover that the sqlmaint executable on this server was missing. I do not know the reason for this however as soon as I placed a copy in the Microsoft SQL Server binn directory, I was able to successfully execute the maintenance plan jobs.
Thank you for your prompt assistance.|||RE:
This problem has now been resolved, further research led me to discover that the sqlmaint executable on this server was missing. I do not know the reason for this however as soon as I placed a copy in the Microsoft SQL Server binn directory, I was able to successfully execute the maintenance plan jobs.
Thank you for your prompt assistance.
You are welcome.
It is kind of interesting that: "the sqlmaint executable on this server was missing"; I remember some similar complaints about issues with sql maint plans failing to execute that were apparently addressed by overwriting the sqlmaint files (exe, rll, etc). That was what led me to mention that it might possibly be an issue of corrupted maint exe, rlls, etc. (makes one wonder if something, or some rarely performed process corrupts and / or deletes them).
Subscribe to:
Posts (Atom)