It sounds like a blocking issue; other than analysing (sp_who, sp_lock, sp_kill etc) who is blocking who, you can increase (at least temporarily) the instance connection timeout. Other thing you...

I can only tell you what I use and this is from a DBA point of view - please see check-points below. About when to create objects, I'm affraid there...

Have to reinstall .Net 2.0; if stil doesn't work then have to repair sql client tools installation:

start /wait (your sql path)\SQL2005\Tools\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

from cmd prompt;

Good luck.

In sql2k5, you can see the number of times that an execution plan has been executed since it was last compiled by querying sys.dm_exec_query_stats;

SELECT qs.execution_count,

        SUBSTRING(qt.text,qs.statement_start_offset/2,

   (case when qs.statement_end_offset = -1...

Check that you have memory correctly configured;

In case when lock pages in memory is not enabled it is possible that OS will page out SQL Server. This situation...

Update statistics.

see Creating Packages Using the SQL Server Import and Export Wizard in BOL (SQL 2005)

How to find out the pk-fk definitions (other way):

CREATE

VIEW dbo.ConstraintAndTableName

AS

SELECT

sysobjects_1.name

I use a book written by Allan Hirt, Cathan Cook, Kimberly Tripp and Frank McBath: "SQL Server 2000 High Availability".

If you're referring to the physical memory: Computer management ->right click ->Properties-> General tab

Create a sql agent job with a restore script like the one below; if you need to restore over an existing db then firstly would be to set the db...

use master

go

GRANT VIEW ANY DEFINITION TO user;

go

SQL Server Configuration Manager -> SQL Server 2005 Services -> on sql server service, right click, then 2nd tab;

hope this is what you're looking for

try this

ALTER

AUTHORIZATION ON SCHEMA::dbo TO some_one_else;

where some_one_else is...

The sorting order can be defined as asc or desc at the moment of index creation; this can be changed with ALTER INDEX statement or using Enterprise Manager (right click over...