Could be permissions on the file itself. Hard to tell from here.

Looks like a permissions issue, SQL Server can't read from the directory of C:\ZZZ.

Not sure, Sean, but I know I had issues with some of the code...

Could just be me, but I'd...

Lokesh Vij (7/27/2012)

---

For checking ANSI_PADDING on columns:

SELECT name column_name,

CASE is_ansi_padded

...

OR should that INNER JOIN be a CROSS APPLY? Could sleep last night and with nothing to use for testing I may have the wrong statement there. Thinking...

You owe the O word a...

Nice catch, mistake in my typing. I should have just done a cut and paste.

Try:

BACKUP LOG database_name TO <backup_device> WITH NO_RECOVERY

Based on what I read here:

http://msdn.microsoft.com/en-us/library/aa225964(v=sql.80)

declare @ThisDay date = '20081231';

select dateadd(dd, 1, @ThisDay) -- returns the next day

The AND criteria in the WHERE clause could possibily go away if the last join I added is correct.

Lynn Pettis (7/27/2012)

---

Does this do what you are trying to accomplish?

with BaseData as (

select

[SID]

from

dbo.ContStand -- table3

union

select

[SID]

from

...

Does this do what you are trying to accomplish?

This code won't work, the CTE is declared in the wrong place. Corrected code is in the next post.

selects.SID,

s.Label,

s.State,

clAge.ClassID...

anthony.green (7/27/2012)

---

This is the view, currently obfuscating the tables and generating some sample data which will follow if needs be.

selects.SID,

s.Label,

s.State,

clAge.ClassID AS AgeGradeID,

clSubject.ClassID AS SubjectID,

s.Description,

dbo.functioncall(s.SID) AS ResourceList

from Stand...

This query won't use an index if one exists on UploadDate as the conversion from datetime to character string must be...