Thanks Lynn.

The archive db did recover. I then shrunk its log. I expanded the prod log to a reasonable size given it normal processing/backup schedule.

Pretty resilent system despite my somewhat misguided...

I managed to shrink my prod logs to create some space. The archive db is still recovering, I'll let it go.

CREATE TABLE #Test

(

EffectiveDate DATE,

ExpiredDate DATE

)

INSERT INTO #Test(EffectiveDate,ExpiredDate) VALUES ('2013-02-14 00:00:00.000','2013-02-20 00:00:00.000')

INSERT INTO #Test(EffectiveDate,ExpiredDate) VALUES ('2013-01-01 00:00:00.000','2013-01-02 00:00:00.000')

INSERT INTO #Test(EffectiveDate,ExpiredDate) VALUES ('2013-02-03 00:00:00.000','2014-02-20 00:00:00.000')

INSERT INTO #Test(EffectiveDate,ExpiredDate) VALUES ('2010-12-31 00:00:00.000','2013-02-20 00:00:00.000')

SELECT

EffectiveDate,

ExpiredDate,

CASE...

Can you provide sample data?

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Do you understand what the crystal code is doing and can you state that in plain english or are you looking for someone to help you...

As a former member of the dbo only club who initially used schemas for organizational purposes there are two lessons learned for me.

There may be performance implications (probably negligible)...

ScottPletcher (2/13/2013)

---

Grant Fritchey (2/13/2013)

---

Ever is probably an over-reaction, but in general these types of naming conventions just don't make sense. How is tblInvoices easier to understand than Invoices? How is...

I have never been a tbl-er but I have been a usp-er.

Lately I put everything in a schema. Is this a reasonable statement as far as a best practice? Always...

SELECT * FROM sys.table_types

Thanks for setting me in the right direction...

CREATE TABLE #Holidays (HolidayDate datetime, IsHoliday char(1))

INSERT INTO #Holidays (HolidayDate,IsHoliday) VALUES('2013-02-18 00:00:00.000', 'Y')

INSERT INTO #Holidays (HolidayDate,IsHoliday) VALUES('2013-03-29 00:00:00.000', 'Y');

DECLARE @StartDate DATETIME

SET @StartDate...

This almost works based on a post by The Dixie Flatline here:

http://www.sqlservercentral.com/Forums/Topic649517-1472-1.aspx

His table has weekends in it, mine doesn't. I'm not sure where I can put the weekend restriction. My...

I don't have a calendar table, its a vendor provided database with a holidays table only.

So I almost need to generate my calendar table on the fly. Or generate enough...

That's the difficulty. I don't want to create a table first.

CREATE PROCEDURE MyProc

AS

SELECT 1 AS column1, 2 AS column2

--At this point my data-consumer could use code like this

CREATE TABLE #myDynamicTable...

Can you you arrange to copy the file to a location the test server can access? You could add this to the backup job or use a separate process.

You existing backup process should already be automated.

Assuming this is the case: determine where those backups are going; determine whether the test server has access to the backup files;...