Thank you Jeff and dmoutray and the other contributors...I'm in Canada, near Toronto, and it's the Thanksgiving weekend. I'm in awe to the work you have done. Keep them coming...

I...

If you install SQL Server Accelator for BI (SSABI) -- if it is still available - the implementation of its generated DTS packages are all driven by variables, including INI...

So your solution is to use the Oracle driver from Oracle?

looks like you can still stop Analysis Services separately - if you run:

net stop MSSQLServerOLAPService

Johnny

What would it take MS to increase "REFERENCES per table" from 253? (This is the number of foreign keys that a table can be referred to). In a large DW...

Hi,

In your code you use a lot of GROUP BY's --- can you explain why?

Thanks!

With SQL Server 2005, there should be no need to have dbo own any user table. It is now good practice to have a schema, rather than dbo. It is...

Assuming there is an MeetingDate column, can it be as simple as this?

SELECT * FROM Employees

WHERE EmployeeID NOT IN

  (SELECT EmployeeID

    FROM MeetingAttendance

    WHERE MeetingID=@MeetingID

         AND MeetingDate BETWEEN @startdate...

Luis and Lee's problems are caused by linked tables -- because you can not control the locking of linked tables (which by default will give you all the contents of th...

The lesson is - never rely on implicit conversion of date and time. Each locale will have its own date format.  It's not only true in SQL Server, it is...

Based on your posts, it  looks like this feature was added by accident rather than by design in SQLServer2000, and so should not become part of programming. Before I knew...

aha, so that's how you get answers - google!  (and who doesn't?)

are these even going to go to SQL Server 2005? Some of these security permissions will need to be...

Then we should get a point if we answered error_line

I have not used these functions myself - so my answer was error_line. Error_level is...

Nonetheless, such AV should be reported to MS tech support because it is a bug. Microsoft will most likely not charge you with it if you can prove it is...

With this AV, it's time to contact MS Support. The SQL Server log may have more details.