got it... thanks hthan

Ninja..

I did not get your statement " there is no turning back once it's done" ? do you mean it cannot be switched back to full recovery mode once its...

as you said the user does not own any object then drop the schema with the name of the user under databases --> security -->schemas. This is the behaviour of...

Microsoft acknowledged this and gave a small workaround to this. They say this problem occurs when the database contains a table that has an index on a computed column.

http://support.microsoft.com/kb/902388/

The...

Hi,

Have you tried to backup the transaction log file.

If you have did that it will reduce the size and you can shrink the trnsaction log file.

Kelli, you are right. I was dumb in that line

Thanks Philcart...  your suggestion really helped me now I am able to get what I wanted. phew... sort of releif

Thanks all

Thanks for the reply MOM.

My team administers around 40 DB servers of which we check their error logs manually every day. I am trying to find a way to...

I think sp_change_users_login 'report' should give you the list of orphan users created while copying the db.

name                    minimum       maximum       config_value    run_value    

-------------------------------------------------------------------------

set working set size       0             1                    1                   1

max serv memory (MB)   4             2147483647     2816            2816  

min server memory (MB)  0             2147483647     2816            2816

We have the same...

We do have three servers (production) set with one

name                    minimum       maximum       config_value    run_value    

-------------------------------------------------------------------------

set working set size       0             1                    1                   1

max serv memory (MB)   4             2147483647     2816            2816  

min server...

Hi,

You can use following dbcc command and getting the details of memory usage MS SQL Server.

Use master

go

DBCC memorystatus

go

Thanks

Chandra

when I run EXEC MSDB..SP_get_composite_job_info, This jos shows current_execution_status as 7.

The link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_cnst04_5cfn.asp says 7 means "All executable job steps have completed. Job history logging is being performed" but this...

I didn't find any events related to memory in either system or application logs.

Hmmmm. you are in sort of luck!!

Here in Chennai, India I got fried from scorching summer heat and had to beat it with couple of beers

I Agree with steve