ah i see..

well..

datename(dw, ReleaseDate) will get you the day of the week..

you could perhaps return the values then PIVOT?

Based on the expected results..

1.City Sun Mon...

Based on your requirements, this seems like homework?

If so - are you looking for the answer, or are you looking for ideas?

Well if the installation files are on the cd/dvd - then reading the label on there should get you there 🙂

otherwise - looking at my sql dvd here, i have...

Can you reload the data? That might be the simplest way to go..

What recovery mode are you in? Perhaps you can switch it across to simple or bulk_logged...

I'm with ya.. something a company i worked with did as well.. they had access databases which updated every couple of hours so if the main system went down they...

I don't know your application or backend, so I'll fight my urge to offer advise on better ways to manage DR

For what you're asking, you have some records which are...

Was there anything in the event log?

i'm not sure I understand the question..

are you looking for ways to do it, or asking if its a good approach?

scripting languages such as powershell are extremely useful - you can automate a large variety of tasks.

sa is the devil

after you resolve your initial issue, start a mini-project of going through all your apps and maintenance tasks and change the sa user to another user

when...

That worked perfectly, thanks so much..

I was pretty close in what I had but wasn't quite there.. and the link on dynamic cross tab sounds pretty interesting - i'll definitely...

visibility where? the report manager?

yowzer.. thats a lot of instances to keep track of..

i'd be interested in hearing from anyone from small-mid size businesses as well though.. some interesting numbers out there i bet...

i've no doubt that SQL Server boxes are scattered amongst companies, even though supposedly Oracle or AS400 shops - and i've absolutely no doubt at all that theres a good...

I hadn't (though i feel pretty stupid for not checking now)

but now running the sql and then running the 'all blocking transactions' report - i get no blocked transactions :\