No need to leave this site. Brian Knight has an article on this here http://www.sqlservercentral.com/columnists/bknight/transferdiagram.asp

Grin, curious what the forum software will do wiuth the hyperlink

Hey, now that I have turned off the WYSIWSG editor in my profile, hyperlinks are not displayed correctly...

Hm...just took a look at this one

http://dict.leo.org/?p=2Ib6..&search=deprecated

And now I'm not sure if this is the right word for it. I think outdated is better.

Anyway, thanks for your answers.

As you can see by the replies, there is no system functionality to get the backup history (at least none that I know of), so I guess, as you already...

After thinking over it again, I think there is basically no need for a separate small app for this. You should also be able to create a *.bat file that...

So all complaining will not help. When Brian will respond, I think I know what he won't do.

...even though there is a running contest, it are only virtual points.

If I remember correct from history lessons it was only one single vote some centuries ago that you now speak english and not german .

As it would not make any sense, to clear all result for this day and allow answering again, what about forgetting today's QOD completely, deleting all results and come tomorrow...

Sure, I can. I do this kind of explanation each evening to my son when it's time to go to bed.

- Start BOL (You should see 'Getting started...Microsoft SQL...

Interesting homepage you have, Robert.

Are you going to have a German branch?

Hans, you'd be amazed how different they could be. We had wonderful thread (mostly here in this section) where we painfully found out on this. When you click on the...

Hey Hans, seriously asking for a reason?

Complaining is far easier than listening!

OK, although I'm not sure what is better and not quite sure on the size of the columns.

if object_id('#t_users') is not null

 drop table #t_users

go

create table #t_users(

spid int,

ecid int,

status nvarchar(20),

loginame...

You know, what I really like about those QODs is the huge number of first time posters who only silently follow the threads otherwise.

Not to say the SiteOwners should go...

As you seem you only want this for a specific db and not the whole server, you can pipe the results of sp_who into a (temp) table and select then...