thanks for the reply , i have solved the problem.

I have concatenate all single row data to a variable with comma as follow

select @var = char(39)+colname+char(39)+','+@var from table

select @var =...

Thanks it worked.

i have this thread which can solve the problem

http://www.sqlservercentral.com/Forums/Topic581296-359-2.aspx

thanks and regards

ramu

hi all,

thanks for the reply,

i have forum and got good answer that first assign only db_datawriter rights to the user and

explictly assign select delete insert alter and create permission to...

Hi,

log is increaing as there are lots of insert update and delete operation going on the Database. You can shrink log by taking first full backup once a week and...

hi,

Even i thought of using DDl trigger but it will effective to all users.

I dont want to restrict users from changing table view or procedure schema but to restrict...

If you are using SSIS to load the data of excel sheet. Put validation before loading the data into database. the job might failed because of empty records.

Use openrowset in...

To be more specific, i have source table lets mytable which have 4 million records.

in order to reduce the time i have taken four dataflow. and in each data flow...

Please help guys.

Yes i am doing the same way.

guys i hope my problem is clear to u all

Regards

Ramu

thanks for the reply

thanks for reply

what about non aligned when it should be used

guys please suggest some thing

use dbcc shrinkfile

or backup log with truncate only option or set recovery model to simple