My first guess was may...

Thanks,

I am actually planning to improve that Stored Proc and make it a list for all SQL Agent Jobs instead of passing a parameter.

So sometime later next week check my...

There you go ...

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/4671b8db-cedd-4059-8761-f50483f09bff/%5B/url%5D

Search for a considerable amount of time for such scripts when you need.. you should get them some where like...

Well, do you have some one from application team to help setting connection properties?

Glad I could help 🙂 🙂

How long is it showing the message?

What is the DB Size? It may be restoring the backup on the secondary server..

You don't have from clause in the above statement how will it work?

You need to...

In continuation with happycat, since differential backups backup the data since the last full backup,they...

There is no difference in SQL Server 2005 and 2000. Read the article below for a good idea about it.

Managing Transaction Logs By Gail Shaw[/url]

Then look at the...

I would use Maintenance plan to do it, but it...

Hi,

Don't go back and edit your previous posts since we cannot keep on tracking if you have edited the original post and look for changes or new update. I was...

TheHTMLDJ (11/22/2009)

---

I checked out your website. Do you have any plans for video tutorials about complex topics such as Analytics? I have not been able to find these anywhere and...

tho.pfaff (11/21/2009)

---

ordinary queries grap the rows from the hard-disk, where the cpu needs more time to grap them. and erery time the sql-query is executed the a full table-scan must...

tho.pfaff (11/21/2009)

---

ordinary queries grap the rows from the hard-disk, where the cpu needs more time to grap them. and erery time the sql-query is executed the a full table-scan must...

From the error message,it seems you are using SQLNCLI10 as OLE DB Provider.

To better understand your problem, have you run any query against the linked server and tested it?

Is it...