To confirm privileges

-Control Panel -> Administrative Tools -> Local Security Policy

-Then Local Policies -> User Rights Assignment

Regards

Hema.,

The Service account should be configured as “trusted for delegation” to permit distributed queries (parameter is in the same place as the password not expire param)

NOTE it MUST have a...

It works fine for me and Loads in a fraction of seconds.

Regards

Right click on Your server -> Goto Permissions -> select the account that you are running and go to View Any database -> Click on Deny permission.

System Center Operations manager (SCOM) will be best choice to

monitor both windows and SQL Server. We can install the custom dashboard

will give nice Reports.

Regards

Hema.,

I am not sure why service is running and agent is not available in express edition. It’s on top of my head to answer ;-). But I have utilized the...

Hi,

From my experience we have only enterprise edition have trial version.

Please find the details below

http://www.microsoft.com/sqlserver/2005/en/us/trial-software.aspx

Yes we can restore enterprise edition database on standard edition.

Regards

Hema.,

Hi,

I am attaching microsoft published e-book for your reference. You can download from microsoft site as well.

in case if you like it you can purchase.

regards

Thanks for information. Perfect.

Regards

Hema.,

From my stand point of view even DBA should not remote in to server, provided if it is needed. All the dba activities can be performed locally by installing a...

You can consider having SQL Server 2005 standard edition at this moment. another important thing just upgrading SQL Server 2005 R2 Standard edition is not having much advantages as compared...

SQL Server database Internal includes Architecure, data storage and indexes etc. Best place get all the details Books online.

Regards

Hema.,

Mani,

I am planning to do a in place upgrade from SQL Server 2005 to SQL Server 2008 in a active/passive cluster environment. Its one our critical server. How did your...

As mentioned others, First kill all the connections to restoring database in the first step and second step start the restoration.

I have developed a script for my purpose, first create...

Hi,

SQL Expression edition is cool tool and comes with free of cost.

Express edition don't have Agent to schedule the jobs and reporting services But we can do a custom replication...