Thanks Frederico. Yes - you are right, I want the file to be formatted to have certain properties . I am creating around 1000files so can’t do this individually. I...

Thanks for your advice, I have been applying that switch and my export to csv works fine, exported csv file opens fine in excel. only issue I have is that...

Thanks a lot for all your advice it made me a lot wiser, if any more queries, will come back to u,

Cheers

Thanks again, but I have to move them as they are on the

Same disk as well, what are the risks when moving the system

Db's.

Thank you for the advice, how about the system databases,

can they be moved similarly - master and Model

Does the tempdb needs to be moved as well

You guys are absolutely right, that would be the best way to do it, I develop the front end as well but wasn't involved in the beginning; since I took...

the web application contains fair amount of controls as you suggested, but I guess having a control on the DB gives additional security, for example, in the case of someone...

Thank you both for all your inputs on this matter,

its been really helpful.

Firstly, the access is through for both non admin and admin users through a web application.

I see the problems that Roy points out, something that I never thought about it,...

Hi All,

I thank you all for your inputs, been on holiday and unable to get on the net so couldn’t follow the topic, but please help me to conclude...

Thanks a lot for the advice, as you said I should go

with the roles, however just wondering whether it is a good

Idea to keep the objects in different...

Thanks for the link provided, as you assumed I am not a regular DBA - please let me know what happen to varcharmax data when it exceeds 8000bytes.

if I may join in this discussion, I am in a similar position of migrating a sql 2005 DB to another sererver. My DB detils are as follows:

- simple recovery...

sorry made a mistake in the query, I am using FULL Join as follows:

select table2.data1, table2.data2, table3.data1, table3.data2 from

table2 FULL join table3 on table2.personID = table3.personId

where (table2.personid =...

Thanks Gail, I think I need to add the subjectID (foreign key) to this table, so that the headings can be categorized.