Welsh Corgi

Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 3,738 total)

RE: Error Restoring MSDB to another machine

ok sound good. I will not worry about scripting out the maintenance plans.
I create them last week to perform backups, etc and it did not take me very long to...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 20, 2012 at 8:02 am

#1436513
RE: Script Maintenance Plans SQL Server 2005

padhis (1/20/2012)
Check this.
http://sqlservernewbie.blogspot.com/2008/10/how-to-importexport-sql-server.html
Nice but it hangs when I load the page.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 20, 2012 at 7:43 am

#1436500
RE: Script out Jobs & Logins Master DB

Lowell (1/20/2012)
i just copied and pasted my quoted command, and tested it in both SQL2005 and SQL2008, and i got results with no errors at all.
I'm not sure where your...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 20, 2012 at 7:41 am

#1436495
RE: Error Restoring MSDB to another machine

I fixed my typo and attempted to restore but because the machine that I made the backup was not at SP4 and the target machine was I could not restore.:w00t:
I'm...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 20, 2012 at 7:31 am

#1436485
RE: MSDB Stuck in Single User Mode

Never mind I was able to resolve.
Find the session that put it into single user mode, kill it and set to multi-user mode.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 20, 2012 at 7:25 am

#1436480
RE: Error Restoring MSDB to another machine

george sibbald (1/20/2012)
you haven't specified the full path to the backup so SQL is presuming its in the default directory. I presume its somewhere else.
Are you trying to move the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 20, 2012 at 7:00 am

#1436459
RE: Script out Jobs & Logins Master DB

Lowell (1/19/2012)
I'll look for or create a script for linked servers;
the problem is the credentials for the remote user, if you identify one, cannot be scripted out, because they are...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 20, 2012 at 6:06 am

#1436420
RE: ODBC not showing SQL 2000 tables

gweiho4xd2 (1/20/2012)
Hi,
The default database is set by the SQL server user login to our 'planning' database.
I've also manually set the database to 'planning' in the ODBC connection but still no...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 20, 2012 at 5:26 am

#1436391
RE: SQLServerAgent could not be started (reason: Error creating a new session).

Unfortunately it did not work.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 19, 2012 at 6:14 pm

#1436258
RE: Script out Jobs & Logins Master DB

savethytrees (1/19/2012)
II am sure that the developer you are referring to, was already a part of db_denydatareader and db_denydatawriter.
Someone had to change the permission later this afternoon because he...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 19, 2012 at 3:27 pm

#1436224
RE: Script out Jobs & Logins Master DB

Where did you get that script?
Try running it on a production box.:w00t:
I had a Developer who was a member of the fixed database role db_owner and it added him to...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 19, 2012 at 2:21 pm

#1436183
RE: What is the safest less risky way to move System Databases to another Server?

I just wanted to make sure.
Thanks Lowell.:cool:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 19, 2012 at 1:54 pm

#1436168
RE: Script out Jobs & Logins Master DB

savethytrees (1/19/2012)
For jobs, I would rather use a VB script. The TSQL method puts a limitation on the length of a job step that is being scripted.
Check this
http://saveadba.blogspot.com/2011/12/sql-server-2005-generate-scripts-for.html
Check out the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 19, 2012 at 1:40 pm

#1436156
RE: Script out Jobs & Logins Master DB

savethytrees (1/19/2012)
For jobs, I would rather use a VB script. The TSQL method puts a limitation on the length of a job step that is being scripted.
Check this
http://saveadba.blogspot.com/2011/12/sql-server-2005-generate-scripts-for.html
Check out the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 19, 2012 at 1:14 pm

#1436144
RE: What is the safest less risky way to move System Databases to another Server?

Lowell (1/18/2012)
for the scripting of jobs and linked servers, look in the script section here; there's several that do a great job there;i haven't done it in a while, so...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 19, 2012 at 12:46 pm

#1436134

Viewing 15 posts - 1,846 through 1,860 (of 3,738 total)