SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Dead
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 09/29/2010 :  08:20:31  Show Profile  Reply with Quote
All has been working perfectly, a few minutes ago. No changes made. Inaccessible locally or remotely, which was fine. I'm scrambling for answers! Engine is running, just as it was. One thing I tried was to restart it.

I did try the REPAIR process from the installation disk. No issues


TITLE: Connect to Server
------------------------------

Cannot connect to PETERBRETT\AUG2009.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 09/29/2010 :  11:02:45  Show Profile  Reply with Quote
Can anyone interpret this?


===================================

Cannot connect to PETERBRETT\AUG2009.

===================================

Cannot open user default database. Login failed.
Login failed for user 'PETERBRETT\Administrator'. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476

------------------------------
Server Name: PETERBRETT\AUG2009
Error Number: 4064
Severity: 11
State: 1
Line Number: 65536


------------------------------
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Go to Top of Page

robvolk
Most Valuable Yak

USA
15658 Posts

Posted - 09/29/2010 :  11:16:45  Show Profile  Visit robvolk's Homepage  Reply with Quote
Has the password been changed for that account? Is it locked/disabled?

If that's the service account under which SQL Server runs, can you change it to another account and restart?
Go to Top of Page

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 09/30/2010 :  03:04:40  Show Profile  Reply with Quote
The Crystal Reports application can use the service, and pull data from it, as normal! SQLSERVER is running

The local or remote SSMS are refused access. One thing I did, once I had full access yesterday from local and remote SSMS successfully, while I was trying to copy a database, this had some major errors.. I took a database offline, so it showed remotely with the red down arrow. Locally, it showed as live. Then all the problems started. Because this database might be the default one for login, SSMS is rejected a connection? I can alter the account, but this action ends up in an error, and it has to revert to it's pervious state. It runs as NT AUTHORITY\NETWORK SERVICE which worked fine for both machines until I tool the database offline
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 09/30/2010 :  03:25:21  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
quote:
Originally posted by mikebird

Can anyone interpret this?


The error's pretty clear

quote:
Cannot open user default database. Login failed.


The default database for that login is not available. It may have been dropped. It may be offline. It may be restoring. Whichever it is, the login requested to access that DB and SQL cannot. Hence the login fails.

Log in with another user, preferably one with master as the default (a sysadmin should have master as the default DB) and check what default DB that login has and what is wrong with it.


--
Gail Shaw
SQL Server MVP
Go to Top of Page

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 09/30/2010 :  03:41:31  Show Profile  Reply with Quote
sa with known password, which worked well yesterday, is rejected, in the same way as the Windows login. What about the second tab of the login window? Set to default, I put master in there and it's still rejected. Adventureworks - same result...
Go to Top of Page

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 09/30/2010 :  05:11:05  Show Profile  Reply with Quote
Is there an alternative method other than SSMS to connect to SQLSERVER to bring a database online? Any DBCC CHECKDB.. anything else?
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 09/30/2010 :  08:01:56  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Without knowing why the databases are not available, it is impossible to suggest a resolution. It is also impossible to do anything useful to a database without having a connection to the server.

Master MUST be available as SQL wouldn't be running if it wasn't.

What's the reasons for the login failures when you specified master as the DB to connect to? (Check the SQL error log, SSMS won't tell you)

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 09/30/2010 :  10:03:44  Show Profile  Reply with Quote
Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out
http://msdn.microsoft.com/en-us/library/dd207004(v=SQL.100).aspx

How to Connect to a SQL 2005 Server When You Are Completely Locked Out
http://www.sqlservercentral.com/articles/Administration/68271/

Discussion: How to Connect to a SQL 2005 Server When You Are Completely Locked Out
http://www.sqlservercentral.com/Forums/Topic812701-471-1.aspx




CODO ERGO SUM
Go to Top of Page

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 10/03/2010 :  03:35:09  Show Profile  Reply with Quote
Michael

This was great. Looking at sqlcmd or sqlservr, I get failure. The command, while it's RIGHT THERE, in my instance directory, it is not recognised and cannot be run
Go to Top of Page

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 10/03/2010 :  03:39:38  Show Profile  Reply with Quote
2010-10-03 07:45:34.51 Server Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (Intel X86)
Sep 16 2010 20:09:22
Copyright (c) 1988-2008 Microsoft Corporation
Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) (VM)

2010-10-03 07:45:34.56 Server Error: 17054, Severity: 16, State: 1.
2010-10-03 07:45:34.56 Server The current event was not reported to the Windows Events log. Operating system error = 1502(The event log file is full.). You may need to clear the Windows Events log if it is full.
2010-10-03 07:45:34.56 Server (c) 2005 Microsoft Corporation.
2010-10-03 07:45:34.56 Server All rights reserved.
2010-10-03 07:45:34.56 Server Server process ID is 852.
2010-10-03 07:45:34.56 Server Authentication mode is MIXED.
2010-10-03 07:45:34.56 Server Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL10.PRO\MSSQL\Log\ERRORLOG'.
2010-10-03 07:45:34.57 Server This instance of SQL Server last reported using a process ID of 3632 at 03/10/2010 07:36:45 (local) 03/10/2010 06:36:45 (UTC). This is an informational message only; no user action is required.
2010-10-03 07:45:34.57 Server Registry startup parameters:
-d E:\Program Files\Microsoft SQL Server\MSSQL10.PRO\MSSQL\DATA\master.mdf
-e E:\Program Files\Microsoft SQL Server\MSSQL10.PRO\MSSQL\Log\ERRORLOG
-l E:\Program Files\Microsoft SQL Server\MSSQL10.PRO\MSSQL\DATA\mastlog.ldf
2010-10-03 07:45:34.57 Server Command Line Startup Parameters:
-m SqlSetup
-T 4022
-T 4010
-T 1905
2010-10-03 07:45:34.60 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-10-03 07:45:34.60 Server Detected 4 CPUs. This is an informational message; no user action is required.
2010-10-03 07:45:35.35 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2010-10-03 07:45:35.37 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2010-10-03 07:45:35.81 Server Node configuration: node 0: CPU mask: 0x0000000f Active CPU mask: 0x0000000f. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2010-10-03 07:45:35.94 Server Database Mirroring Transport is disabled in the endpoint configuration.
2010-10-03 07:45:35.95 spid7s Warning ******************
2010-10-03 07:45:35.95 spid7s SQL Server started in single-user mode. This an informational message only. No user action is required.
2010-10-03 07:45:36.01 spid7s Starting up database 'master'.
2010-10-03 07:45:36.22 spid7s 10 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2010-10-03 07:45:36.25 spid7s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2010-10-03 07:45:36.26 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-10-03 07:45:36.60 spid7s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2010-10-03 07:45:36.62 spid7s SQL Server Audit has started the audits. This is an informational message. No user action is required.
<{39B75A24-0837-4CEC-AFDF-B960027AE07E}>RsFxNso initialized. InstanceId = 00000005
<{50080099-5EC4-4EAF-A2A2-63C3DA97F8EB}>FsAgent is initialized
<{09C4480B-DBA4-49B7-956F-68A8B8B2445D}>FsAgent is up and running
2010-10-03 07:45:36.73 spid7s FILESTREAM: effective level = 3, configured level = 3, file system access share name = 'PRO'.
2010-10-03 07:45:36.92 spid7s SQL Trace ID 1 was started by login "sa".
2010-10-03 07:45:36.96 spid7s Starting up database 'mssqlsystemresource'.
2010-10-03 07:45:36.99 spid7s The resource database build version is 10.00.4000. This is an informational message only. No user action is required.
2010-10-03 07:45:37.24 spid15s Starting up database 'model'.
2010-10-03 07:45:37.26 spid7s Server name is 'PRO\PRO'. This is an informational message only. No user action is required.
2010-10-03 07:45:37.45 spid15s Clearing tempdb database.
2010-10-03 07:45:37.85 spid16s Error: 9954, Severity: 16, State: 1.
2010-10-03 07:45:37.85 spid16s SQL Server failed to communicate with filter daemon launch service (Windows error: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.
). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.
2010-10-03 07:45:37.92 spid16s Starting up database 'msdb'.
2010-10-03 07:45:37.92 spid21s Starting up database 'AdventureWorks'.
2010-10-03 07:45:37.92 spid19s Starting up database 'ReportServer$PROTempDB'.
2010-10-03 07:45:37.92 spid18s Starting up database 'supermarket'.
2010-10-03 07:45:37.93 spid22s Starting up database 'AdventureWorksDW'.
2010-10-03 07:45:37.93 spid20s Starting up database 'SatelliteInformationServices'.
2010-10-03 07:45:37.93 spid17s Starting up database 'ReportServer$PRO'.
2010-10-03 07:45:38.62 spid20s 2 transactions rolled forward in database 'SatelliteInformationServices' (8). This is an informational message only. No user action is required.
2010-10-03 07:45:38.98 spid16s 14 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2010-10-03 07:45:39.12 spid7s 0 transactions rolled back in database 'SatelliteInformationServices' (8). This is an informational message only. No user action is required.
2010-10-03 07:45:39.12 spid7s Recovery is writing a checkpoint in database 'SatelliteInformationServices' (8). This is an informational message only. No user action is required.
2010-10-03 07:45:39.43 spid7s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2010-10-03 07:45:39.43 spid7s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2010-10-03 07:45:39.43 spid7s Recovery completed for database msdb (database ID 4) in 1 second(s) (analysis 229 ms, redo 407 ms, undo 348 ms.) This is an informational message only. No user action is required.
2010-10-03 07:45:39.80 spid15s Starting up database 'tempdb'.
2010-10-03 07:45:39.85 spid17s 1 transactions rolled forward in database 'ReportServer$PRO' (5). This is an informational message only. No user action is required.
2010-10-03 07:45:39.98 spid7s 0 transactions rolled back in database 'ReportServer$PRO' (5). This is an informational message only. No user action is required.
2010-10-03 07:45:39.98 spid7s Recovery is writing a checkpoint in database 'ReportServer$PRO' (5). This is an informational message only. No user action is required.
2010-10-03 07:45:40.66 Server A self-generated certificate was successfully loaded for encryption.
2010-10-03 07:45:40.69 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\PRO ].
2010-10-03 07:45:40.69 Server Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required.
2010-10-03 07:45:40.76 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2010-10-03 07:45:40.76 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-10-03 07:45:41.98 spid7s Database 'master' is upgrading script 'sqlagent100_msdb_upgrade.sql' from level 0 to level 3.
2010-10-03 07:45:42.07 spid7s ----------------------------------------
2010-10-03 07:45:42.08 spid7s Starting execution of PREINSTMSDB100.SQL
2010-10-03 07:45:42.08 spid7s ----------------------------------------
2010-10-03 07:45:42.69 spid7s Setting database option COMPATIBILITY_LEVEL to 100 for database msdb.
2010-10-03 07:45:43.07 spid7s Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install.
2010-10-03 07:45:43.07 spid7s Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install.
2010-10-03 07:45:43.07 spid7s FILESTREAM: effective level = 3, configured level = 3, file system access share name = 'PRO'.
2010-10-03 07:45:46.56 spid7s Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2010-10-03 07:45:46.76 spid7s Using 'xpstar.dll' version '2007.100.4000' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2010-10-03 07:45:46.94 spid7s DBCC TRACEOFF 1717, server process ID (SPID) 7. This is an informational message only; no user action is required.
2010-10-03 07:45:46.94 spid7s DBCC execution completed. If DBCC printed error messages, contact your system administrator.
2010-10-03 07:45:46.95 spid7s
2010-10-03 07:45:46.95 spid7s Creating table temp_sysjobschedules
2010-10-03 07:45:47.26 spid7s
2010-10-03 07:45:47.26 spid7s Alter table sysdownloadlist...
2010-10-03 07:45:47.28 spid7s
2010-10-03 07:45:47.28 spid7s Alter table sysjobhistory...
2010-10-03 07:45:47.28 spid7s
2010-10-03 07:45:47.28 spid7s Alter table systargetservers...
2010-10-03 07:45:47.28 spid7s Check if syssubsystems table exists...
2010-10-03 07:45:47.71 spid7s Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.
2010-10-03 07:45:47.71 spid7s Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.
2010-10-03 07:45:47.71 spid7s FILESTREAM: effective level = 3, configured level = 3, file system access share name = 'PRO'.
2010-10-03 07:45:47.81 spid7s DMF pre-upgrade steps...
2010-10-03 07:45:47.84 spid7s DC pre-upgrade steps...
2010-10-03 07:45:47.84 spid7s Check if Data collector config table exists...
2010-10-03 07:45:47.84 spid7s Data Collector state before upgrade: 0
2010-10-03 07:45:48.09 spid7s Deleting cached auto-generated T-SQL Data Collection packages from msdb...
2010-10-03 07:45:48.10 spid7s End of DC pre-upgrade steps.
2010-10-03 07:45:48.10 spid7s
2010-10-03 07:45:48.10 spid7s ----------------------------------------
2010-10-03 07:45:48.10 spid7s Execution of PREINSTMSDB100.SQL complete
2010-10-03 07:45:48.10 spid7s ----------------------------------------
2010-10-03 07:45:48.10 spid7s ----------------------------------
2010-10-03 07:45:48.10 spid7s Starting execution of INSTMSDB.SQL
2010-10-03 07:45:48.10 spid7s ----------------------------------
2010-10-03 07:45:48.19 spid7s Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.
2010-10-03 07:45:48.19 spid7s Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.
2010-10-03 07:45:48.19 spid7s FILESTREAM: effective level = 3, configured level = 3, file system access share name = 'PRO'.
2010-10-03 07:45:48.33 spid7s Checking the size of MSDB...
2010-10-03 07:45:48.58 spid7s
2010-10-03 07:45:48.58 spid7s Setting database option TRUSTWORTHY to ON for database msdb.
2010-10-03 07:45:48.58 spid7s Setting database option RECOVERY to SIMPLE for database msdb.
2010-10-03 07:45:48.66 spid7s Dropping view MSdatatype_mappings...
2010-10-03 07:45:48.67 spid7s Dropping view sysdatatypemappings...
2010-10-03 07:45:48.67 spid7s Dropping table MSdbms_datatype_mapping...
2010-10-03 07:45:48.69 spid7s Dropping table MSdbms_map...
2010-10-03 07:45:48.69 spid7s Dropping table MSdbms_datatype...
2010-10-03 07:45:48.70 spid7s Dropping table MSdbms...
2010-10-03 07:45:48.75 spid7s
2010-10-03 07:45:48.75 spid7s Creating table syssubsystems...
2010-10-03 07:45:48.76 spid7s
2010-10-03 07:45:48.76 spid7s Creating view sysproxyloginsubsystem_view...
2010-10-03 07:45:48.78 spid7s
2010-10-03 07:45:48.78 spid7s Creating trigger trig_sysoriginatingservers_delete...
2010-10-03 07:45:48.79 spid7s
2010-10-03 07:45:48.79 spid7s Creating view sysoriginatingservers_view...
2010-10-03 07:45:48.82 spid7s
2010-10-03 07:45:48.82 spid7s Creating trigger trig_sysjobs_insert_update...
2010-10-03 07:45:48.83 spid7s
2010-10-03 07:45:48.83 spid7s Creating view sysjobs_view...
2010-10-03 07:45:48.86 spid7s
2010-10-03 07:45:48.86 spid7s Creating trigger trig_sysschedules_insert_update...
2010-10-03 07:45:48.86 spid7s
2010-10-03 07:45:48.86 spid7s Creating view sysschedules_localserver_view...
2010-10-03 07:45:48.95 spid7s
2010-10-03 07:45:48.95 spid7s Creating view systargetservers_view...
2010-10-03 07:45:49.04 spid7s Creating table MSdbms
2010-10-03 07:45:49.06 spid7s Creating table MSdbms_datatype
2010-10-03 07:45:49.34 spid7s Creating table MSdbms_map
2010-10-03 07:45:49.37 spid7s Creating table MSdbms_datatype_mapping
2010-10-03 07:45:49.38 spid7s Definining default datatype mappings
2010-10-03 07:45:49.42 spid7s Creating datatype mappings for MSSQLSERVER to ORACLE8
2010-10-03 07:45:49.68 spid7s Creating datatype mappings for MSSQLSERVER to ORACLE9
2010-10-03 07:45:49.77 spid7s Creating datatype mappings for MSSQLSERVER to ORACLE10
2010-10-03 07:45:49.83 spid7s Creating datatype mappings for MSSQLSERVER to ORACLE11
2010-10-03 07:45:49.92 spid7s Creating datatype mappings for MSSQLSERVER to DB2
2010-10-03 07:45:50.00 spid7s Creating datatype mappings for MSSQLSERVER to SYBASE
2010-10-03 07:45:50.07 spid7s Creating datatype mappings for ORACLE8 to MSSQLSERVER
2010-10-03 07:45:50.16 spid7s Creating datatype mappings for ORACLE9 to MSSQLSERVER
2010-10-03 07:45:50.27 spid7s Creating datatype mappings for ORACLE10 to MSSQLServer
2010-10-03 07:45:50.36 spid7s Creating datatype mappings for ORACLE11 to MSSQLServer
2010-10-03 07:45:50.46 spid7s Creating view MSdatatype_mappings
2010-10-03 07:45:50.46 spid7s Creating view sysdatatypemappings
2010-10-03 07:45:50.52 spid7s
2010-10-03 07:45:50.52 spid7s Creating function SQLAGENT_SUSER_SNAME ...
2010-10-03 07:45:50.53 spid7s
2010-10-03 07:45:50.53 spid7s Creating function SQLAGENT_SUSER_SID ...
2010-10-03 07:45:50.53 spid7s
2010-10-03 07:45:50.53 spid7s Creating procedure SP_SQLAGENT_IS_SRVROLEMEMBER...
2010-10-03 07:45:50.54 spid7s
2010-10-03 07:45:50.54 spid7s Creating procedure sp_verify_category_identifiers...
2010-10-03 07:45:50.54 spid7s
2010-10-03 07:45:50.54 spid7s Creating function agent_datetime...
2010-10-03 07:45:50.54 spid7s
2010-10-03 07:45:50.54 spid7s Creating procedure sp_verify_proxy_identifiers...
2010-10-03 07:45:50.55 spid7s
2010-10-03 07:45:50.55 spid7s Creating procedure sp_verify_credential_identifiers...
2010-10-03 07:45:50.57 spid7s
2010-10-03 07:45:50.57 spid7s Creating procedure sp_verify_subsystems...
2010-10-03 07:45:50.61 spid7s
2010-10-03 07:45:50.62 spid7s Creating procedure sp_verify_subsystem_identifiers...
2010-10-03 07:45:50.64 spid7s
2010-10-03 07:45:50.64 spid7s Creating procedure sp_verify_login_identifiers...
2010-10-03 07:45:50.65 spid7s
2010-10-03 07:45:50.65 spid7s Creating procedure sp_verify_proxy...
2010-10-03 07:45:50.65 spid7s
2010-10-03 07:45:50.65 spid7s Creating procedure sp_add_proxy...
2010-10-03 07:45:50.66 spid7s
2010-10-03 07:45:50.66 spid7s Creating procedure sp_delete_proxy...
2010-10-03 07:45:50.66 spid7s
2010-10-03 07:45:50.66 spid7s Creating procedure sp_update_proxy...
2010-10-03 07:45:50.70 spid7s
2010-10-03 07:45:50.70 spid7s Creating procedure sp_sqlagent_is_member...
2010-10-03 07:45:50.70 spid7s
2010-10-03 07:45:50.70 spid7s Creating procedure sp_verify_proxy_permissions...
2010-10-03 07:45:50.70 spid7s
2010-10-03 07:45:50.70 spid7s Creating procedure sp_help_proxy...
2010-10-03 07:45:50.71 spid7s
2010-10-03 07:45:50.71 spid7s Creating procedure sp_grant_proxy_to_subsystem...
2010-10-03 07:45:50.71 spid7s
2010-10-03 07:45:50.71 spid7s Creating procedure sp_grant_login_to_proxy...
2010-10-03 07:45:50.72 spid7s
2010-10-03 07:45:50.72 spid7s Creating procedure sp_revoke_login_from_proxy...
2010-10-03 07:45:50.72 spid7s
2010-10-03 07:45:50.72 spid7s Creating procedure sp_revoke_proxy_from_subsystem...
2010-10-03 07:45:50.72 spid7s
2010-10-03 07:45:50.72 spid7s Creating procedure sp_enum_proxy_for_subsystem...
2010-10-03 07:45:50.73 spid7s
2010-10-03 07:45:50.73 spid7s Creating procedure sp_enum_login_for_proxy...
2010-10-03 07:45:50.73 spid7s
2010-10-03 07:45:50.73 spid7s Creating procedure sp_sqlagent_get_startup_info...
2010-10-03 07:45:50.76 spid7s
2010-10-03 07:45:50.76 spid7s Creating procedure sp_sqlagent_has_server_access...
2010-10-03 07:45:50.81 spid7s
2010-10-03 07:45:50.81 spid7s Creating procedure sp_sem_add_message...
2010-10-03 07:45:50.86 spid7s
2010-10-03 07:45:50.86 spid7s Creating procedure sp_sem_drop_message...
2010-10-03 07:45:50.86 spid7s
2010-10-03 07:45:50.86 spid7s Creating procedure sp_get_message_description...
2010-10-03 07:45:50.87 spid7s
2010-10-03 07:45:50.87 spid7s Creating procedure sp_sqlagent_get_perf_counters...
2010-10-03 07:45:50.91 spid7s
2010-10-03 07:45:50.91 spid7s Creating procedure sp_sqlagent_notify...
2010-10-03 07:45:50.94 spid7s
2010-10-03 07:45:50.94 spid7s Creating procedure sp_is_sqlagent_starting...
2010-10-03 07:45:50.95 spid7s
2010-10-03 07:45:50.95 spid7s Creating procedure sp_verify_job_identifiers...
2010-10-03 07:45:50.96 spid7s
2010-10-03 07:45:50.96 spid7s Creating procedure sp_verify_schedule_identifiers...
2010-10-03 07:45:50.97 spid7s
2010-10-03 07:45:50.97 spid7s Creating procedure sp_verify_jobproc_caller...
2010-10-03 07:45:50.98 spid7s
2010-10-03 07:45:50.98 spid7s Creating procedure sp_downloaded_row_limiter...
2010-10-03 07:45:50.98 spid7s
2010-10-03 07:45:50.98 spid7s Creating procedure sp_post_msx_operation...
2010-10-03 07:45:51.00 spid7s
2010-10-03 07:45:51.00 spid7s Creating procedure sp_verify_performance_condition...
2010-10-03 07:45:51.01 spid7s
2010-10-03 07:45:51.01 spid7s Creating procedure sp_verify_job_date...
2010-10-03 07:45:51.01 spid7s
2010-10-03 07:45:51.01 spid7s Creating procedure sp_verify_job_time...
2010-10-03 07:45:51.02 spid7s
2010-10-03 07:45:51.02 spid7s Creating procedure sp_verify_alert...
2010-10-03 07:45:51.03 spid7s
2010-10-03 07:45:51.03 spid7s Creating procedure sp_update_alert...
2010-10-03 07:45:51.04 spid7s
2010-10-03 07:45:51.04 spid7s Creating procedure sp_delete_job_references...
2010-10-03 07:45:51.06 spid7s
2010-10-03 07:45:51.06 spid7s Creating procedure sp_delete_all_msx_jobs...
2010-10-03 07:45:51.07 spid7s
2010-10-03 07:45:51.07 spid7s Creating procedure sp_generate_target_server_job_assignment_sql...
2010-10-03 07:45:51.08 spid7s
2010-10-03 07:45:51.08 spid7s Creating procedure sp_generate_server_description...
2010-10-03 07:45:51.09 spid7s
2010-10-03 07:45:51.09 spid7s Creating procedure sp_msx_set_account...
2010-10-03 07:45:51.09 spid7s
2010-10-03 07:45:51.09 spid7s Creating procedure sp_msx_get_account...
2010-10-03 07:45:51.10 spid7s
2010-10-03 07:45:51.10 spid7s Creating procedure sp_delete_operator...
2010-10-03 07:45:51.11 spid7s
2010-10-03 07:45:51.11 spid7s Creating procedure sp_msx_defect...
2010-10-03 07:45:51.15 spid7s
2010-10-03 07:45:51.15 spid7s Creating procedure sp_msx_enlist...
2010-10-03 07:45:51.16 spid7s
2010-10-03 07:45:51.16 spid7s Creating procedure sp_delete_targetserver...
2010-10-03 07:45:51.17 spid7s
2010-10-03 07:45:51.17 spid7s Creating procedure sp_enlist_tsx
2010-10-03 07:45:51.18 spid7s
2010-10-03 07:45:51.18 spid7s Creating procedure sp_get_sqlagent_properties...
2010-10-03 07:45:51.21 spid7s
2010-10-03 07:45:51.21 spid7s Create procedure sp_set_sqlagent_properties...
2010-10-03 07:45:51.21 spid7s
2010-10-03 07:45:51.21 spid7s Creating procedure sp_add_targetservergroup...
2010-10-03 07:45:51.22 spid7s
2010-10-03 07:45:51.22 spid7s Creating procedure sp_update_targetservergroup...
2010-10-03 07:45:51.23 spid7s
2010-10-03 07:45:51.23 spid7s Creating procedure sp_delete_targetservergroup...
2010-10-03 07:45:51.23 spid7s
2010-10-03 07:45:51.23 spid7s Creating procedure sp_help_targetservergroup...
2010-10-03 07:45:51.24 spid7s
2010-10-03 07:45:51.24 spid7s Creating procedure sp_add_targetsvgrp_member...
2010-10-03 07:45:51.25 spid7s
2010-10-03 07:45:51.25 spid7s Creating procedure sp_delete_targetsvrgrp_member...
2010-10-03 07:45:51.25 spid7s
2010-10-03 07:45:51.25 spid7s Creating procedure sp_verify_category...
2010-10-03 07:45:51.26 spid7s
2010-10-03 07:45:51.26 spid7s Creating procedure sp_add_category...
2010-10-03 07:45:51.26 spid7s
2010-10-03 07:45:51.26 spid7s Creating procedure sp_update_category...
2010-10-03 07:45:51.27 spid7s
2010-10-03 07:45:51.27 spid7s Creating procedure sp_delete_category...
2010-10-03 07:45:51.28 spid7s
2010-10-03 07:45:51.28 spid7s Creating procedure sp_help_category...
2010-10-03 07:45:51.29 spid7s
2010-10-03 07:45:51.29 spid7s Creating procedure sp_help_targetserver...
2010-10-03 07:45:51.29 spid7s
2010-10-03 07:45:51.29 spid7s Creating procedure sp_resync_targetserver...
2010-10-03 07:45:51.37 spid7s
2010-10-03 07:45:51.37 spid7s Creating procedure sp_purge_jobhistory...
2010-10-03 07:45:51.45 spid7s
2010-10-03 07:45:51.45 spid7s Creating procedure sp_help_jobhistory...
2010-10-03 07:45:51.46 spid7s
2010-10-03 07:45:51.46 spid7s Creating procedure sp_add_jobserver...
2010-10-03 07:45:51.47 spid7s
2010-10-03 07:45:51.47 spid7s Creating procedure sp_delete_jobserver...
2010-10-03 07:45:51.48 spid7s
2010-10-03 07:45:51.48 spid7s Creating procedure sp_help_jobserver...
2010-10-03 07:45:51.48 spid7s
2010-10-03 07:45:51.48 spid7s Creating procedure sp_help_downloadlist...
2010-10-03 07:45:51.49 spid7s
2010-10-03 07:45:51.49 spid7s Creating procedure sp_enum_sqlagent_subsystems_internal...
2010-10-03 07:45:51.50 spid7s
2010-10-03 07:45:51.50 spid7s Creating procedure sp_enum_sqlagent_subsystems...
2010-10-03 07:45:51.50 spid7s
2010-10-03 07:45:51.50 spid7s Creating procedure sp_verify_subsystem...
2010-10-03 07:45:51.51 spid7s
2010-10-03 07:45:51.51 spid7s Creating procedure sp_verify_schedule...
2010-10-03 07:45:51.52 spid7s
2010-10-03 07:45:51.52 spid7s Creating procedure sp_add_schedule...
2010-10-03 07:45:51.53 spid7s
2010-10-03 07:45:51.53 spid7s Creating procedure sp_attach_schedule ...
2010-10-03 07:45:51.54 spid7s
2010-10-03 07:45:51.54 spid7s Creating procedure sp_detach_schedule ...
2010-10-03 07:45:51.56 spid7s
2010-10-03 07:45:51.56 spid7s Creating procedure sp_update_replication_job_parameter...
2010-10-03 07:45:51.57 spid7s
2010-10-03 07:45:51.57 spid7s Creating procedure sp_update_schedule ...
2010-10-03 07:45:51.58 spid7s
2010-10-03 07:45:51.58 spid7s Creating procedure sp_delete_schedule ...
2010-10-03 07:45:51.58 spid7s
2010-10-03 07:45:51.58 spid7s Creating procedure sp_get_jobstep_db_username...
2010-10-03 07:45:51.59 spid7s
2010-10-03 07:45:51.59 spid7s Creating procedure sp_verify_jobstep...
2010-10-03 07:45:51.62 spid7s
2010-10-03 07:45:51.62 spid7s Creating procedure sp_add_jobstep_internal...
2010-10-03 07:45:51.64 spid7s
2010-10-03 07:45:51.64 spid7s Creating procedure sp_add_jobstep...
2010-10-03 07:45:51.65 spid7s
2010-10-03 07:45:51.65 spid7s Creating procedure sp_update_jobstep...
2010-10-03 07:45:51.66 spid7s
2010-10-03 07:45:51.66 spid7s Creating procedure sp_delete_jobstep...
2010-10-03 07:45:51.67 spid7s
2010-10-03 07:45:51.67 spid7s Creating procedure sp_help_jobstep...
2010-10-03 07:45:51.68 spid7s
2010-10-03 07:45:51.68 spid7s Creating procedure sp_write_sysjobstep_log...
2010-10-03 07:45:51.70 spid7s
2010-10-03 07:45:51.70 spid7s Creating procedure sp_help_jobsteplog...
2010-10-03 07:45:51.71 spid7s
2010-10-03 07:45:51.71 spid7s Creating procedure sp_delete_jobsteplog...
2010-10-03 07:45:51.72 spid7s
2010-10-03 07:45:51.72 spid7s Creating procedure sp_get_schedule_description...
2010-10-03 07:45:51.77 spid7s
2010-10-03 07:45:51.77 spid7s Creating procedure sp_add_jobschedule...
2010-10-03 07:45:51.78 spid7s
2010-10-03 07:45:51.78 spid7s Creating procedure sp_update_jobschedule...
2010-10-03 07:45:51.79 spid7s
2010-10-03 07:45:51.79 spid7s Creating procedure sp_delete_jobschedule...
2010-10-03 07:45:51.80 spid7s
2010-10-03 07:45:51.80 spid7s Creating procedure sp_help_schedule...
2010-10-03 07:45:51.81 spid7s
2010-10-03 07:45:51.81 spid7s Creating procedure sp_help_jobschedule...
2010-10-03 07:45:51.83 spid7s
2010-10-03 07:45:51.83 spid7s Creating procedure sp_verify_job...
2010-10-03 07:45:51.85 spid7s
2010-10-03 07:45:51.85 spid7s Creating procedure sp_add_job...
2010-10-03 07:45:51.86 spid7s
2010-10-03 07:45:51.86 spid7s Creating procedure sp_update_job...
2010-10-03 07:45:51.87 spid7s
2010-10-03 07:45:51.87 spid7s Creating procedure sp_delete_job...
2010-10-03 07:45:51.88 spid7s
2010-10-03 07:45:51.88 spid7s Creating procedure sp_get_composite_job_info...
2010-10-03 07:45:51.91 spid7s
2010-10-03 07:45:51.91 spid7s Creating procedure sp_help_job...
2010-10-03 07:45:51.94 spid7s
2010-10-03 07:45:51.94 spid7s Creating procedure sp_help_jobcount...
2010-10-03 07:45:51.94 spid7s
2010-10-03 07:45:51.94 spid7s Creating procedure sp_help_jobs_in_schedule...
2010-10-03 07:45:51.95 spid7s
2010-10-03 07:45:51.95 spid7s Creating procedure sp_manage_jobs_by_login...
2010-10-03 07:45:51.95 spid7s
2010-10-03 07:45:51.95 spid7s Creating procedure sp_apply_job_to_targets...
2010-10-03 07:45:51.99 spid7s
2010-10-03 07:45:51.99 spid7s Creating procedure sp_remove_job_from_targets...
2010-10-03 07:45:52.00 spid7s
2010-10-03 07:45:52.00 spid7s Creating procedure sp_get_job_alerts...
2010-10-03 07:45:52.00 spid7s
2010-10-03 07:45:52.00 spid7s Creating procedure sp_convert_jobid_to_char...
2010-10-03 07:45:52.01 spid7s
2010-10-03 07:45:52.01 spid7s Creating procedure sp_start_job...
2010-10-03 07:45:52.02 spid7s
2010-10-03 07:45:52.02 spid7s Creating procedure sp_stop_job...
2010-10-03 07:45:52.02 spid7s
2010-10-03 07:45:52.02 spid7s Creating procedure sp_cycle_agent_errorlog...
2010-10-03 07:45:52.03 spid7s
2010-10-03 07:45:52.03 spid7s Creating procedure sp_get_chunked_jobstep_params...
2010-10-03 07:45:52.04 spid7s
2010-10-03 07:45:52.04 spid7s Creating procedure sp_check_for_owned_jobs...
2010-10-03 07:45:52.04 spid7s
2010-10-03 07:45:52.04 spid7s Creating procedure sp_check_for_owned_jobsteps...
2010-10-03 07:45:52.05 spid7s
2010-10-03 07:45:52.05 spid7s Creating procedure sp_sqlagent_refresh_job...
2010-10-03 07:45:52.06 spid7s
2010-10-03 07:45:52.06 spid7s Creating procedure sp_jobhistory_row_limiter...
2010-10-03 07:45:52.06 spid7s
2010-10-03 07:45:52.06 spid7s Creating procedure sp_sqlagent_log_jobhistory...
2010-10-03 07:45:52.07 spid7s
2010-10-03 07:45:52.07 spid7s Creating procedure sp_sqlagent_check_msx_version...
2010-10-03 07:45:52.08 spid7s
2010-10-03 07:45:52.08 spid7s Creating procedure sp_sqlagent_probe_msx...
2010-10-03 07:45:52.09 spid7s
2010-10-03 07:45:52.09 spid7s Creating procedure sp_set_local_time...
2010-10-03 07:45:52.10 spid7s
2010-10-03 07:45:52.10 spid7s Creating procedure sp_multi_server_job_summary...
2010-10-03 07:45:52.11 spid7s
2010-10-03 07:45:52.11 spid7s Creating procedure sp_target_server_summary...
2010-10-03 07:45:52.14 spid7s
2010-10-03 07:45:52.14 spid7s Creating [legacy] procedure sp_uniquetaskname...
2010-10-03 07:45:52.15 spid7s
2010-10-03 07:45:52.15 spid7s Creating [legacy] procedure sp_addtask...
2010-10-03 07:45:52.19 spid7s
2010-10-03 07:45:52.19 spid7s Creating [legacy] procedure sp_droptask...
2010-10-03 07:45:52.25 spid7s
2010-10-03 07:45:52.25 spid7s Creating trigger trig_targetserver_insert...
2010-10-03 07:45:52.27 spid7s
2010-10-03 07:45:52.27 spid7s Creating procedure sp_add_alert_internal...
2010-10-03 07:45:52.28 spid7s
2010-10-03 07:45:52.28 spid7s Creating procedure sp_add_alert...
2010-10-03 07:45:52.30 spid7s
2010-10-03 07:45:52.30 spid7s Creating procedure sp_delete_alert...
2010-10-03 07:45:52.31 spid7s
2010-10-03 07:45:52.31 spid7s Creating procedure sp_help_alert...
2010-10-03 07:45:52.32 spid7s
2010-10-03 07:45:52.32 spid7s Creating procedure sp_verify_operator...
2010-10-03 07:45:52.32 spid7s
2010-10-03 07:45:52.32 spid7s Creating procedure sp_add_operator...
2010-10-03 07:45:52.33 spid7s
2010-10-03 07:45:52.33 spid7s Creating procedure sp_update_operator...
2010-10-03 07:45:52.34 spid7s
2010-10-03 07:45:52.34 spid7s Creating procedure sp_help_operator...
2010-10-03 07:45:52.36 spid7s
2010-10-03 07:45:52.36 spid7s Creating procedure sp_help_operator_jobs...
2010-10-03 07:45:52.37 spid7s
2010-10-03 07:45:52.37 spid7s Creating procedure sp_verify_operator_identifiers...
2010-10-03 07:45:52.37 spid7s
2010-10-03 07:45:52.37 spid7s Creating procedure sp_notify_operator...
2010-10-03 07:45:52.38 spid7s
2010-10-03 07:45:52.38 spid7s Creating procedure sp_verify_notification...
2010-10-03 07:45:52.38 spid7s
2010-10-03 07:45:52.38 spid7s Creating procedure sp_add_notification...
2010-10-03 07:45:52.39 spid7s
2010-10-03 07:45:52.39 spid7s Creating procedure sp_update_notification...
2010-10-03 07:45:52.40 spid7s
2010-10-03 07:45:52.40 spid7s Creating procedure sp_delete_notification...
2010-10-03 07:45:52.41 spid7s
2010-10-03 07:45:52.41 spid7s Creating procedure sp_help_notification...
2010-10-03 07:45:52.42 spid7s
2010-10-03 07:45:52.42 spid7s Creating procedure sp_help_jobactivity...
2010-10-03 07:45:52.43 spid7s
2010-10-03 07:45:52.43 spid7s Creating trigger trig_notification_ins_or_upd...
2010-10-03 07:45:52.44 spid7s
2010-10-03 07:45:52.44 spid7s Creating trigger trig_notification_delete...
2010-10-03 07:45:52.65 spid7s
2010-10-03 07:45:52.65 spid7s Setting object permissions...
2010-10-03 07:45:52.87 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.87 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.88 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.88 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.88 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.88 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.88 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.88 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.88 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.88 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.88 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.89 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.90 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.90 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.90 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.90 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.90 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:52.94 spid7s
2010-10-03 07:45:52.94 spid7s Creating procedure sp_get_dtsversion...
2010-10-03 07:45:52.95 spid7s
2010-10-03 07:45:52.95 spid7s Creating procedure sp_make_dtspackagename...
2010-10-03 07:45:52.95 spid7s
2010-10-03 07:45:52.95 spid7s Creating procedure sp_add_dtspackage...
2010-10-03 07:45:52.97 spid7s
2010-10-03 07:45:52.97 spid7s Creating procedure sp_drop_dtspackage...
2010-10-03 07:45:52.97 spid7s
2010-10-03 07:45:52.97 spid7s Creating procedure sp_reassign_dtspackageowner...
2010-10-03 07:45:52.98 spid7s
2010-10-03 07:45:52.98 spid7s Creating procedure sp_get_dtspackage...
2010-10-03 07:45:52.98 spid7s
2010-10-03 07:45:52.98 spid7s Creating procedure sp_reassign_dtspackagecategory...
2010-10-03 07:45:52.98 spid7s
2010-10-03 07:45:52.98 spid7s Creating procedure sp_enum_dtspackages...
2010-10-03 07:45:52.99 spid7s
2010-10-03 07:45:52.99 spid7s Creating procedure sp_add_dtscategory...
2010-10-03 07:45:52.99 spid7s
2010-10-03 07:45:52.99 spid7s Creating procedure sp_drop_dtscategory...
2010-10-03 07:45:53.00 spid7s
2010-10-03 07:45:53.00 spid7s Creating procedure sp_modify_dtscategory...
2010-10-03 07:45:53.00 spid7s
2010-10-03 07:45:53.00 spid7s Creating procedure sp_enum_dtscategories...
2010-10-03 07:45:53.01 spid7s
2010-10-03 07:45:53.01 spid7s Creating procedure sp_log_dtspackage_begin...
2010-10-03 07:45:53.01 spid7s
2010-10-03 07:45:53.01 spid7s Creating procedure sp_log_dtspackage_end...
2010-10-03 07:45:53.04 spid7s
2010-10-03 07:45:53.04 spid7s Creating procedure sp_log_dtsstep_begin...
2010-10-03 07:45:53.04 spid7s
2010-10-03 07:45:53.04 spid7s Creating procedure sp_log_dtsstep_end...
2010-10-03 07:45:53.05 spid7s
2010-10-03 07:45:53.05 spid7s Creating procedure sp_log_dtstask...
2010-10-03 07:45:53.05 spid7s
2010-10-03 07:45:53.05 spid7s Creating procedure sp_enum_dtspackagelog...
2010-10-03 07:45:53.05 spid7s
2010-10-03 07:45:53.05 spid7s Creating procedure sp_enum_dtssteplog...
2010-10-03 07:45:53.06 spid7s
2010-10-03 07:45:53.06 spid7s Creating procedure sp_enum_dtstasklog...
2010-10-03 07:45:53.06 spid7s
2010-10-03 07:45:53.06 spid7s Creating procedure sp_dump_dtslog_all...
2010-10-03 07:45:53.06 spid7s
2010-10-03 07:45:53.06 spid7s Creating procedure sp_dump_dtspackagelog...
2010-10-03 07:45:53.07 spid7s
2010-10-03 07:45:53.07 spid7s Creating procedure sp_dump_dtssteplog...
2010-10-03 07:45:53.07 spid7s
2010-10-03 07:45:53.07 spid7s Creating procedure sp_dump_dtstasklog...
2010-10-03 07:45:53.08 spid7s
2010-10-03 07:45:53.08 spid7s Creating procedure sp_dts_secure ...
2010-10-03 07:45:53.16 spid7s
2010-10-03 07:45:53.16 spid7s Creating view sysmail_allitems...
2010-10-03 07:45:53.18 spid7s
2010-10-03 07:45:53.18 spid7s Creating view sysmail_sentitems...
2010-10-03 07:45:53.20 spid7s
2010-10-03 07:45:53.20 spid7s Creating view sysmail_unsentitems...
2010-10-03 07:45:53.23 spid7s
2010-10-03 07:45:53.23 spid7s Creating view sysmail_faileditems...
2010-10-03 07:45:53.24 spid7s Creating sysmail_delete_mailitems_sp
2010-10-03 07:45:53.27 spid7s
2010-10-03 07:45:53.27 spid7s Creating view sysmail_mailattachments...
2010-10-03 07:45:53.33 spid7s
2010-10-03 07:45:53.33 spid7s Creating view sysmail_event_log...
2010-10-03 07:45:53.34 spid7s Creating sysmail_delete_log_sp
2010-10-03 07:45:53.35 spid7s
2010-10-03 07:45:53.35 spid7s Creating trigger trig_sysmail_profile...
2010-10-03 07:45:53.39 spid7s
2010-10-03 07:45:53.39 spid7s Creating trigger trig_principalprofile...
2010-10-03 07:45:53.41 spid7s
2010-10-03 07:45:53.41 spid7s Creating trigger trig_sysmail_account...
2010-10-03 07:45:53.41 spid7s
2010-10-03 07:45:53.41 spid7s Creating trigger trig_sysmail_profileaccount...
2010-10-03 07:45:53.42 spid7s
2010-10-03 07:45:53.42 spid7s Creating trigger trig_sysmail_profile_delete...
2010-10-03 07:45:53.43 spid7s
2010-10-03 07:45:53.43 spid7s Creating trigger trig_sysmail_servertype...
2010-10-03 07:45:53.44 spid7s
2010-10-03 07:45:53.44 spid7s Creating trigger trig_sysmail_server...
2010-10-03 07:45:53.45 spid7s
2010-10-03 07:45:53.45 spid7s Creating trigger trig_sysmail_configuration...
2010-10-03 07:45:53.45 spid7s
2010-10-03 07:45:53.45 spid7s Creating procedure sysmail_verify_accountparams_sp...
2010-10-03 07:45:53.46 spid7s
2010-10-03 07:45:53.46 spid7s Creating procedure sysmail_verify_principal_sp...
2010-10-03 07:45:53.46 spid7s
2010-10-03 07:45:53.46 spid7s Creating procedure sysmail_verify_profile_sp...
2010-10-03 07:45:53.46 spid7s
2010-10-03 07:45:53.46 spid7s Creating procedure sysmail_verify_account_sp...
2010-10-03 07:45:53.46 spid7s
2010-10-03 07:45:53.46 spid7s Creating procedure sysmail_add_profile_sp...
2010-10-03 07:45:53.47 spid7s
2010-10-03 07:45:53.47 spid7s Creating procedure sysmail_update_profile_sp...
2010-10-03 07:45:53.47 spid7s
2010-10-03 07:45:53.47 spid7s Creating procedure sysmail_delete_profile_sp...
2010-10-03 07:45:53.47 spid7s
2010-10-03 07:45:53.47 spid7s Creating procedure sysmail_help_profile_sp...
2010-10-03 07:45:53.48 spid7s
2010-10-03 07:45:53.48 spid7s Creating procedure sysmail_create_user_credential_sp...
2010-10-03 07:45:53.48 spid7s
2010-10-03 07:45:53.48 spid7s Creating procedure sysmail_alter_user_credential_sp...
2010-10-03 07:45:53.48 spid7s
2010-10-03 07:45:53.48 spid7s Creating procedure sysmail_drop_user_credential_sp...
2010-10-03 07:45:53.48 spid7s
2010-10-03 07:45:53.48 spid7s Creating procedure sysmail_add_account_sp...
2010-10-03 07:45:53.49 spid7s
2010-10-03 07:45:53.49 spid7s Creating procedure sysmail_update_account_sp...
2010-10-03 07:45:53.49 spid7s
2010-10-03 07:45:53.49 spid7s Creating procedure sysmail_delete_account_sp...
2010-10-03 07:45:53.50 spid7s
2010-10-03 07:45:53.50 spid7s Creating procedure sysmail_help_account_sp...
2010-10-03 07:45:53.50 spid7s
2010-10-03 07:45:53.50 spid7s Creating procedure sysmail_help_admin_account_sp...
2010-10-03 07:45:53.50 spid7s
2010-10-03 07:45:53.50 spid7s Creating procedure sysmail_add_profileaccount_sp...
2010-10-03 07:45:53.51 spid7s
2010-10-03 07:45:53.51 spid7s Creating procedure sysmail_update_profileaccount_sp...
2010-10-03 07:45:53.51 spid7s
2010-10-03 07:45:53.51 spid7s Creating procedure sysmail_delete_profileaccount_sp...
2010-10-03 07:45:53.51 spid7s
2010-10-03 07:45:53.51 spid7s Creating procedure sysmail_help_profileaccount_sp...
2010-10-03 07:45:53.52 spid7s
2010-10-03 07:45:53.52 spid7s Creating procedure sysmail_configure_sp...
2010-10-03 07:45:53.52 spid7s
2010-10-03 07:45:53.52 spid7s Creating procedure sysmail_help_configure_sp...
2010-10-03 07:45:53.52 spid7s
2010-10-03 07:45:53.52 spid7s Creating procedure sysmail_help_configure_value_sp...
2010-10-03 07:45:53.52 spid7s
2010-10-03 07:45:53.52 spid7s Creating procedure sysmail_add_principalprofile_sp...
2010-10-03 07:45:53.53 spid7s
2010-10-03 07:45:53.53 spid7s Creating procedure sysmail_update_principalprofile_sp...
2010-10-03 07:45:53.53 spid7s
2010-10-03 07:45:53.53 spid7s Creating procedure sysmail_delete_principalprofile_sp...
2010-10-03 07:45:53.53 spid7s
2010-10-03 07:45:53.53 spid7s Creating procedure sysmail_help_principalprofile_sp...
2010-10-03 07:45:53.54 spid7s Creating sysmail_logmailevent_sp
2010-10-03 07:45:53.54 spid7s Creating sysmail_start_sp
2010-10-03 07:45:53.54 spid7s Creating sysmail_stop_sp
2010-10-03 07:45:53.54 spid7s Creating sysmail_help_status_sp
2010-10-03 07:45:53.55 spid7s Creating sysmail_help_queue_sp
2010-10-03 07:45:53.59 spid7s Creating sp_SendMailMessage
2010-10-03 07:45:53.59 spid7s Creating sp_isprohibited
2010-10-03 07:45:53.59 spid7s Creating sp_SendMailQueues
2010-10-03 07:45:53.60 spid7s Creating sp_ProcessResponse
2010-10-03 07:45:53.61 spid7s Creating sp_MailItemResultSets
2010-10-03 07:45:53.61 spid7s Creating sp_process_DialogTimer
2010-10-03 07:45:53.61 spid7s Creating sp_readrequest
2010-10-03 07:45:53.62 spid7s Creating sp_GetAttachmentData
2010-10-03 07:45:53.62 spid7s Creating sp_RunMailQuery
2010-10-03 07:45:53.67 spid7s Creating sp_send_dbmail
2010-10-03 07:45:53.68 spid7s Creating sp_ExternalMailQueueListener
2010-10-03 07:45:53.68 spid7s Creating sp_sysmail_activate
2010-10-03 07:45:53.74 spid7s
2010-10-03 07:45:53.74 spid7s Dropping Database Mail MESSAGES, CONTRACTS, QUEUES AND SERVICES...
2010-10-03 07:45:53.74 spid7s
2010-10-03 07:45:53.74 spid7s Dropping SERVICE InternalMailService
2010-10-03 07:45:53.81 spid7s Dropping SERVICE ExternalMailService
2010-10-03 07:45:53.81 spid7s Dropping QUEUE InternalMailQueue
2010-10-03 07:45:53.81 spid7s Dropping QUEUE ExternalMailQueue
2010-10-03 07:45:53.81 spid7s Dropping CONTRACT [//www.microsoft.com/databasemail/contracts/SendMail/v1.0]
2010-10-03 07:45:53.81 spid7s Dropping MESSAGE TYPE [{//www.microsoft.com/databasemail/messages}SendMail]
2010-10-03 07:45:53.81 spid7s Dropping MESSAGE TYPE [{//www.microsoft.com/databasemail/messages}SendMailStatus]
2010-10-03 07:45:53.82 spid7s
2010-10-03 07:45:53.82 spid7s Creating MESSAGES, CONTRACTS, QUEUES AND SERVICES...
2010-10-03 07:45:53.82 spid7s
2010-10-03 07:45:53.82 spid7s Creating MESSAGE TYPE [{//www.microsoft.com/databasemail/messages}SendMail]
2010-10-03 07:45:53.83 spid7s Creating CONTRACT [//www.microsoft.com/databasemail/contracts/SendMail/v1.0]
2010-10-03 07:45:53.84 spid7s Creating QUEUE InternalMailQueue
2010-10-03 07:45:53.84 spid7s Creating QUEUE ExternalMailQueue
2010-10-03 07:45:53.84 spid7s Creating SERVICE InternalMailService ON QUEUE InternalMailQueue
2010-10-03 07:45:53.84 spid7s Creating SERVICE ExternalMailService ON QUEUE ExternalMailQueue
2010-10-03 07:45:53.84 spid7s
2010-10-03 07:45:53.84 spid7s Creating procedure sp_maintplan_delete_log...
2010-10-03 07:45:53.87 spid7s
2010-10-03 07:45:53.87 spid7s Creating procedure sp_maintplan_delete_subplan...
2010-10-03 07:45:53.88 spid7s
2010-10-03 07:45:53.88 spid7s Creating procedure sp_maintplan_update_subplan_tsx...
2010-10-03 07:45:53.89 spid7s
2010-10-03 07:45:53.89 spid7s Creating procedure sp_maintplan_subplans_by_job...
2010-10-03 07:45:53.90 spid7s
2010-10-03 07:45:53.90 spid7s Creating procedure sp_maintplan_open_logentry...
2010-10-03 07:45:53.90 spid7s
2010-10-03 07:45:53.90 spid7s Creating procedure sp_maintplan_close_logentry...
2010-10-03 07:45:53.91 spid7s
2010-10-03 07:45:53.91 spid7s Creating procedure sp_maintplan_update_log...
2010-10-03 07:45:53.91 spid7s
2010-10-03 07:45:53.91 spid7s Creating procedure sp_maintplan_update_subplan...
2010-10-03 07:45:53.92 spid7s
2010-10-03 07:45:53.92 spid7s Creating procedure sp_maintplan_delete_plan...
2010-10-03 07:45:53.93 spid7s
2010-10-03 07:45:53.93 spid7s Creating procedure sp_maintplan_start...
2010-10-03 07:45:53.93 spid7s
2010-10-03 07:45:53.93 spid7s Creating procedure sp_get_script...
2010-10-03 07:45:54.27 spid7s
2010-10-03 07:45:54.28 spid7s No foreign keys reference table 'sysdbmaintplan_history', or you do not have permissions on referencing tables.
2010-10-03 07:45:54.29 spid7s
2010-10-03 07:45:54.29 spid7s Creating procedure sp_clear_dbmaintplan_by_db...
2010-10-03 07:45:54.30 spid7s
2010-10-03 07:45:54.30 spid7s Creating procedure sp_add_maintenance_plan...
2010-10-03 07:45:54.31 spid7s
2010-10-03 07:45:54.31 spid7s Creating procedure sp_delete_maintenance_plan...
2010-10-03 07:45:54.31 spid7s
2010-10-03 07:45:54.31 spid7s Creating procedure sp_add_maintenance_plan_db...
2010-10-03 07:45:54.32 spid7s
2010-10-03 07:45:54.32 spid7s Creating procedure sp_delete_maintenance_plan_db...
2010-10-03 07:45:54.32 spid7s
2010-10-03 07:45:54.32 spid7s Creating procedure sp_add_maintenance_plan_job...
2010-10-03 07:45:54.33 spid7s
2010-10-03 07:45:54.33 spid7s Creating procedure sp_delete_maintenance_plan_job...
2010-10-03 07:45:54.34 spid7s
2010-10-03 07:45:54.34 spid7s Creating procedure sp_help_maintenance_plan...
2010-10-03 07:45:54.34 spid7s
2010-10-03 07:45:54.34 spid7s Creating procedure sp_delete_database_backuphistory...
2010-10-03 07:45:54.35 spid7s
2010-10-03 07:45:54.35 spid7s Creating procedure sp_delete_backuphistory...
2010-10-03 07:45:54.41 spid7s
2010-10-03 07:45:54.41 spid7s Creating procedure sp_add_log_shipping_monitor_jobs...
2010-10-03 07:45:54.42 spid7s
2010-10-03 07:45:54.42 spid7s Creating procedure sp_add_log_shipping_primary...
2010-10-03 07:45:54.44 spid7s
2010-10-03 07:45:54.44 spid7s Creating procedure sp_add_log_shipping_secondary...
2010-10-03 07:45:54.45 spid7s
2010-10-03 07:45:54.45 spid7s Creating procedure sp_delete_log_shipping_monitor_jobs...
2010-10-03 07:45:54.45 spid7s
2010-10-03 07:45:54.45 spid7s Creating procedure sp_delete_log_shipping_primary...
2010-10-03 07:45:54.46 spid7s
2010-10-03 07:45:54.46 spid7s Creating sp_delete_log_shipping_secondary...
2010-10-03 07:45:54.47 spid7s
2010-10-03 07:45:54.47 spid7s Creating procedure sp_log_shipping_in_sync...
2010-10-03 07:45:54.47 spid7s
2010-10-03 07:45:54.47 spid7s Creating procedure sp_log_shipping_get_date_from_file...
2010-10-03 07:45:54.49 spid7s
2010-10-03 07:45:54.49 spid7s Creating procedure sp_get_log_shipping_monitor_info...
2010-10-03 07:45:54.51 spid7s
2010-10-03 07:45:54.51 spid7s Creating procedure sp_update_log_shipping_monitor_info...
2010-10-03 07:45:54.52 spid7s
2010-10-03 07:45:54.52 spid7s Creating procedure sp_delete_log_shipping_monitor_info...
2010-10-03 07:45:54.53 spid7s
2010-10-03 07:45:54.53 spid7s Creating procedure sp_remove_log_shipping_monitor_account...
2010-10-03 07:45:54.56 spid7s
2010-10-03 07:45:54.56 spid7s Creating procedure sp_log_shipping_monitor_backup...
2010-10-03 07:45:54.56 spid7s
2010-10-03 07:45:54.56 spid7s Creating procedure sp_log_shipping_monitor_restore...
2010-10-03 07:45:54.57 spid7s
2010-10-03 07:45:54.57 spid7s Creating procedure sp_change_monitor_role...
2010-10-03 07:45:54.58 spid7s
2010-10-03 07:45:54.58 spid7s Creating procedure sp_create_log_shipping_monitor_account...
2010-10-03 07:45:54.63 spid7s
2010-10-03 07:45:54.63 spid7s Creating view sysmaintplan_plans...
2010-10-03 07:45:54.77 spid7s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
2010-10-03 07:45:54.81 spid7s
2010-10-03 07:45:54.81 spid7s Create dc_operator role...
2010-10-03 07:45:54.82 spid7s
2010-10-03 07:45:54.82 spid7s Create dc_admin role...
2010-10-03 07:45:54.83 spid7s
2010-10-03 07:45:54.83 spid7s Create dc_proxy role...
2010-10-03 07:45:54.84 spid7s
2010-10-03 07:45:54.84 spid7s Create loginless user that has ownership of data collector agent-related securables...
2010-10-03 07:45:54.84 spid7s Dropping view [dbo].[syscollector_config_store]...
2010-10-03 07:45:54.85 spid7s Creating view [dbo].[syscollector_config_store]...
2010-10-03 07:45:54.85 spid7s Dropping procedure [dbo].[sp_syscollector_verify_collector_state]...
2010-10-03 07:45:54.85 spid7s Creating procedure [dbo].[sp_syscollector_verify_collector_state]...
2010-10-03 07:45:54.86 spid7s
2010-10-03 07:45:54.86 spid7s Creating procedure [dbo].[sp_syscollector_set_warehouse_instance_name]...
2010-10-03 07:45:54.86 spid7s
2010-10-03 07:45:54.86 spid7s Creating procedure [dbo].[sp_syscollector_set_warehouse_database_name]...
2010-10-03 07:45:54.86 spid7s
2010-10-03 07:45:54.86 spid7s Creating procedure [dbo].[sp_syscollector_set_cache_directory]...
2010-10-03 07:45:54.86 spid7s
2010-10-03 07:45:54.86 spid7s Creating procedure [dbo].[sp_syscollector_set_cache_window]...
2010-10-03 07:45:54.88 spid7s
2010-10-03 07:45:54.88 spid7s Creating procedure [dbo].[sp_syscollector_get_warehouse_connection_string]...
2010-10-03 07:45:54.88 spid7s
2010-10-03 07:45:54.88 spid7s Creating function [dbo].[fn_syscollector_highest_incompatible_mdw_version]...
2010-10-03 07:45:54.91 spid7s Dropping view [dbo].[syscollector_collection_sets]...
2010-10-03 07:45:54.91 spid7s Creating view [dbo].[syscollector_collection_sets]...
2010-10-03 07:45:54.91 spid7s Dropping procedure [dbo].[sp_syscollector_verify_collection_set]...
2010-10-03 07:45:54.91 spid7s Creating procedure [dbo].[sp_syscollector_verify_collection_set]...
2010-10-03 07:45:54.92 spid7s Dropping procedure [dbo].[sp_syscollector_create_jobs]...
2010-10-03 07:45:54.93 spid7s Creating procedure [dbo].[sp_syscollector_create_jobs]...
2010-10-03 07:45:54.93 spid7s Dropping procedure [dbo].[sp_syscollector_create_collection_set]...
2010-10-03 07:45:54.93 spid7s Creating procedure [dbo].[sp_syscollector_create_collection_set]...
2010-10-03 07:45:54.93 spid7s Dropping procedure [dbo].[sp_syscollector_update_job_proxy]...
2010-10-03 07:45:54.93 spid7s Creating procedure [dbo].[sp_syscollector_update_job_proxy]...
2010-10-03 07:45:54.96 spid7s Dropping procedure [dbo].[sp_syscollector_update_collection_set_internal]...
2010-10-03 07:45:54.96 spid7s Creating procedure [dbo].[sp_syscollector_update_collection_set_internal]...
2010-10-03 07:45:54.96 spid7s Dropping procedure [dbo].[sp_syscollector_update_collection_set]...
2010-10-03 07:45:54.96 spid7s Creating procedure [dbo].[sp_syscollector_update_collection_set]...
2010-10-03 07:45:54.97 spid7s
2010-10-03 07:45:54.97 spid7s Creating procedure [dbo].[sp_syscollector_configure_sql_dumper]...
2010-10-03 07:45:54.97 spid7s Dropping function [dbo].[fn_syscollector_get_package_path]...
2010-10-03 07:45:54.97 spid7s Creating function [dbo].[fn_syscollector_get_package_path]...
2010-10-03 07:45:54.97 spid7s Dropping view [dbo].[syscollector_collector_types]...
2010-10-03 07:45:54.97 spid7s Creating view [dbo].[syscollector_collector_types]...
2010-10-03 07:45:54.99 spid7s Dropping procedure [dbo].[sp_syscollector_verify_collector_type]...
2010-10-03 07:45:54.99 spid7s Creating procedure [dbo].[sp_syscollector_verify_collector_type]...
2010-10-03 07:45:54.99 spid7s Dropping procedure [dbo].[sp_syscollector_create_collector_type]...
2010-10-03 07:45:54.99 spid7s Creating procedure [dbo].[sp_syscollector_create_collector_type]...
2010-10-03 07:45:54.99 spid7s Dropping procedure [dbo].[sp_syscollector_update_collector_type]...
2010-10-03 07:45:55.00 spid7s Creating procedure [dbo].[sp_syscollector_update_collector_type]...
2010-10-03 07:45:55.00 spid7s Dropping procedure [dbo].[sp_syscollector_validate_xml]...
2010-10-03 07:45:55.00 spid7s Creating procedure [dbo].[sp_syscollector_validate_xml]...
2010-10-03 07:45:55.01 spid7s Dropping view [dbo].[syscollector_collection_items]...
2010-10-03 07:45:55.01 spid7s Creating view [dbo].[syscollector_collection_items]...
2010-10-03 07:45:55.01 spid7s Dropping procedure [dbo].[sp_syscollector_delete_collector_type]...
2010-10-03 07:45:55.01 spid7s Creating procedure [dbo].[sp_syscollector_delete_collector_type]...
2010-10-03 07:45:55.01 spid7s Dropping procedure [dbo].[sp_syscollector_verify_collection_item]...
2010-10-03 07:45:55.01 spid7s Creating procedure [dbo].[sp_syscollector_verify_collection_item]...
2010-10-03 07:45:55.01 spid7s Dropping procedure [dbo].[sp_syscollector_create_collection_item]...
2010-10-03 07:45:55.01 spid7s Creating procedure [dbo].[sp_syscollector_create_collection_item]...
2010-10-03 07:45:55.02 spid7s Dropping procedure [dbo].[sp_syscollector_update_collection_item_internal]...
2010-10-03 07:45:55.02 spid7s Creating procedure [dbo].[sp_syscollector_update_collection_item_internal]...
2010-10-03 07:45:55.02 spid7s Dropping procedure [dbo].[sp_syscollector_update_collection_item]...
2010-10-03 07:45:55.02 spid7s Creating procedure [dbo].[sp_syscollector_update_collection_item]...
2010-10-03 07:45:55.02 spid7s Dropping procedure [dbo].[sp_syscollector_delete_collection_item_internal]...
2010-10-03 07:45:55.03 spid7s Creating procedure [dbo].[sp_syscollector_delete_collection_item_internal]...
2010-10-03 07:45:55.03 spid7s Dropping procedure [dbo].[sp_syscollector_delete_collection_item]...
2010-10-03 07:45:55.03 spid7s Creating procedure [dbo].[sp_syscollector_delete_collection_item]...
2010-10-03 07:45:55.03 spid7s Dropping procedure [dbo].[sp_syscollector_start_collection_set]...
2010-10-03 07:45:55.03 spid7s
2010-10-03 07:45:55.03 spid7s Creating procedure [dbo].[sp_syscollector_start_collection_set]...
2010-10-03 07:45:55.03 spid7s Dropping procedure [dbo].[sp_syscollector_stop_collection_set]...
2010-10-03 07:45:55.04 spid7s
2010-10-03 07:45:55.04 spid7s Creating procedure [dbo].[sp_syscollector_stop_collection_set]...
2010-10-03 07:45:55.04 spid7s Dropping procedure [dbo].[sp_syscollector_get_collection_set_execution_status]...
2010-10-03 07:45:55.04 spid7s Creating procedure [dbo].[sp_syscollector_get_collection_set_execution_status]...
2010-10-03 07:45:55.05 spid7s
2010-10-03 07:45:55.05 spid7s Creating procedure [dbo].[sp_syscollector_upload_collection_set]...
2010-10-03 07:45:55.05 spid7s
2010-10-03 07:45:55.05 spid7s Creating procedure [dbo].[sp_syscollector_run_collection_set]...
2010-10-03 07:45:55.06 spid7s Creating trigger [dbo].[syscollector_collection_set_is_running_update_trigger] on [dbo].[syscollector_collection_sets_internal]
2010-10-03 07:45:55.06 spid7s
2010-10-03 07:45:55.06 spid7s Creating stored procedure syscollector_stop_collection_set_jobs...
2010-10-03 07:45:55.06 spid7s
2010-10-03 07:45:55.06 spid7s Creating stored procedure syscollector_start_collection_set_jobs...
2010-10-03 07:45:55.07 spid7s
2010-10-03 07:45:55.07 spid7s Creating view syscollector_execution_log...
2010-10-03 07:45:55.07 spid7s Dropping procedure [dbo].[sp_syscollector_delete_jobs]...
2010-10-03 07:45:55.07 spid7s Creating procedure [dbo].[sp_syscollector_delete_jobs]...
2010-10-03 07:45:55.07 spid7s
2010-10-03 07:45:55.07 spid7s Creating view syscollector_execution_stats...
2010-10-03 07:45:55.07 spid7s
2010-10-03 07:45:55.07 spid7s Creating stored procedure sp_syscollector_verify_event_log_id...
2010-10-03 07:45:55.08 spid7s
2010-10-03 07:45:55.08 spid7s Creating stored procedure sp_syscollector_event_oncollectionstart...
2010-10-03 07:45:55.08 spid7s
2010-10-03 07:45:55.08 spid7s Creating stored procedure sp_syscollector_event_oncollectionstop...
2010-10-03 07:45:55.08 spid7s
2010-10-03 07:45:55.08 spid7s Creating stored procedure sp_syscollector_event_oncollectionbegin...
2010-10-03 07:45:55.09 spid7s
2010-10-03 07:45:55.09 spid7s Creating stored procedure sp_syscollector_event_oncollectionend...
2010-10-03 07:45:55.09 spid7s
2010-10-03 07:45:55.09 spid7s Creating stored procedure sp_syscollector_event_onpackagebegin...
2010-10-03 07:45:55.09 spid7s
2010-10-03 07:45:55.09 spid7s Creating stored procedure sp_syscollector_event_onpackageend...
2010-10-03 07:45:55.10 spid7s
2010-10-03 07:45:55.10 spid7s Creating stored procedure sp_syscollector_event_onpackageupdate...
2010-10-03 07:45:55.10 spid7s
2010-10-03 07:45:55.10 spid7s Creating stored procedure sp_syscollector_event_onerror...
2010-10-03 07:45:55.10 spid7s
2010-10-03 07:45:55.10 spid7s Creating stored procedure sp_syscollector_event_onstatsupdate...
2010-10-03 07:45:55.11 spid7s
2010-10-03 07:45:55.11 spid7s Creating function [dbo].[fn_syscollector_find_collection_set_root] ...
2010-10-03 07:45:55.11 spid7s
2010-10-03 07:45:55.11 spid7s Creating function [dbo].[fn_syscollector_get_execution_log_tree] ...
2010-10-03 07:45:55.11 spid7s
2010-10-03 07:45:55.11 spid7s Creating function [dbo].[fn_syscollector_get_execution_stats] ...
2010-10-03 07:45:55.11 spid7s
2010-10-03 07:45:55.11 spid7s Creating function [dbo].[fn_syscollector_get_execution_details] ...
2010-10-03 07:45:55.12 spid7s
2010-10-03 07:45:55.12 spid7s Creating view syscollector_execution_log_full...
2010-10-03 07:45:55.12 spid7s
2010-10-03 07:45:55.12 spid7s Dropping procedure [dbo].[sp_syscollector_delete_execution_log_tree] ...
2010-10-03 07:45:55.12 spid7s Creating procedure [dbo].[sp_syscollector_delete_execution_log_tree] ...
2010-10-03 07:45:55.13 spid7s Dropping procedure [dbo].[sp_syscollector_delete_collection_set_internal]...
2010-10-03 07:45:55.13 spid7s Creating procedure [dbo].[sp_syscollector_delete_collection_set_internal]...
2010-10-03 07:45:55.14 spid7s Dropping procedure [dbo].[sp_syscollector_delete_collection_set]...
2010-10-03 07:45:55.14 spid7s Creating procedure [dbo].[sp_syscollector_delete_collection_set]...
2010-10-03 07:45:55.14 spid7s
2010-10-03 07:45:55.14 spid7s Dropping stored procedure sp_syscollector_purge_collection_logs...
2010-10-03 07:45:55.14 spid7s
2010-10-03 07:45:55.14 spid7s Creating stored procedure sp_syscollector_purge_collection_logs...
2010-10-03 07:45:55.14 spid7s Dropping procedure [dbo].[sp_syscollector_enable_collector]...
2010-10-03 07:45:55.14 spid7s Creating procedure [dbo].[sp_syscollector_enable_collector]...
2010-10-03 07:45:55.14 spid7s Dropping procedure [dbo].[sp_syscollector_disable_collector]...
2010-10-03 07:45:55.15 spid7s Creating procedure [dbo].[sp_syscollector_disable_collector]...
2010-10-03 07:45:55.15 spid7s Dropping procedure [dbo].[sp_syscollector_get_trace_info]
2010-10-03 07:45:55.15 spid7s Creating procedure [dbo].[sp_syscollector_get_trace_info]...
2010-10-03 07:45:55.17 spid7s Dropping procedure [dbo].[sp_syscollector_text_query_plan_lookpup]
2010-10-03 07:45:55.17 spid7s Creating procedure [dbo].[sp_syscollector_text_query_plan_lookpup]...
2010-10-03 07:45:55.17 spid7s Dropping procedure [dbo].[sp_syscollector_sql_text_lookup]
2010-10-03 07:45:55.17 spid7s Creating procedure [dbo].[sp_syscollector_sql_text_lookup]...
2010-10-03 07:45:55.18 spid7s Installing out of the box Collector objects
2010-10-03 07:45:55.18 spid7s
2010-10-03 07:45:55.21 spid7s Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2010-10-03 07:45:55.21 spid7s Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2010-10-03 07:45:55.21 spid7s FILESTREAM: effective level = 3, configured level = 3, file system access share name = 'PRO'.
2010-10-03 07:45:55.21 spid7s Configuration option 'Agent XPs' changed from 1 to 1. Run the RECONFIGURE statement to install.
2010-10-03 07:45:55.21 spid7s Configuration option 'Agent XPs' changed from 1 to 1. Run the RECONFIGURE statement to install.
2010-10-03 07:45:55.21 spid7s FILESTREAM: effective level = 3, configured level = 3, file system access share name = 'PRO'.
2010-10-03 07:45:55.25 spid7s Creating SSIS folders...
2010-10-03 07:45:55.25 spid7s Dropping procedure [dbo].[sp_syscollector_get_instmdw]
2010-10-03 07:45:55.25 spid7s Creating procedure [dbo].[sp_syscollector_get_instmdw]...
2010-10-03 07:45:55.25 spid7s Dropping procedure [dbo].[sp_syscollector_upload_instmdw]
2010-10-03 07:45:55.25 spid7s Creating procedure [dbo].[sp_syscollector_upload_instmdw]...
2010-10-03 07:45:55.27 spid7s Uploading data collector package from disk: E:\Program Files\Microsoft SQL Server\MSSQL10.PRO\MSSQL\Install\SqlTraceCollect.dtsx
2010-10-03 07:45:55.27 spid7s Uploading data collector package from disk: E:\Program Files\Microsoft SQL Server\MSSQL10.PRO\MSSQL\Install\SqlTraceCollect.dtsx
2010-10-03 07:45:55.33 spid7s Error: 8649, Severity: 17, State: 1.
2010-10-03 07:45:55.33 spid7s The query has been canceled because the estimated cost of this query (37) exceeds the configured threshold of 30. Contact the system administrator.
2010-10-03 07:45:55.38 spid7s Error: 912, Severity: 21, State: 2.
2010-10-03 07:45:55.38 spid7s Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 8649, state 1, severity 17. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
2010-10-03 07:45:55.40 spid7s Error: 3417, Severity: 21, State: 3.
2010-10-03 07:45:55.40 spid7s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
2010-10-03 07:45:55.94 spid7s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 10/03/2010 :  04:19:52  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
quote:
Originally posted by mikebird


2010-10-03 07:45:55.40 spid7s Error: 3417, Severity: 21, State: 3.
2010-10-03 07:45:55.40 spid7s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.


Looks like reinstall time, unless you have a backup of master lying around.

What upgrade were you doing here?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 10/05/2010 :  04:45:27  Show Profile  Reply with Quote
Thanks! My idea was to install this over again. The system seems unrecoverable. Having done this at the weekend with the Mac Pro machine, and that fixed it all. I was hoping the DBs would be kept, and they were. ALL Reporting Services & Report Manager all up and going again.

My R2 is something I tried on each machine, as well as 2008 SP2? I'd rather never go there again. It seemed to be the root cause of all evil. Even the logs say nothing of use.
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 10/05/2010 :  05:53:07  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Hang on, what's that about R2 and 2008 SP2?


--
Gail Shaw
SQL Server MVP
Go to Top of Page

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 10/15/2010 :  16:46:39  Show Profile  Reply with Quote
They both cause errors. As do Microsoft... By default
Go to Top of Page

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 10/15/2010 :  16:57:54  Show Profile  Reply with Quote
I thought it would be valid to take a database offline, for some maintenance, or prevent access, temporarily. This was the beginning of all collapse. Seriously - if you park your car to Jack it up and replace the flat tyre, is that the last time you'll ever get the engine started again? I'm lucky this was my test system, to play with. That fills me with a feeling of reliability.
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 10/15/2010 :  18:39:07  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Perfectly valid. Take a DB offline and it's no longer available for anything, including maintenance. I've done it hundreds of times on all versions of SQL, no problems. I think there's more going on here. I can't work out from your posts what exactly you did.

You didn't answer my question about what you meant around 2008 and 2008 R2. If you just want to bash MS and blame them for everything, let me know so I can stop reading this thread.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 1.92 seconds. Powered By: Snitz Forums 2000