Thanks John.

Manu

Thanks for the update.

Manu

Actually we have configured NetIQ to alert in case virtual memory goe over 80 percent threshold. I am getting alerts for one server with VM usgae of 85 percent frequently.

Any...

Thanks for the reply. I will use them.

Manu

Can you try by inserting a check there:

activex Task(creates a file named from current date and time)

sql server query ---Check whether count(*) is greater than zero

write results of query to...

Would be helpful if you can paste the stored proc. and view code here. Also, are you making use of any table level hints in stoed procedure or view code?

Manu

Go thru this link once:

http://sql-server-performance.com/Community/forums/t/26845.aspx

Manu

Have you gone thru the script mentioned on

http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_23419233.html

Manu

Thanks for the suggestion. Actually job was successful on 12 out of 15 servers. I chked now and found one job whose schedule is conflicting with the failing job on...

Thanks again guys. I will specify the max memory setting and will get back to you on this.

Gail,

I think you are right regarding service restart thought.

Thanks,

Manu

Try this:

Use DBNAME

EXEC sp_help_fulltext_tables 'Catalog name'

Manu

Thanks for replying.

Gail,

SQL Server is configured to consume as muchmemory as it can. No limit specified for max server memory. Its set to default. This is a dedicated sql...

Can you try using sp_help_revlogin script and just create this Hyperion login on destination server and map it with database user there using sp_change_users_login stored procedure.

support.microsoft.com/kb/246133

Manu

Try querying the msdb.dbo.backupset table and take the latest entry for the database that you want to be restored.

Manu

Yes you can. Just right click the concerned object or user under databases and there you will see bunch of permissions tht can be assigned to a user.

Manu