Good question, but the answer leaves me a bitter. I assumed Stored Procedures were in use with proper parameter types. (which is what I use). So SQL...

Ya, great question.

I didn't realize the subtle different between Count(*), Count(1) and Count(expression)

Count(*) - Includes Nulls

Count(1) - Includes Nulls

Count(expression) - Does not include nulls ie Count(ColumnName)

Thanks Jim, sounds good. I'll upload it to the web virtual directory and pull it from the physical location passing in the file path as a variable to the...

Check out this post, they have some suggestions http://www.sqlservercentral.com/Forums/Topic486271-148-1.aspx

Another idea...

Replicating Stored Procedures, UDF, Views etc...

Create a master database with the common data flow, ie commonly used Stored Procedures Views. Replicate this into each of the databases using...

Cutespn - That's a great link to Multi-Tenant Data Architure. It is exactly what I'm looking for as it discusses using Multiple Databases, Multiple Schemas, and Shared Schemas.

Thank you!

Follow...

Works great Scot, Thank you!

Here's an example for testing what Scot gave us.

CREATE PROCEDURE prctest

AS

BEGIN

DECLARE @t AS TABLE(col1 int NOT NULL, col2 int NOT NULL)

BEGIN TRY

-- Throws an Error...

To tymberwyld -

Did you find a resolution for the Schema issue when Raising Errors etc?

I'm curious to know because right now I log errors to a table, that tells me...

Ya, it's in Simple mode so I'm guessing that's the end of trying to recover the data... 🙁

One other solution, not yet mentioned, is using Instead of triggers. You could use an Instead of Delete trigger to move the records that are to be deleted to...

I use cascade deletes quite often (when ever appropriate), but as Grant Fritchey says use them with care.

For instance, consider the following (the naming convention here is just for clarity)

tblCustomers,

tblSalesOrders

tblSalesOrderLines

tblInvoice

I...

I've wrestled with the same issue as in the past and usually I just got around it by doing something else, such as making them into multiple columns in each...

Cumulative Update 5 Build 9.00.3215 KB - Problem

http://support.microsoft.com/kb/943656/[/url]

We contacted Microsoft and installed the update, but when I do a SELECT @@Version I still get build 3042.

I'm not sure if they...