In SQL 2008 You have now Auditing.

Create a Database Specific Audit on [msdb] and track this.

[Audit Action Type] = Execute

[Object Name] = [dbo].[sp_delete_job]; [dbo].[sp_delete_jobstep]; [dbo].[sp_delete_jobsteplog]

[Principal Name] = [public]

This will catch...

Create linked servers to each of your instances and run the following code on them:

Here is the Status column description:

1 = autoclose; set with ALTER DATABASE.

4...

You don't need to make it that complicated.

Just use this:

Now.ToString("yyyyMmdd_HHmmss")

you can run this query and filter on the job_id

SELECT * FROM dbo.sysjobsteps

Antivirus is probably blocking you from sending emails.

Talk to your Security Admin and Exchange Admin.

If you have setup the Mail Client correctly, then you are probably being blocked by Exchange,...

The is no one single way of determining when SSIS will perform better than a Stored Procedure.

But you must take this into cosideration:

1) When you make operational changes within a...

You should try to use an AD account at all cost.

I find it more secure because it's password policies are managed by AD.

Try not to use "sa" on any connection...

This script should work just fine:

You may want to modify it a little so it first checks if the user exists:

drop Login [login_name]

go

sp_msforeachDB 'Use [?]; DROP USER [user_name];'

Yes this is completely possible on SQL 2005 and newer:

To limit visibility to database metadata, execute this code DENY VIEW ANY DATABASE TO [MySQLLogingUser]. After this permission is denied, a...

Use this code:

SELECT l.name as grantee_name, p.state_desc, p.permission_name

FROM sys.server_permissions AS p JOIN sys.server_principals AS l

ON p.grantee_principal_id = l.principal_id

WHERE permission_name = 'VIEW ANY DEFINITION' ;

GO

GRANT VIEW DEFINITION

Check this link:

A DBA Should be local admin because of the many administrative tasks that need to be performed on the Server itself.

A DBA needs to be able to:

Secure the Windows Server

Configure...

Yes,

Every time that SQL registers an error with the with severity 22, which is a fatal error, then the alert is fired.

In order for you recieve and email when that...

You get that error when you are installing SQL on another node.

At the time of installation, SQL is not available for any user to connect.

Once the installation finishes, SQL is...

Your Query contains the correct syntax, I don't see a logical reason why it is not returning your record.

I am going to make some assumptions here:

Assuming that you have created...