I think the best way to do this job is to set up the Log Shipping.

You can use this proc to restore your database...

------------------------------------------------------

EXEC master.dbo.xp_restore_database

@database= 'Pubs'--Database Name

,@filename= 'C:\Pubs.bak' -- Backup File path

,@filenumber=1

,@WITH='REPLACE'

,@WITH='RECOVERY'

,@WITH = 'MOVE "Pubs_Data" TO "C:\Data\Pubs_Data.mdf"'

,@WITH = 'MOVE "Pubs_Log" TO "C:\Data\Pubs_Log.ldf"'

,@servername...

Can you please write the error number and the full message.

Or use this for fragmentation

USE MASTER

GO

SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON

GO

CREATE PROCEDURE sp_DBA_DBCCShowFragAll

AS

BEGIN

DECLARE UserTables INSENSITIVE CURSOR

FOR

...

Use this to view fragmentation in percent

SELECT

OBJECT_NAME(object_id) AS 'Object Name'

,index_id

,index_type_desc

,avg_fragmentation_in_percent

FROM

sys.dm_db_index_physical_stats (DB_ID(),NULL, NULL, NULL, 'LIMITED')

WHERE

avg_fragmentation_in_percent > 30

ORDER BY

OBJECT_NAME(object_id)

Now my next question is what PORT you are using to connect to the database. I mean what port your SQL Server service is using. Check if you can telnet...

SQL Server Enterprise edition can only be installed on the following Server OS:

Windows Server 2000 with SP4

Windows Advanced Server 2000 with SP4

Windows Datacenter Server 2000 with SP4

Windows Server 2003with...

CREATE TRIGGER EmplDeleteTrigger

ON Empl

AFTER DELETE

AS

BEGIN

INSERT INTO EmpDup (@EmpID, @Name, @Salary )

END

GO

Can you please tell what account the service is running under. If it is running under different account then check if that account has permission on the database server.

Schema are logical container to store database objects and are used for security purposes for example let assume I have 10 tables in my database that needs to be viewed...

If you have read the introduction it cleary states that it is the Enterprise only edition. Please read carefully before you comment on any thing.

I looks that this post text is just a copy/paste from some book chapter which is the voilation of copyrights can you please tell what actually is not working.

You dont need to kill the process because SQL Server automatically kills the process that is creating that deadlock by using its internal deadlock manager.

The best way to do that task is to use Import/Export wizard....

Follow these steps.

1) Right Click the database from which you want to transfer the data.

2) Choose Export from the...

Before deleting the builtin administrator account make sure you have another account that has administrator rights. Also make sure your SQL Server or SQL Agent services are not runnig under...