quote:

---

Look at ExamCram and ExamPrep books also.

---

Thanks for your input!

CSDunn

quote:

---

Sybex and Microsoft.

---

Thanks Patrick, I will look into the Sybex books.

CSDunn

quote:

---

I studied using two books...

---

If you don't mind sharing, which two books did you use?

Thanks,

CSDunn

Thanks for your help, Brian!

CSDunn

Thanks for your help. Is the only difference between Implicit and Explicit transaction mode the fact that Explicit transaction mode requires 'BEGIN TRAN'? If that is true then why not...

Thanks for your help!

quote:

---

One way to solve your problem might be to split your big view up into smaller views, I.E. create...

Please pardon the dumb question, but where is the 'Script Library' you referenced?

Thanks.

CSDunn

Thanks for your help! CSDunn

The following tested solution combines both of the suggested ideas, and accomplishes my objective:

******************************************

Create Procedure MMIncompleteRC_sp

@Permnum varchar (12)

AS

IF

(SELECT RC.Incomplete

FROM

tblRCStudentGrades RC

WHERE RC.Permnum = @Permnum) = 1

BEGIN

INSERT tblMMIncompleteRC

SELECT

SD.Permnum,

SD.FirstName,

SD.LastName,

TD.SystemUserName

FROM Student_Data_Main...

Thanks for your help! CSDunn

I was actually able to implement multiple CASE statements in the one View and SP that serve as the Record Sources for a couple of different reports. This saved me...

quote:

---

If you are using ARC with the SQL Server hook/add on installed then you shouldn't be backing up the .ldf directly.