Lock /objects in Enterprise manager**

Hi
when I come to lock/objects branch in enterprise manager I find out so many
tables and views name there ,does it mean that all these are locked? or does
it mean all these are using by some users,but we can use it too?
any help would be thankfulYou can get more information with sp_who and sp_who2 system stored procs
Dishan Fernando
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||http://msdn.microsoft.com/library/d...y/en-us/adminsq
l/ad_perfmon_6ofn.asp
DishanF
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Location of dbases.

Hi!

When I'm looking at the properties of my dbases I see there are at c:\program files\ms sql server\ etc..

But I want to put ALL my current and future databases to E:\.

Can somebody tell me how to achieve that?

You should use alter Database command to move the files to the new location.

When you create your database you can specfic the location that you want the files create as part of the create Database command.

Michelle

|||

I've found out how to place new databases.

But can't I igive up a default location? Cause people that don't know about it maybe put it in the wrong place.

And the alter command? I tried to change it true the GUI but the location properties where grey.