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).

Jeff,.

I will have to go with the later statement regarding the co-worker.  The application for which the SQL Server is dedicated to is a 3rd party app.  Yes, at times...

A little honesty, I'm not the one the one at our shop doing this.  One of my coworkers claims that it takes 4 to 6 hours daily to monitor one...

SQL only ignores the ORDER BY if you specify TOP 100 PERCENT.  If your query specified TOP 10 PERCENT (or any value less the 100), the ORDER BY is honored.