Thanks for ur kind help, will come back to you if i have more doubts

Greg, please help with the script to set these permissions.

Thanks

please reply me,

what permission should i give for the userid( dbowner or dbread & dbwrite) in the connection string from the application to connect the db.

Thanks

yes database connection string, what permission should be given and how is should be created in sql server.

Thanks everyone,

I have found a solution for this problem,

first i manually removed the sql server from add remove programs

secondly, i install the windows install clean up in my pc

thirdly when...

i have tried this earlier, but still the same error

what is BOL can you explain on how to do these auiding through ddl

Thankyou Markus, it works for me now , how about appling transactional log backup.

should i follow these steps

full backup with no recovery option

diff backup with no recovery option

translog1 backup...

Really usefull and helpful. thanks for the prompt response

how to check what is the date format of the sql server. why the display is different from that i have set. how to ensure that the date format i...

thankyou venkat

thanks greg

Please reply for this

I have a table with one identity column ,user login and , ID Column in a table with few more columns.

In this table identity column , user login , ID Column all have unique...

in our data model the identity columns are not used for searching just for consistency purpose, we have created identity columns. we are not going to use this field  for where condition...