This form of the update statement has special rules for running in this manner. They MUST be followed, or your data can be made wrong. See comments in code for...

Fernando,

Just to make sure that I'm on the right page with you, BDE is the Borland Database Engine? If so, the BDE was last updated to work with the SQL...

Since...

Remarks are in the code. Hope this helps.

DECLARE @StartDate datetime,

@EndDate datetime,

@days ...

GOOD CATCH!

If this...

Ann Cao (11/17/2010)

---

We will restore sql 2005 to another new sql 2005 server.

We plan to name the new computer something else first, then after restore, turn off old server, and...

Well, BOL does say (for CURRENT_TIMESTAMP)

I guess they really mean it's an alias for it.

@? Is your name Dick, or Dirk?

Can you verify also:

1. That you...

kknobloch (11/17/2010)

---

I have a Stored Procedure that returns a comma delimited list (ex: one, two, seven, nine) - when I pull this into SSRS 2008 rather than it displaying...

SSIS is not licensed separately, and it is in fact installed on all of the cluster nodes during the installation. If MS had a problem doing it this way, it...

Clinton Finch (11/17/2010)

---

@Wayne - that worked great - thank you!

I did make one error in my answers to your questions: the PK is clustered. Don't know...

One small thing you need to do when running SSIS on a cluster.

On each node, go to the C:\Program Files\Microsoft SQL Server\100\DTS\Binn directory, and modify the MsDtsSrvr.ini.xml file.

On the line...

I think SSIS is using .Net functions. It would support current_timestamp in an ExecuteSQL task.

I have to agree with Steve - if this is what you came up with after seeing the solutions posted here, then you need to STOP and get someone that...

GrassHopper: What version of SQL are we dealing with?