Hi,

To increase/decrease the gap between bars, go to series properties and update 'pointwidth' property under 'CustomAttributes' Section. Default value is 0.8. If you decrease the value, the gap...

I got it working after I removed Globals!ExecutionTime from the report.

Thank you Stefan_G.

Yes; we do have some servers with same name in one domain and non-domain(workgroup servers). Max(domain) does work, but unfortunately that is not the case with all the...

Thank you for the replies.

I was trying to avoid complex queries too; however, inner Select query in the UPDATE statement returns multiple domain names, so it returns 'subquery returned...

Hi Anthony....

Works as exactly how I wanted.

Many thanks... 🙂

Renuka__

Hi,

Thanks for your reply. We created a seperate SQL job that takes COPYONLY backups. We run this job (or particular step for specified database) whenever there is a request from...

Hello...

Hope these articles help...

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

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

Hello,

You can modify the tempdb size by going to the properties (right click Tempdb and properties); change the initial zise and the growth; The values should take effect when you...

Hello,

Right click on the instance in Management Studio and go to Properties, select Database Settings to view the default database files' locations.

Run the below query to view the database file...

Hi,

Can query log_shipping_monitor_secondary table in MSDB for last copied and last restored files.

Thank you

Hi,

No. The database can not be accessed when it is in restoring mode.

Thank you

Hi,

It was done succesfully.

Stopped the FT services. Copied the FTDATA contents over to new drive from existing drive. Deatched the database and attached it back by specifying new FTDATA location...

Yes. The service account under which the service runs can be changed for Fulltext Search service, same as we do with other SQL services.

Thank you for your response.

I did check that article earlier; but it does not say it is applicable for SQL 2005.

Hi,

I think its possible only through registry change and to be considered very carefully.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup\CurrentVersion]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup]

In these 3 keys there are language settings. It's DWORD so...