Thanks for all yours reply..

Operating system & SQL 2008 32 bit processor architicture.

Please confirm the options which is correct boot.ini file modification.

Option -1

boot loader]

timeout=5

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect...

Hi,

we have license copy of enterprise edition also product key comes automatically while during installation time.

Does production server going will be down? If not create & mention license information at...

MCITP - Database Administration 2008 -Microsoft Press book not available Indian market.

Inform me if anyone knows this self training kit books

Erode P. Satheesh (4/25/2012)

---

The property "License Type" and "Num License" are followed till SQL Server 2000 release. Microsoft stopped registering value for this property from SQL Server 2005 onwards....

I want to confirm as below Query

1. For the DR setup best solution Database Mirroring & Log shipping

Does Log shipping is not reliability of data also both committed/uncommitted data transfer...

successfully removed Jobs at SQL Agent in remote server by disabled FK constraint in table msdb database

use msdb

go

alter table [dbo].syscollector_collection_sets_internal

nocheck constraint FK_syscollector_collection_sets_collection_sysjobs

use msdb

go

alter table [dbo].syscollector_collection_sets_internal

nocheck constraint FK_syscollector_collection_sets_upload_sysjobs

rgds

ananda

I am running this SP at remote server, not in UCP server

use msdb

go

EXEC [dbo].[sp_sysutility_mi_remove]

RegOpenKeyEx() returned error 2, 'The system cannot find the file specified.'

Msg 22001, Level 1, State 1

RegOpenKeyEx() returned...

Hi , Thanks for reply...

currently UCP utility server not avilable due to some reason SQL 2K8R2 uninstalled in testing setup server.

I want remove jobs manually for Remote server SQL Instrances...

Thank you Mrs.Brandie Tarvin for explain dynamic SQL in sql server coding.

I m not developed Application & Database, Developer might be used dynamic SQL coding at database level. I am...

Thanks for reply..

Total 4GB RAM, 32 bit system, os - win 2008 enterprise edition,

SQL - SQL server 2008...

Hi,

Already enable Adhoc distribute query at instance level.

CacheTypeTotal PlansTotal MBsAvg Use CountTotal MBs - USE Count 1Total Plans - USE Count 1

Adhoc11177297.083992.085016

Proc240102.4245376.6138

Prepared27212.511212.9841

Trigger30.1820.162

Check140.370.125

UsrTab10.13200

View12011.837200

As per this result tells like, Adhoc Total...

I m facing problem for Procedure cache Hit ratio = 70 to...

1. Could you tell me, In Memory Object counter - Total & Target memory shows same values and same memory. Does these values are good or bad?

2. Total 4GB Physical...

Hi,

Mr.Perry Whittle, this is excellent reply..

I have successfully deleted that DTA session with help of using

sp_DTA_delete_session 2 ( 2 is session id)

Thanks

ananda

hi,

Thanks for reply...

I have checked as you suggested, MS DTC services was stoped at two server,

if I start these services to enable Network DTC access and INBOUND/OUTBOUND also...