Please make sure your Full text enabled tables and their columns ,once u restored on the other server, u have to make manually the fulltext columns on the particular table...

Difficulty to see the code of SP

The above concepts and keywords available in sql server?

I mean

the below query

SELECT * FROM TABLE1 A WITH (NOLOCK) inner join TABLE B WITH (NOLOCK) on A.DocID...

Thanks Eugene Elutin,

But its not working. Return 0 result.

many thanks!

But i need to clarify with 2 and 3 points, please help, if altering the all columns as MAX mean?

Thanks for your Quick response...

Developer using seesion in Asp.net for fetching the user_id and client Net address , That value can we take from SQL server?

It's great but i need the full count of the result set,

If i am using the between 1 to 10 mean the Count will 10 only..

But nvarchar maximum size is 4000 right?

Many Thanks for all support.......

Bu My backup was two days older than lost date, so i am struggling.

Yes, you are correct, But our software end user's, they said clearly, will not fill up the values in multiple text box, they need single input box only like comma...

Many THanks,

But this Input Box in Report is mandatory, Because when the Customer seeing the report, if there is any comments Mean ,they can give the input with correspoding...

Thanks for all Replies,

We have changed into CSV format to Txt format with Pipline as Column Delimeter.. Now Bulk insert working fine..

Thanks Now working fine, But In CSV file format, if one field like Product

descriptions having Multiple Comma Inside, but our SQL splitting them in to multiple column,

but We want...