ZANGLE is a K-12 Student Information System.

I simplified your query some and ran it against a copy of ZANGLE database.  Take it and make whatever changes you need, but I think this is what you are looking...

Looks like you are running Zangle.  I will look at your query a bit and see what I can do.

Unfortunately, I can't answer that question as we haven't started migrating any of our SQL Server 2000 systems to SQL Server 2005 yet.  All our SQL Server 2005 work is...

The best practice is for those users to have 2 logins.  One admin/dbo and the other just a plain user.  They should use the admin/dbo login only when needed, otherwise...

The only solution I can suggest is to use dynamic sql inside your procedure to build the INSERT statement so you place the keyword DEFAULT in the VALUES clause.

During a...

This select statement will return all employees including those with no assigned projects:

Select emp.EmployeeName, proj.ProjectName, emp.ManagerName, proj.StartDate, proj.EndDate

FROM Employees emp

  LEFT JOIN Projects proj

  ON emp.EmployeeID = proj.EmployeeID

This select...

Not a clue.  I've installed SQL Server 2005, SP1, and SP2 without incidents like that.

Based on what you have given this may or may not work:

SELECT stuff

FROM

    DB1.dbo.TAB_a a

    inner join DB2.dbo.TAB_b b

        on (a.col_1 = b.col_1)

    inner join DB2.dbo.TAB_c c

        on (b.col_2 =...

Any luck yet with this procedure?  What problems are you encountering?

Use the DBCC CHECKIDENT to reseed the identity columns or truncate the tables (if you don't have foreign keys defined).

Just curious, can I change my name on this site just in case?

Doubt it.  I don't think he knows about this site and (as selfish as it sounds) I don't intend to tell him about it.

Unless the SSIS package is a Maintenance Plan, you need to use BIDS to open and edit the SSIS package.

Jeff,

Nope, it isn't.  It happens to be our Student Information System (I work for a K-12 School District).