If you are running this off BIDS, right click on the Project properties > Configuration Properties > Debugging. Set the Run64BitRunTime to False.

If you are running it standalone using the...

Hi Chandi,

Is the compatibility level set to 90? Or is it left as 80? This won't necessarily give you the problems that you are having, but some features of 2005...

Hi,

A primary key is a constraint, while a clustered index is an index.

A primary key makes sure that duplicate records are not inserted into the table. It provides entity...

Hi,

Is it possible to be a little more specific regarding the Lookup part? Are you looking up a table? And what sort of problem are you getting?

Regards,

Gogula

Try this:

SELECT DISTINCT

bg.bg_id [BugId],

bgAuditOpen.bg_added_dt [Open],

bgAuditClose.bg_added_dt [Close],

DATEDIFF(dd, bgAuditClose.bg_added_dt, bgAuditOpen.bg_added_dt) [NumberOfDays]

FROM

bugs bg

INNER JOIN Bug_Status_Audit bgAuditOpen ON bg.bg_id = bgAuditOpen.BgStAd_bg_id AND bgAuditOpen.BgStAd_New_st_id = 1

INNER JOIN Bug_Status_Audit bgAuditClose ON bg.bg_id = bgAuditClose.BgStAd_id AND bgAuditClose.BgStAd_New_st_id...

Hi,

Yes, it is possible to do so. In the 'Backup Database' dialog simply add both your devices to the 'Destination' section. The database will backup almost equally onto both the...

Yes, you could...

Hi,

You could use the Script Wizard available with SQL Server. Just right-click on the database in Object Explorer, go to Tasks -> Generate Scripts... Follow the wizard and select the...

Hi,

My suggestion would be to use an INSTEAD OF DELETE trigger. Write it in such a way, that it updates the record instead of deleting the record. And when it...

How about a trigger, to run on INSERT, UPDATE?

[font="Verdana"]A Unique index allows only one NULL value, so that values entered are unique (while indexing SQL Server compares NULL values as equal). It is by design.[/font]

... and it also returns the correct resultset before giving the error.

Even I, all these days thought you were one, until now (I mean until several days ago)... Congrats Steve, you more than deservedly deserve this!!!

Try using the Execute Process Task component instead of the ActiveX script task.

Just enclose the word Foreign within box braces... [Foreign]