Not clear what does it mean.. But I think you want to show dropdown for input parameter...

in this case jsut create a dataset witlth all value and in report parameter...

http://www.windowsitlibrary.com/Content/1352/02/toc.html

Hi PD

Thanks for reply...

(Please see attachement)

1)Regarding last column please put 2002 in row width and you will see last three column will be NN3 and 3 will be P2P SIGN...

Attached Flat File Fixed Width ....

Column name Length

PERSON ID 20

FIRST NAME 30

LAST NAME 30

MIDDLE NAME ...

error :-

[Flat File Source [1]] Error: Data conversion failed. The data conversion for column "Column 12" returned status value 2 and status text "The value could not be converted because...

Hope these link might help you

http://vyaskn.tripod.com/moving_sql_server.htm

http://vyaskn.tripod.com/sqlserverres.htm

Thanks!

Ola Hallengren

Thanks Ola.. I was confused about rebuilding indexs..

Could you suggest me any post where I can get info about Cluster and Non cluster index as how they work...

>As I understand it we only need to rebuild non clustered indexes if they are fragmented.

As what I understand is that Noncluster index will be pointing to cluster key so...

Rob Symonds

Thanks for script ..

This work fine but actually I need all ALTER TSQL will be in output so I just copy and then run .

I just modified...

Regarding 3) about rebuilding non clustered indexes based on the fragmentation of the clustered index. Is this a best practice? The stored procedure does not support this.

Ola :- If clustered...

Gail Shaw

Could you explain what shrink will do ?

Thanks!

As per definition

'SQL Server identifies backup storage media through the use of identification of the backup...

Thanks

Hi Deepak,

Thanks for reply but I think Job is not running and I am not able to see what is issue as it is not taking actual schedule date ..

I...

This is showing error

Incorrect syntax near '+'.