Not sure. What you have should work.

Try the following:

ALTER PROCEDURE [dbo].[mspResetDayNo] @Today DATETIME

AS

BEGIN

DECLARE @DateSrc DATETIME

DECLARE @StGUID UNIQUEIDENTIFIER

DECLARE @err INT

...

What is self?

Just curious, but what is the definition of this function: dbo.MyStGUID()

Going good now, but had an iffy time for a bit. I'll pop you a DM with a little...

If you surrond the url with the [ url ] and [ /url ] IFCOde tags, you...

Please take the time to read the first article I reference below in my signature block. It will step you through the things you need to do to post...

select

Column1,

Column2,

'REF001' as RefName,

REF001 as RefValue

from

SourceTable

union all

select

Column1,

...

Depends. Is litespeed only being used for full backups or is it being used for the t-log backups as well?

Evil Kraig F (3/8/2012)

---

Lynn Pettis (3/8/2012)

---

Have to ask, but why the restriction on the number of records in each file? Personally, I can't think of a good business case...

Just curious, but why did you start another thread for the same question? We still need the same information I asked you for in the other thread if you...

Read the first article I reference below in my signature block. Follow the instructions on what you need to post. Also, post the expected results based on your...

Confused. Figured what out? If you figured something out regarding a question you asked, you really should post it in that thread.

You do know that the ssc site is hosted on server in the UK, right?

Still confused. I don't see any tables in the first query using the AT alias. I only see that in the subquery you are using the code snippit...