Create a credential with the user account that created the package and then create an Agent SSIS proxy with that credential and then select the job step to run as...

This problem could arise if you are using SSMS 2005. Please try to use SSMS 2008 client tool

...

Hi Lian,

Try this

SSMS --> Rt Click on the DB --> Tasks --> Shrink --> Files --> File Type = Data --> Select "Reorganize pages before releasing unused space "...

Hi Ajit,

Use the following Perfmon counters

SQLServer:Memory Manager -- Target Server Memory (KB)

SQLServer:Memory Manager -- Total...

You can use SAN synchronous or asynchronous replication for Datablock level copy onto the DR Site and then during the disaster, boot your VM from the remote site. Things will...

This login may occur due to the Incorrect Connection string specified when connecting to the SQL Server or due to the inability to resolve the login.

...

Hi Sushanth,

In the Maintenance Plan -- Update Statistics Task,

...

What is the actual requirement, Is the requirement to increase the RAM on the Windows server or to increase the RAM for the SQL Server.

...

Check Log_Reuse_Wait_Desc from the folowing query

SELECT [name], recovery_model_desc, log_reuse_wait_desc

FROM sys.databases;

Also try .........

SSMS --> Rt Click on the DB --> Tasks --> Shrink --> Files --> File Type = Log -->...

Hi Sushant,

If your update stats take very long to run,...

Follow the experts advice @ Gail, Derrick, Ninja and homebrew.

Never turn AutoShrink option ON. This would be just an invitation to troubles.

Shrinking the files is not a regular or...

I'd prefer Idera's SQL Diagnostic Manager.

Thank You,

Best Regards,

SQLBuddy

Gail is right. She made it crystal clear. That's the difference.

...

My two cents..

You can check these books to become a master

http://www.brentozar.com/best-sql-server-dba-books/

Dissecting SQL Server Execution Plans by Grant Fritchey

Pro SQL Server 2008 Replication --- Sujoy Paul

http://www.sqlusa.com/highperformance2005/ -- Video Training

http://www.replicationanswers.com/

...

Run the profiler probably from the remote machine, Filter by the User account and check the application name and host name.

Check if the host name is not equal to the...