Maint. plan in 2005 is not upto the mark and is having few bugs, that need proper fix. Hopefully MS will come out with that in near future.

I have raised this...

Check this behaviour using one of this 2 ways.

1. If SerialNo and OfficeNo are part of your Insert than

collect that value in temp variable and run t-sql

select  * from server2..tab1

where serialno =...

Amit,

As Sql Server 2005 is completely new written software, Backups created with Microsoft SQL Server 2005 cannot be restored to an earlier version of Sql Server. i.e. No Backward compitibility. 

I have confirmed this...

Bill,

I am MS-Sql Server DBA with 5 years of experience and will email my details by tomorrow morning.

Thanks,

Aayush,

Frank McBath has very good article on this, Check this link, I think this will be useful to you.

 http://www.informit.com/articles/article.asp?p=27566

Check this link

http://support.microsoft.com/default.aspx/kb/307487

Thank you Antares,

Here is some more detail after executing

 Vw with one condition. It took more than 2 min. in comparision to join with 15 sec.

execution...

If you can Run Profiler.

Create New trace, Save data to sql table in another database.

choose Events and data columns you are interested in,

and finally Choose Filter :-> TextData like...

Check the error log and see what is the source of conflict.

As in deadlock 2 queries wait for each other to release the blocking.

See whether it is self deadlock i.e. blocker and blocked generated from...

This message generally comes when  maintenance planID is not correct.

Correct the plan ID for that maintenance plan and then check, it should work.

You can get plain id from msdb, sysdbmaintplan_databases which has  one...

If you are using  NT then to fix problem rebuild the profile and then stop and 

start the sql mail service.

Another reason for failure is Service startup account  set to the local...

Agreed totally with Steve.

Another thing to do is start playing with Sql Server 2005 and down the road convince your mgmt. for new product.

Sql 2005 has lot many new features, and...

Save trace results as .trc File.

Next time when you want ot analyse that trace

Open Profiler

On the File menu, click Open, and then click Trace File.

In...

Mark,

It runs from one schedule that says,

occurs every one day every 12 hours between 12.30.00 AM and 11.59.59 PM.

Thanks,

Hi Steve,

There is an error in today's question of the day.

I tried both Sql2000 and Sql2005.  Please check.

declare @return int

select @return = power(15)

if @return <> 0

select  'error'

if you replace select...