DTA: Data Tuning Advisor.

Sound like to me, pretty strange

Here we go.. We can do in so many ways, its depend on time period and Access/Excel front end hooking direct to SQL Server 2008, SSRS etc. I recently used...

Script is good, down on knee sql.

thnx

Hi,

Thanks to Gianluca Sartori, Perry Whittle & all who answer.

It's help me a alot and from my bottom of heart, thank you(Gianluca Sartori & Perry Whittle) dude.

Keep do and...

Hi,

Thank you for reply.

I have around 50 server & around 200 Instance's. You mean i have to login every server and run that syntax or ? Did i miss anything.

Note:...

Thank you Gianluca !

i got this error

Msg 15401, Level 16, State 1, Line 1

Windows NT user or group 'xyd domain name\fxb-dss-fsx-sqladmin'' not found. Check the name again.

Msg 15007, Level...

Hi,

Thnx for asking.

AD group name is : fxb-dss-fsx-sqladmin, this group have(2 user) access to win 2008(OS).

This group is SYSADMIN.

I have around 50 Sql Server and more then 100 Instance...

Thanks you for reply.

In my case is, backup is taking care of 3rd section, which i dont have any idea of how they taking back stuff. And where back is,...

Hello,

thnx for your repaly, which is pretty usefull.

Can i retriev password also ? for all user in database level and server ?

thnx