Seems like a value here is from the record keeping/auditing perspective.
To lessen the 'out of date' problem, why not add a date(s) as an ext prop(s)?

Something like...

As a DBA it sounds great to say we should have the flexibility to apply CUs or SP as necessary. The difficulty is when external entities(i.e. PCI-DSS) demands that all...

SELECT PlayerID

,score

,ROW_NUMBER() OVER(PARTITION BY PlayerID ORDER BY scoredate) as 'rank'

FROM Scores

I recently had this issue with SQL 2005. I resolved it by disabling remote connections ( so that my application servers would not keep stealing the connection )

You can also...

Or.... just look at the server as listed in Object Explorer in SSMS ( Sql Server Management Server).

Where you will also see the '9.00.2047.00' that indicates SP1.

Application roles are designed for just such a situation. The user has permissions that are only activated when the applilcation supplies the password for the application role. Outside the application...

SQL-DMO has been deprecated so I guess it will go away (in next SQL server release?)

You say you assigned logins to the new role. However, I believe only users are assigned to roles.

Have the logins you created been granted dbaccess ( are they actually users...

Can you describe what you mean by an incremental upload?

I guess I have the advantage of knowing the server which is hosting the SharePoint. Once you find out which server it is, you can look in the %content% database...

I believe that the SharePoint site is using a SQL server database to store the Excel file in a binary column of a table.

In this case the 'export column' transform of...

I believe what you are looking to do is assign the parts of your connection string dynamically. The connection string can be controlled dynamically by manipulating the properties of the connection...

Any variable you create in SSIS has a scope. I believe that a variable with Global scope would be one scoped at the SSIS package level as these variables are...

To set up Profiler, you can track the SP:starting event.

You want Profiler to report the object_id column., To determine the object_id, run this query:

select object_id('<name of SP>') in the database...