Disk Configuration

Are there any scripts or commands, or GUI interfaces that let you know if
your disk drives are configured for RAID 1, RAID 5, etc.? How is one to walk
into a shop and find this knowledge if the network admin is unavailable?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200604/1
Usually you can find out this type of information on the box. Compaq
servers that I have worked on have the Array Configuration Utility. I am
guessing that other vendors have their own version of a utility to
administer (or look at) an array from within Windows. You can also boot the
box and watch the BIOS screens as they appear (assuming that this is not a
production box and can be rebooted during the day).
Keith Kratochvil
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:5e54ab7a96d03@.uwe...
> Are there any scripts or commands, or GUI interfaces that let you know if
> your disk drives are configured for RAID 1, RAID 5, etc.? How is one to
> walk
> into a shop and find this knowledge if the network admin is unavailable?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200604/1
sql

Disk Configuration

Are there any scripts or commands, or GUI interfaces that let you know if
your disk drives are configured for RAID 1, RAID 5, etc.? How is one to walk
into a shop and find this knowledge if the network admin is unavailable?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1Usually you can find out this type of information on the box. Compaq
servers that I have worked on have the Array Configuration Utility. I am
guessing that other vendors have their own version of a utility to
administer (or look at) an array from within Windows. You can also boot the
box and watch the BIOS screens as they appear (assuming that this is not a
production box and can be rebooted during the day).
--
Keith Kratochvil
"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message
news:5e54ab7a96d03@.uwe...
> Are there any scripts or commands, or GUI interfaces that let you know if
> your disk drives are configured for RAID 1, RAID 5, etc.? How is one to
> walk
> into a shop and find this knowledge if the network admin is unavailable?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1

Disk Configuration

Are there any scripts or commands, or GUI interfaces that let you know if
your disk drives are configured for RAID 1, RAID 5, etc.? How is one to walk
into a shop and find this knowledge if the network admin is unavailable?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200604/1Usually you can find out this type of information on the box. Compaq
servers that I have worked on have the Array Configuration Utility. I am
guessing that other vendors have their own version of a utility to
administer (or look at) an array from within Windows. You can also boot the
box and watch the BIOS screens as they appear (assuming that this is not a
production box and can be rebooted during the day).
Keith Kratochvil
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:5e54ab7a96d03@.uwe...
> Are there any scripts or commands, or GUI interfaces that let you know if
> your disk drives are configured for RAID 1, RAID 5, etc.? How is one to
> walk
> into a shop and find this knowledge if the network admin is unavailable?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200604/1

Disable logging

is there a option to disable logging during alter column
scripts...?
what are the events can be disabled from logging...?What exactly is your ALTER table command like? Can you post it here?
Generally, when you run an ALTER TABLE...ALTER COLUMN on a column, SQL
Server updates that column, to make sure the new column datatype is
compatible with the current data, and this results in logging. You cannot
disable transaction logging.
Your other alternative, could be adding a new column and updating the new
column with the old columns values, in smaller batches. Once the new column
is populated, drop the old column and rename the new.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:6cf901c4837c$609aaf30$a601280a@.phx.gbl...
is there a option to disable logging during alter column
scripts...?
what are the events can be disabled from logging...?|||> what are the events can be disabled from logging...?
SELECT INTO and other bulk operations are minimally logged in the SIMPLE or
BULK LOGGED recovery model. To provide ALTER TABLE functionality, you can
create and load a new table using one of these techniques and then drop the
old table and recreate constraints and indexes.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:6cf901c4837c$609aaf30$a601280a@.phx.gbl...
> is there a option to disable logging during alter column
> scripts...?
> what are the events can be disabled from logging...?

Disable Generate Scripts on Database

Hi guys, is it possible to disable database generate scripts for certain users? I would like to restrict it for security purposes while they able to get into the db and their role like the db owner. Hope can any assistance from you guys. Thanks a lot.

Best Regards,

Hans

You can't do it directly; but there is a workaround there.

1. Add the user in Master database

2. Select the db_denydatareader & db_denydatawriter role

3. Deny execute permission of the sp_helptext & etc.. for the given user

|||Thx for the reply Manivannan.D.Sekaran, however it seems not working at all.|||

If you don't want your users to have access to the definitions of your Stored Procs, Views, Triggers etc... then you could always re-create the procs with the WITH ENCRYPTION option - just ensure that you store copies of the original scripts in a source control database.

Chris

|||

Hans1982 wrote:

Thx for the reply Manivannan.D.Sekaran, however it seems not working at all. I wish to create a login for developer that able modify things within the db but cant backup/restore db, generate the whole db scripts and unable to execute 'Script table as' feature.

|||Thx for the reply,Chris. However, I just wish to the developer unable to generate the db scripts or table scripts for preventing the db structure bring out from the office.|||

I can't think of away of doing this other than taking SSMS away from the developers, which would obviously be counter-productive. I guess you could always write your own version of SSMS if this is a big issue for you.

The problem is that the 'Script table as' option directly queries system tables and views that are essential to the running of SQL Server and SSMS. Although you can deny permissions on these objects, doing so is likely to have wide implications.

Why do you need to restrict access to the 'Script table as' functionality?

Chris

|||For preventing the db structure bring out from the office.|||

Any developer who has enough knowledge of SQL Server's system tables and views would be able to generate their own scripts to reconstruct the structure without using 'Script As'.

Perhaps you need to look at ways of preventing people from copying / emailing script files from work PCs. Even then there's nothing to stop someone printing out a database diagram and taking it home, or even resorting to copying the structure using more traditional techniques, such as pen and paper.

If your database schema is of such high value then maybe you should address (at least) the above issues and add confidentiality clauses into your developers' contracts. Either that or simply don't allow the people you don't trust to work on your databases.

Chris

|||

I see. I guess that's the only solution for that issue because it seems no way to disable the SMO. Thanks for the good advice, Chris. Have a nice day.

Best Regards,

Hans