one other way is you can also specify the case statement including IsDat check.

CASE WHEN IsDate(value) then CAST/Convert( value ) else "you can specify the default date " END

1 question does column position matters to you / database ?

you can add the column at specific order either by the way mention by Jack Corbett. there is not other...

Ray,

I appreciate your view but the problem arise for permissions when i execute the SP either i have to user EXECUTE AS Clause or I have set the permissions for...

Jaya,

it's always good to keep your object objects isolated. this will help you to keep track. This may possible that in future there will be a change in your Business...

Yes you can do it by using MERGE JOIN task after fetching the data from different sources.

you can also use this query ....

select CAST(CAST(sum(size) * 8192 / 1048576 AS DECIMAL(10, 2) ) AS VARCHAR(20)) + 'MB' from sys.master_files where database_id = DB_ID('Global_DB')

yes we can implement column level encryption using the ASYMMETRIC KEY and SYMMETRIC KEY to encrypt & decrypt the column data.

check msdn for brief help on ASYMMETRIC KEY and SYMMETRIC...

Why do you want to implement recursion as you are searching only for only 1 level

As you mention :

all the position that reports to "Product Development"

e.g "Project Lead;QA...

There must be the problem of locking your table is getting locked

Have you created any index which is greater in size ?

When you restore the sql 2000 database on sql 2005, you have to fix the mapping of users & database manually.

You can not detect that which table is used by Application, for that you have to do manual work there is no such tool.

About database you can check that whether...

just a suggestion to check,

When you created the linked server have to given the permission to NT\WindowsUser ?

This could be simpler as mention below.

SELECT sm_type, count(sm_type) FROM sm group by sm_type

i think it should be like this...

IF @LineFilter in ( '1,2,3' )