Physical Server:

OS - Windows 2008, Service Pack 1

System Type - Stand-alone, Terminal Server

CPU - 16 Core 2.67 GHz Intel Xeon(R) X5550

Memory - 32768 MB

SQL: Standard Edition (64-bit), Service Pack...

There were no memory errors in the logs or event viewer. However, I did not try the dedicated admin connection.

Got it!

CREATE PROC [dbo].[DELETE_DATABASE](

@DATABASENAME VARCHAR(255)

)

AS

BEGIN

SET NOCOUNT ON;

DECLARE @sql NVARCHAR(100)

SET @sql = N'DROP DATABASE ' + @DATABASENAME

EXEC sp_executesql @sql;

END

That worked! Thank you very much.

Thank you for the suggestion, but I am getting the same error.

Msg 457, Level 16, State 1

Implicit conversion of varchar value to varchar cannot be performed because the collation of...

I was able to create the trigger for INSERT, UPDATE, DELETE, but can you fire a trigger off from a SELECT statement?

I ended up using this procedure instead....

http://support.microsoft.com/kb/246133/

This trigger works perfectly on my one server, however I created it on a second server and for some reason I don't receive the email. Database Mail is setup...

I am using the following trigger I found on SQL Server Central.

USE [msdb]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

----------------------------------------------------------------------------

-- Object Type : Trigger

-- Object Name : msdb..trg_stepfailures

-- Description...

http://www.kodyaz.com/articles/reporting-services-write-top-to-bottom-custome-code.aspx

and

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/3b38e2f1-563e-48e2-bda0-a5dc58026ee6

worked.

Thanks.

Yes....3 production databases on the same server. The users can only connect to one and then the backup of that one is restored to the others. For some...

Works with following:

set transaction isolation level read uncommitted

set nocount on

SELECT CASE WHEN DATEDIFF(D, MAX(TRANSDATE), GETDATE()) > 4 THEN '1' ELSE '0' END AS ThresholdExceeded,'It has been '+ CONVERT(VARCHAR(10), DATEDIFF(D, MAX(TRANSDATE),...

Receiving following error

Msg 245, Level 16, State 1, Line 7

Conversion failed when converting the varchar value 'FALSE' to data type int.

This was helpful.

set transaction isolation level read uncommitted

set nocount on

SELECT tablename, transfered, DATEDIFF(day, transfered, GETDATE()) AS diff

INTO ##tempResults

FROM [product].dbo.table_updated

WHERE DATEDIFF(day, transfered, GETDATE()) >2

ORDER BY transfered

IF @@rowcount > 0

BEGIN

EXEC msdb..sp_send_dbmail

@recipients =...