GilaMonster (10/23/2012)

---

Not an answer, however...

The WITH ENCRYPTION on procs and functions is not encryption. It's obfuscation at best and it is absolutely trivial to reverse. If you are relying on...

Could you create a small database that only has those encrypted routines within it, and give a backup of that to your customer?

Then they would have those routines on their...

This may be worth looking at http://michaeljswart.com/2011/05/when-to-use-blocked-processes-reports/ where it also links to http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx.

sys.dm_os_waiting_tasks will show lock resources and linking it to sys.dm_exec_requests will give you the database id.

It is entirely possible that a backup device has been created with the same name as the database.

Does that name appear within sys.backup_devices?

No you don't, but you should run a log backup again, to re-gain point-in-time recovery.

http://msdn.microsoft.com/en-us/library/ms190203(v=sql.105).aspx

A good starting point would be the Stairways series available on this site: http://www.sqlservercentral.com/stairway/91327/.

There is also the book "Learn Windows Powershell in a Month of Lunches".

Dynamic SQl would enable you to do this.

Have a look at a previous discussion for a similair example: http://www.sqlservercentral.com/Forums/Topic1261985-145-1.aspx.

HowardW (9/20/2012)

---

That's the path I'm trying to take here. First of all though I need to show what...

Documented behaviour - http://msdn.microsoft.com/en-us/library/aa226054(v=sql.80).aspx#feedback, half-way down the article.

Your requirement isn't clear. Could you post example tables, data and expected results in a format that allows others to run it, helping others to help you.

An example of how...

SQL Mad Rafi (9/7/2012)

---

Hi Guys,

i bought practice-test tool from MeasureUp the version 8.0 and 10.3

i feel the later version is much easier than the previous.

So, just curious to know why...

How often do you normally have to re-start your current instance? I've had to restart our development environment (which gets an inordinate amount of abuse from the developers) once in...

Maintenance window - or are you absolutely certain that the installation will run perfectly and can guarantee success first time?

You need to plan for this installation giving you problems,...

If you mean database_id, it is used within a wide variety of areas of SQL Server to identify a database. The name of a database can be changed, but the...

I actually have come across the Urban Dictionary's usage of the word in the UK, but only once and many years ago. So calling it 'common usage' would be exaggerating...