Example from Stack Overflow:

CREATE TRIGGER DML_ON_TABLEA ON TABLEA AFTER INSERT,DELETE,UPDATE AS BEGIN SET NOCOUNT ON; ...

Are users going to be entering data into the HospitalPatients Table?

If so you should not Denormalize.

This will impact on your selection of a Clustered Index.

I did not mean to offend you.

I did not mean it that way.

If they thought you were weird...

I recall creating a @[User::SheetName variable to store the Current Worksheet.

Create a script task to set the value of the @[User::SheetName variable.

In the Excel Destination Component, Change the data access...

Did you get a chance to read the links?

Are you upgrading to SQL Server 2008 R2?

Upgrade SQL Server 2000 to 2008 R2

http://msdn.microsoft.com/en-us/library/ms144267.aspx

Upgrade SQL Server 2000 Log Shipping to SQL Server 2008

http://technet.microsoft.com/en-us/magazine/dd450972.aspx

imadiamond2016 (8/23/2011)

---

1. Can you please comment on my proposed solution explained above? Should I go with one common table i.e MS_HospitalPatients for all hosipitals/units/departments OR should I create separate MS_HospitalPatients...

With respect to the design thanks for the information. You provided the Foreign Keys but what table and column does the child tables relate to (Parent Table & Column)?

I'm familiar...

The following would be of help to you.

http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

Anam Verma (8/22/2011)

---

Hi

If i use the following command,

ALTER DATABASE [dbName]

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

GO

will it kill all the processes on the database and rollback transactions if required?

Or do i...

Why don't you start out but setting the properties manually without injecting the dynamic connection properties.

Enter the connection properties to mimic what you are attempting to do dynamically.

Once you have...

Did you check the value of variable at runtime?

Place a breakpoint and verify that you have the correct syntax.

http://msdn.microsoft.com/en-us/library/ms141204.aspx

Other people reported this error and it may be a bug.

What SP do you have?

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/35c5dbdc-97dd-40de-8f01-29506c8ccba1/

Sounds good.