Here is a link to a script on this site that will do this, however if you are backing of the msdb database than all this information is stored within...

Probably the easiest was is to use the copy database function which will create a package that can be re-run later.  Right click the database, Tasks, Copy Database.

Here's a link to a really good article on this site that details everything you need to do:

http://www.sqlservercentral.com/columnists/glarsen/migratingloginstoanotherserver.asp

I tried to simulate your issue, however when I start the server again the database is listed suspect and I can simply detach and re-attach the database and I'm given...

I'm not sure how to do this through the GUI, but here is a copy of the script I used previously to add an alert for constraint violations:

EXECUTE msdb.dbo.sp_add_alert @name...

In the past I have used a couple of methods.  One would be to implement transaction log backups and then use one of the many tools out there to scrape...

Here's a link to a script that I use to generate the restore commands I need. It's much faster than using the GUI.

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1505

In this case it may be best to GUID's for the primary keys.  You can generate these and assign them to a variable for inserting into a table by using...

In the past when building a Server Inventory list I used the following:

SELECT SUBSTRING(@@VERSION,1,CHARINDEX('(',@@VERSION,1)-1)

For the xp_cmdshell you could simply grant them excute rights to the xp_cmdsheel stored procedure in the master database.  In terms of killing proccesses, if you add the user to...

Try using the COALESCE function.  What it does is tests for the first non null value.  You can check for details in BOL but here's and example:

SELECT EMP_NUM, EMP_DESCRIPTION

FROM EMP

WHERE...

Not sure if this is what you mean, but you can try this:

SELECT TOP 1 REF_NO

FROM  REF

ORDER BY SUBSTRING(REF_NO,CHARINDEX('-',REF_NO),99) DESC

Thanks for the code example and the advice on the logic handling.  That did the trick in terms of fixing my problem and I think I will be ok in...

Here is an example:

IF EXISTS  (

   SELECT * FROM some_table WHERE value LIKE value  &nbsp

BEGIN

EXEC master..xp_sendmail @recipients = 'email_address',

    @message = 'email message',

    @copy_recipients = 'other_email',

    @subject = 'Subject Title'

END

GO

One way I have done this is to check the status of the server by issueing a command like:

xp_cmdshell 'sc \\yourservername query mssqlserver'

You could then input the results into...