IN last transactional log backup I checked the back up the tail log.

and leave the database in restoring state option....

That made database in restore state....

So when should I restore the...

I think its because of SMTP server.

Do you having outlook.

Check these too:

1.Have u given the correct IP and port for SMTP.

2.In database mail profile (ie. AdventureWorks Administrator) did u...

There are many ways of extracting the data from a SQL Server table to Excel or a text file. Here are the options that you can chose from:

...

You can use these and make your query

select * from sysconstraints

sp_fkeys

sp_Pkeys

Give the user db_datareader database role......

DATEDIFF ( datepart , startdate , enddate )

for days use datepart as dd

Check out:

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

In Activity monitor see the columns BlokedBy and Blocking in process info...

This will tell you what is blocking or bloked by the processes....

Check out ;]

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

Check out :]

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

Go ahead no probs in doing that.

Keep a backup of the current database b4 swapping so that if someone complains you have an answer.

Did u properly configure the Reporting Service (Database and Virtual Directories) on the machine?

Check the followings working properly

1. http://localhost/Reports web is working.

2. Anonymous accress is diabled or not...

This means the Service Broker is not installed on the server

Check out:

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

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

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

Check out:

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

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1110445,00.html%5B/url%5D

The link is not wrkig whr to enable anonymous access

Yes

Have done that..........

But im getting this error

Anjali, if its only a one time requirement u can go with import and export wizard........