You cal also use 'real'.

float

- 1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308

Depends on the value of n(Storage)

real

- 3.40E + 38 to -1.18E...

You can use Float

you can also log all sql statements through enabling C2 audit. But it will hinder badly performance of your Server and create a big file on your disk.

did u check ur Backup using Verifyonly command

SELECT importdate FROM

WHERE

CAST(substring(importdate,8,4) AS integer) < 1754

OR

CAST(substring(importdate,8,4) AS integer) > 9998

if u r checking whether ur date column is between the datetime range

do you hear other sounds on your computer. Is ur speaker on mute?

Hi,

Option 1

I am sorry u had to go through all the dates. How many total dates do u have? Can you run this query for me

SELECT importdate FROM ...

No,

ISDATE is different.

You can use this ias an example

DECLARE @datestring varchar(8)

SET @datestring = '12/21/1098'

SELECT ISDATE(@datestring)

Above will still print out 1 because its an valid date. but still out of...

Do u think there is a possibility u might be having a date that is not between this range:

January 1 1753 to year Dec 31 9999

I mean, in your WHERE clause

DATEPART (year,CAST (importDate AS DATETIME)) = 2007

Have u tried using Cast or Convert to convert your Varchar Date to Datetime and then using the function u are using now?

with so many times running up the installations can u check in services.msc that how many SQL servers have u installed. Adventure work database doesnt comes by default so while...

did u try creating table name using dbo.TableName

in my SSIS interviews, I was asked following:

1)What have u done with SSIS

2) describe your project

3) can u execute 2 separate tasks using single package, if yes how

4)Do u know...

Can u completely delete the old connection and create the connection with a new name in your transfered pacakage? This might help, worked for me. I think the connection information...