SQL Server uses SysIndexes for statistics, so it doesn't just contain user-created indexes.

The query needs to exclude the indexes where the name is prefixed with "_WA_Sys_".

select * from sysobjects a

where...

Creating dynamic SQL is the wrong way to go about dynamic configuration in DTS. If everything is the same each time except for the connection string, you should use an ActiveX...

What if there's a tie at the nth place ?

If there were 2 records for D1 with a mark of 80, what are your requirements ?

Search on the topic "parameter sniffing"

Derived table to get the max() for each ID, then join to the derived table:

Update TABLE_A

Set COL_1 = dateadd(day, +364, dt.MaxCreateDate)

From Table_A

Inner Join

(

  Select TABLE_A.Id, Max(TABLE_E.SystemCreateDate) As MaxCreateDate

  From...

Impossible to help without the DDL and datatypes of the columns involved.

When you comment parts of a join, the resultset is different, therefore rows that are triggering the type conversion...

Perform 1 select as a derived table, and join to that ?

Select *

From YourView As v

Inner Join

(

  Select *

  From YourView

) dt

  On ( v.JoinKey = dt.JoinKey )

http://www.windowsitpro.com/SQLServer/Article/ArticleID/7454/7454.html

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&safe=images&num=100&q=MAPI+error+273+group%3Amicrosoft.public.sqlserver.*&safe=images

Open the DTS Package.

Right-click and select 'Package Properties'

Click on the 'Logging' tab.

In the 'Error Handling' section, enter a log filename for capturing the package errors.

Now schedule it again and provide...

>>It's not a permission issue because I am running this under admin account

You missed the point of the 1st response.

You state "*I* am running this under admin account". *You*...

Since this is going nowhere, let's go back to the original problem statement:

>>When I run this my Discontinued and sunset field dates become incorrect on some rows. 

"Incorrect" and "some" are...

The are probably a half dozen different ways to do this, but here's 1.

This article will help: http://www.databasejournal.com/features/mssql/article.php/1459181

You create 2 packages and 1 stored proc. The outer package queries...

I apologize - shoulda gulped some more caffeine before replying, because I assumed ADO.Net, when you are clearly referencing classic ADO.

The System.Data.SqlClient namespace is from the .Net Framework and is...

Place your cursor in CreateParameter. Hit F1 to get MSDN help. This is what it says:

The different behaviour inside the SP may be due to parameter-sniffing and a resulting different execution plan for the SP, versus your standalone statements with hard-coded values instead of unknown...