Importing KEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell registry changes only some settings like tools->option->designers.Other settings like tools->option->sql server object explorer not changing.. where is the registry for those changes?

Thank you

We are using sql...

Thanks for reply

I don't think importing KEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell working. Don't know about other settings but it certainly not working for edit top n rows and select top n rows...

Thanks for reply

I think "Import and Export Settings" not present in management studio 2008 And even in management studio 2012 i doubt all settings are importing. I have tried to...

Thank you

My actual doubt now is what is difference between user mapping page(which shows permission like datareader,dbowner etc) and one under database->security->any user.Right click user and click properties.Now u can...

Thank u.

But i am not clear about two security folder under server and another one under database.In both database role membership is specified.So what is difference between them?

Anyone please reply me

If i create a file group with read only then how can i insert the values to the table? What is the use of read only file group?

What if i create secondary file group as read only?

How can i import from an excel file in sql express 2008 r2?

I tried to use tab limited file and the bulk insert query as

BULK INSERT designs

FROM 'D:vt.csv'

WITH

...

I think comapct edition does not allow multiple connections to same database in network.I want database to be access through network simultaneously for atleast 5 to 10 users.

I have sql server express.So SSIS is not available for me.

Here is a sample of csv file i am trying to insert

QueryResult,QueryResult,500,2,46,A,abc,1,NULL,NULL,"date_atnd,time_atnd",,70,NULL,48,NULL

Here date_atnd,time_atnd has the comma in between. So i...

thank u for replying.

I have a doubt. All my database have recovery model full. If i do file group backup separately for primary file group regularly and secondary file group...

Microsoft SQL Server Management Studio version is 10.50.1600.1

And server is sql server 2008 r2 express

I found that while i restore primary file group in ssms by using only primary file group file backup file i used following script

RESTORE DATABASE [test] FILE = N'test', ...