Hi Jeff,

So is it compulsory to change the server name ??

Hi Gila,

I am expecting scripts .. can you provide any scripts to find the missing indexes and frequently used queries ???

HI ,

You have any idea why its happened ?? This is new Server frershely installed SQl server .I moved all the databases including system databases from other server...

Hi All,

cannot Show required dialog

unable to execute request command

Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.Management.MaintenancePlanWizard)

Thanks,

Lavanya Sri

HI Jeff ,

You have any idea how to find two servers in the same domain . ??

Thanks.

The two Ip's are different and two machine names are different .

You have any idea how to find these two servers in the same domain .

...

hi i want only date part from getdate function.

for example '2008/4/10' i want only date means 10 only