jblevins (5/12/2009)

---

RBarryYoung (5/12/2009)

---

Actually, looking at the error again, it looks more like a schema & schema permission problem than a DB one. It is apparently trying to create the...

tony rogerson (5/12/2009)

---

Using non-deterministic functions like ROW_NUMBER and NEWID need to be done carefully - my blog article: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/06/12/bug-in-inline-expansion-of-non-deterministic-functions-in-derived-tables-and-cte-s-causes-incorrect-results.aspx explains the serious bug that exists in SQL Server 2005 with...

Hmm, I did not know that. ...

jblevins (5/12/2009)

---

That's a possibility. I...

Kishore.P (5/12/2009)

---

The "/90/" indicates SQL Server 2005, was it in SQL Server 2000 also?

Yep, my bad. Sorry.

This is the same partial solution as before, just with better doucmentation and some column names:

Alter Proc spInstructorAssignments_SS_Solution as

/*select * from InstructorSummary order by StudentId

select * from Assignment --Where...

I forgot to mention that my example only addresses the case of Two instructors in one month. The one instructor case is striagh-forward of course. The three instructor...

The partial solution...

Have you tried Granting here CREATE TABLE rights on the Database?

Like this:

-- Find Rows in TableA that are not in TableB

Select * From TableA

Except

Select * From TableB

-- Find Rows in TableB that are not in TableA

Select * From TableB

Except

Select *...

SQL Guy (5/11/2009)

---

1. Should I build error handling on primary scope or the secondary scope, or both ?

[/code]

Safest way is to have error handling on both.

2. What methodology is better...

Size of the databases can also include much unused and unallocated space. And the tables themselves can also can varying amounts of currently unused space. Liewise, Indexes can...

Truncate Table is a DDL command and not a DML command. As such your user/login will probably need something like the db_ddladmin role.

Actually this is not sufficient. Very for database schemata physically implement all the relationships between tables as Foreign Keys. For the most databases, the logical relationships are left...