quote:

---

Why do I get the impression that you guys only know bavarian beer????

There is more in Germany than Munich (not much...

quote:

---

quote:

---

There's obviously no way to "play forward" without a subsequent log backup; where...

If you let the system generate the SID, it will be a GUID (as it is generated by NEWID()), so system-generated SIDs should never be the same. On the...

quote:

---

Neato thanks for the improvements. I'll try them out in production soon as I burn em in.

"Why not just use the datetime...

Are you reading Average or Last numbers? If Average, then the duration on the ws would differ, and might include periods with higher activity.

Any chance your server has more...

quote:

---

I am not using the snapshot of the sql, I am using the VDI in order to do a Disk\partition snapshot (The...

quote:

---

Hi again;

First of all, thanks for the replies, however,

As far as I understand there is no way to play the logs forward...

CREATE FUNCTION dbo.fnAlphabetOnly(@Input nvarchar(400))

RETURNS nvarchar(400) AS

BEGIN

DECLARE @pos smallint

SET @Pos = PATINDEX('%[^A-Za-z ]%',@Input)

WHILE @Pos > 0 BEGIN

 SET @Input = STUFF(@Input,@pos,1,'')

 SET @Pos = PATINDEX('%[^A-Za-z ]%',@Input)

END

RETURN @Input...

SELECT *

FROM Calendar_Event

WHERE Start_Date_Time >= @StartDate

 AND Start_Date_Time < @StartDate + 1

 

SELECT *

FROM Calendar_Event

WHERE @StartDate BETWEEN Start_Date_Time AND End_Date_Time

--Jonathan

Why not just use the INFORMATION_SCHEMA.TABLES view?

--Jonathan

If you're only returning one row, use a stored procedure with output parameters for the values you are fetching. This will be faster than using a recordset and will leave...