A few comments about the code to format the dtsrun.ex is:

SET @command = 'dtsrun /E /S"server_name" /N"dailysalessum" /A "@StartingDate":"8"="' + @Starting_Date + '" /A "@EndingDate":"8"="' + @Ending_Date + '" /W...

SQL Code for condition 5 got messed up and the Greater than and Less Than signs are making the code disappear - just replace GT and LT with the approriate...

There are 5 overlap conditions between a Club interval and and Address interval which means that they occur during the same interval. This is easiest shown graphically with...

Why would you need to know the original SQL Statement ?

Note also that only someone with sysadmin rights can run

DBCC INPUTBUFFER and most sites will not allow...

Error 3624 indicates that there is data corruption. Please check the ERRORLOG for any messages.

For such simple SQL, as the execution plan will be very short, this is the simpliest method - using SQL Server Management Studio, open a query window and paste in...

One more disadvantage of a single database with multiple schemas - The customer calls and indicates that they have messed up the data and want there information restored from backup...

Just saw on bottom of the forum post for subscription option this literal "Note: Your selection is saved as a default for next time ". Will let you know...

"in the profiler in the reads column for the audit logout class event de number is very high. "

For the logout event, the values for CPU, Reads and Writes are...

The change made are listed below and recommend replacing hard-coded database names with synomyms to have location independent of the name.

Changes:

For clarity, the table alias that are one character have...

Indexes definitions are not compatible between Oracle and SQL Server and must be extensively modified.

Packages are not supported by SQL Server.

Trigger are not compatible between Oracle and SQL Server and...

Regarding your questions:

Q: Is it viable to have an architecture with separate schemas for tables but with single stored procedures that will dynamically work with the sperate schemas?

A:...

"Boycott SQL Server 2008" ?

I have boycotted SQL Server 2005! - the number of fixes per week is astounding !

Noticed that you did state "Combination of Department and Team_ID generate a primary key.", a normalized schema is below. Notice the on update cascade for DepartmentName.

You could add a DepartmentId...

Tried Jeff Moden's suggestion to use "context switching" but I cannot get this to work based on three schemas and a dbo schema stored procedure, where the schema of the...