If you have never made a full backup of the database since it was set to full recovery mode, you will not have anything in your transaction logs.

Until you make...

What about PostModenism and NeoModenism?

If you use the same service account on multiple servers it is a security hole because anyone who is sysadmin on one of the servers can gain sysadmin access to...

GSquared (12/13/2010)

---

Are you familiar with using Round() and adding .5 to the value?

DECLARE @Number DECIMAL(9, 2) ;

SELECT

@Number = 12300 ;

SELECT

@Number AS Original,

...

If the...

It has...

SQL 2000 Standard Edition can only use 2 GB of memory.

There is nothing in SQL Server 2005 or later to tell you how they were licensed.

You can also do something like this if OPENROWSET is enabled:

select

a.*

into

#new_table

from

openrowset('SQLOLEDB','SERVER=(local);Trusted_Connection=yes;',

'

SET FMTONLY OFF;

EXEC SP_HELPDB @dbname =''master''

') a

Use a temp table instead.

select dateadd(mm,datediff(mm,0,getdate())-1,0) as FirstDayOfLastMonth

Lots of resources about SQL Server DATETIME manipulation here:

Date/Time Info and Script Links

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64762

select dateadd(mm,datediff(mm,-1,getdate())-1,-1) as LastDayOfLastMonth

My recommendation is to run a daily full backup and a transaction log backup every 15 minutes, 24x7, to have the highest level of security for user data. With...

declare @retcode int

exec @retcode = msdb..sp_send_dbmail ...proc parameters...

if @retcode <> 0

begin

...code to handle error ...

end

Then why did you post your question in a SQL 2005...