Good to hear that it is resolved.

Slammed, overwhelmed, busy, need a moment to breath.

The only tasks in the Maintenance Plan were to perform full, diff and t-log backups? Were there any other tasks? Was there another job that had restored the...

If the package has been working and then failed this time then started working again, it is probably a network connectivity issue. It could also be that the remote...

David Webb-200187 (6/22/2012)

---

Maybe this is a silly question, but why do the concatenation at all? You're putting the same string on the end of both values, so if they...

You're welcome.

Thanks for the back to basics question.

I would make the effort to upgrade. There are new features that you will want to learn.

Will you run this and post the results:

select serverproperty('edition') as Edition

,serverproperty('productversion') as ProductVersion

,serverproperty('productlevel') as ProductLevel

This should do it

select

es.session_id,

er.database_id,

db_name(er.database_id) AS DBName

from

sys.dm_exec_sessions es

inner join sys.dm_exec_requests er...

Koen Verbeeck (6/21/2012)

---

Oh god not him.

He's the most important reason I have such a high post count. Trying to help him...

cfradenburg (6/20/2012)

---

This could actually make RTM releases more solid. With the cloud users working out a number of the bugs we may see less patching necessary on boxes we...

Nothing to feel guilty about with the increase in productivity. At some point a realization will be met that the technology has also created more jobs - just different...

It seems like you should be looking to do a traffic analysis using something like wireshark.

Evil Kraig F (6/21/2012)

---

Protip: Do not attempt to match wits on the thread after two days of intensive all...