many thanks for this usefull proc.

All I needed to add is a @Versions2Keep parameter.

Regarding the first insert:

INSERT INTO #temp2

...

It seems is going to be a cosy SSC-evening at SQLPass this year,

and by now Steve will have gotten the picture for the SSC-T 208:

front: upper left: SQLServercentral.com and the...

Congratulations Jeff and Michael.

A virtual pint to your honor ! (maybe we'll materialize that at SQLPass 😀 )

Check RETURN in bol !

Return is not used to fillup output variables, but it gives an integer value to the calling object. (mostly used to indicate OK or not OK)

To...

Steve Jones - Editor (6/30/2008)

---

I'd question all third party apps on this.

We implemented Dynamics about 8 years ago and they said they required SA to run the application. I dug...

And keep in mind that sql2005 may work better if the dblevel is put to 90. (=sql2005) Afterward you can put it back to 80 if needed !

The upgrade path...

install SP2 + at least Cumulative update 2 (CU)

We install up to CU5.

(CU8 is current, but you'll need to test if that one works for you !)

Aha, the wood and the trees .... :w00t:

Been there, done that 😉

Every once in a while, a good dba needs to proove (s)he's human after all 😛

so just use a single select and modify your where clause

...[Entry Type] in (0,1)...

can you post the DML you use for this delete ?

If it is a single delete statement that just performs like a table scan to do its stuff, that may...

So you see you would be better off using dbmail !

(better in sql2005 and nomore need for oa-stuff !!)

Quit simple:

Just add a default data file location and off you go !

You will need to restart your sqlinstance after you activate C2 !

USE [master]

GO

Declare @DataPath NVarchar(2000)

Declare @LogPath NVarchar(2000)

Declare @DataPathOLD...

imo the device activation error you see in the errorlog file, aren't related to your backup job.

What has happend to your G-drive ?? :crazy:

(G:\SQL2KData\...)

IMO having a higher checkpoint frequency will minimize its impact to the system.

It takes a checkpoint because it has a high update load (worktables, ... ??)

maybe (re) moving the...