Yeah! Great!

Catch is Ryan Naraine at eWeek (ref article) is that you need Windows XP...

Just for grins read the SQL Mail thread. They don't want to give developers any access.

My company has 3-5 developers at any given time and I'm the only DBA....

Okay.....this isn't as horrible as it looks...probably.

First off...

1. Make sure you have a lot of disk space free.

2. Are the disks on a...

When you added the device before were you in the database you want to restore to?

Go to that database adn run "sp_helpdevice". If the "Full_Bak" is there do the sp_dropdevice....

Are you in the master database?

Go into the enterprise manager and -> Management -> Current Activity -> Process Info and look for any users of the database. Terminate their...

You need to be in the master database, not the one you are restoring. Also, no one else can be in that database.

Before actually starting the restore run the following...

It Would be something like this:

sp_addumpdevice @devtype = 'DISK', 
@logicalname = 'Full_Bak',
@physicalname = 'E:\Backup_Dir\FileName.BAK'
GO
RESTORE DATABASE DBname
FROM Full_Bak
        WITH RECOVERY, REPLACE , STATS,
 ...

Welcome to the madhouse.

INSERT INTO table2 (firstname, lastname, email)
SELECT  firstname, lastname,  
       firstname + '.'...

The number of original hackers is a small percentage of the overall number of malware inventors. A large number are just script kiddies that piggy-back on the good hackers....

My suggestion: add a unique column on the table. Probably just add an identity column.

That way the select becomes

select * from sample_table where
id_col in (select id_col 
   ...

Hey what about Arena football. Not quite the same but it works in a pinch.

Do you have the "Auto Close" checked?

Do you have "Auto Shrink" checked?

Do you attempt to backup the mdf/ldf files?

Do you have a SQL Agent Backup?

This script will kill all users in every database. You can refine it by putting a where clause in the 'LoginCursor' declaration.

USE MASTER
GO
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE...

I have a a stored procedure, I've uploaded to the contribution center and is pending approval, that reads through the list of databases and stores the the data you want...

Simple answer: Yes.

The long answer: SQL Mail requires a MAPI compliant server to connect with directly and work. Because you are using POP3 it doesn't support the same authentication methods...