SQL Serer OLAP how to migrate to Azure studio

Hi,

In Sql server Can I able to remove 'Sysadmin' role (Windows authenticated) with out remove 'Sysadmin' role in 'BUILTIN\Administrators' group?

Regards,

Lee

Hi Roy,

Thanks for reply,

All the users are in os administrator's group, if I remove sysadmin role to BUILTIN\Administrators group all the users will loss the

Sysadmin role in windows authentication....

Hi,

If I remove sysadmin role in Builtin\administrators group, is there any problems will occur( like services,,,)?

With regards,

Lee

Hi RoY,

With out removing the 'Sysadmin' role for BUILTIN\Administatrors' group

Can I Create Group in Local system and assign the users and gave the permissions to the group in SQL Server?

With...

Hi Roy,

Thanks for your reply.

If I remove 'SysAdmin' role in Bulit\Administrator Group,

Will automatically removed Check box in 'Sysadmin' role to that windows authenticated users?

Pls Let me know

With Regards

Lee

Thanks Dugi

the users are administrator in Operating system

In sql server also they have Sysadmin.

But in sql server I dont want to give the sysadmin role to those users. In sql...

Hi Dugi

I mean

In windows server the users(admin rights) are rights to access sql server, right

But I need to give few roles only to access sql server(Windows authenticaion) to...

Hi

Thank you for all

With regards

Lee

Invalid column name 'ID'.

Msg 207, Level 16, State 1, Line 1

Invalid column name 'ID'.

Msg 207, Level 16, State 1, Line 1

Invalid column name 'ID'.

Msg 207, Level 16, State 1, Line...

it is not working it displays

all rows as 1,2,4

Thanq david

It shows all the spid inf

But i need only USERS

Index Scan:

Since a scan touches every row in the table whether or not it qualifies, the cost is proportional to the total number of rows in the table. Thus, a...

We can't do anything with out MDf file.

Thanks for your clarification

Thanking you