Best practice is to index your FK columns for join performance.

CREATE INDEX <index name> ON <table name>(<column name>)

Sushi

I would recommend making sure you have your trace configured correctly. The trace will capture all SQL activity. All changes to data whether from SP, trigger code, or...

You'll need to write a function to do this. Here's a great ready by Jeff Moden on the subject:

http://www.sqlservercentral.com/articles/Test+Data/61572/

Have you run a SQL trace? That should tell you exactly what is updating your column values to NULL.

Steadfast.

wealth

Purpose.

leadership

David Lester (1/22/2010)

---

Iowa here.

And it seems to suprise many, I have never even been on a farm, cause there is more here than farms... well here specifically there...

OK, I mocked up an example based off of this table:

IF OBJECT_ID('dbo.SSISTest') IS NOT NULL

DROP TABLE dbo.SSISTest

GO

CREATE TABLE dbo.SSISTest(

Name varchar(10) NULL,

Value int NULL

)

GO

INSERT INTO dbo.SSISTest

SELECT 'Ab1',23 UNION ALL

SELECT 'Ab1',25...

From BOL:

A synonym is a database object that serves the following purposes:

Provides an alternative name for another database object, referred to as the base object, that...

Are these roles that you have created from scratch or are you trying to alter the permissions for the pre-existing database roles?

See this link http://www.sql-server-performance.com/faq/cannot_grant_permissions_to_special_roles_p1.aspx

As far as listing out SYNONYMS,...

You wouldn't use it to set the Send Mail task, you would use it to set the SMTP Connection...

The short answer is 'Yes' a script task can do this. You would first ensure that the data is ordered properly, declare a package variable as the counter, a...