Good stuff.

One minor gripe, you shouldn't be using leading underscores for identifiers. It's generally considered bad practice.

Steve Jones - SSC Editor (6/7/2011)

---

Craig Farrell (6/6/2011)

---

calvo (6/6/2011)

---

wow. I was about to question this when I looked it...

Gangadhara MS (6/5/2011)

---

Hi,

I am using the data format as below.

DECLARE @table TABLE (number nvarchar(max))

INSERT INTO @table VALUES (4.5267489711934158E-2)

INSERT INTO @table VALUES (8.8356729975227088E-2)

INSERT INTO @table VALUES (9.9356025758969638E-2)

SELECT CONVERT(VARCHAR(4),CONVERT(INT,ROUND(CAST(number AS DECIMAL(4,2)),...

Or

SELECT

TOP 6 DATEADD(DAY,-1,DATEADD(MONTH,1-ROW_NUMBER() OVER(ORDER BY name) ,'Jun 2011'))

FROM

sys.columns

More info available here

Maybe you should mention that change tracking is only available in SQL2008 and higher.

Tom.Thomson (5/26/2011)

---

nigel. (5/26/2011)

---

Steve,

Thanks for that question, I'd was not aware of 'loginproperty' until now.

One question though. I tried to recreate your scenario but always get '1900-01-01 01:00:00.000' as the...

No, its a...

Yes, I attempted to create one (as in Steve's scenario) by logging in via SSMS using an invalid password for...

Steve,

Thanks for that question, I'd was not aware of 'loginproperty' until now.

One question though. I tried to recreate your scenario but always get '1900-01-01 01:00:00.000' as the result. Anyone...

No, and I've just realised why, sorry :blush:

Too early, need more coffee

Wouldn't it just be:

ORDER BY create_dt

First problem I can see is that you have no column that defines the ordering of the rows in your data, without this there is no way to determine what...

Ok, sorry that's beyond my knowledge.

You may be better off asking this in the SSIS forum on this site .

Not exactly clear what you mean, if you're talking about an asp.net application and storing the connection strings in web.config then look here : http://lmgtfy.com?q=encrypt+connection+strings.

Even if this isn't exactly...