post the script.........

:w00t: :w00t: :w00t: :w00t: :w00t:

May be this might also work :w00t::hehe::cool:;-):-)

[Code]

--

use DB_TEST

create table employee (E_id int,Name varchar(50),Gender char(20),Age int,SALARY MONEY,constraint E_pk primary key (E_id),constraint...

Im still having the problem

CREATE PROCEDURE usp_job_history

@dateparam DATETIME

AS

SELECT dbo.sysjobhistory.server, dbo.sysjobs.name AS job_name,

CASE dbo.sysjobhistory.run_status

WHEN 0 THEN 'Failed'

WHEN 1 THEN 'Succeeded'

ELSE '???'

END as run_status, dbo.sysjobhistory.run_date, dbo.sysjobhistory.run_time, dbo.sysjobhistory.step_id, dbo.sysjobhistory.step_name, dbo.sysjobhistory.run_duration, dbo.sysjobhistory.message

FROM ...

You can script it out......and run the script in the other server........

And always u can use import and export wizard.........

Yes that worked. Thanks a lot Florian

Check out:

http://technet.microsoft.com/en-us/library/bb677622.aspx%5B/url%5D

http://msdn.microsoft.com/en-us/library/ms144267.aspx

http://blog.scalabilityexperts.com/2008/01/28/upgrade-sql-server-2000-to-2005-or-2008/

What is the result when you send test E-mail

Check if you have set agent properties->alert system->

mail system as database mail

mail profile the profile u have created for database mail.

Security best practices for a SQL Server installation

Each of the items that follow will make your system more secure and they are part of the standard security "best practices" for...

Hi

Check out the attached.

Check out this for High Availability options:

http://msdn.microsoft.com/en-us/library/ms190202(SQL.90).aspx

http://www.sql-server-performance.com/faq/cluster_log_shipping_replication_p1.aspx

Why don't you try other "high availability" options.

Check remember password.

Can you tell me what exactly is the error.

When i exported empty tables using the export wizard i didn't get any error.

Thanks Andrew

I created a one way trust and resolved the issue.