Question is nice but framed incorrectly. since it's a view, It doesn't store.

The concept is good.

Simple and easy question.

Yes, the question is good but script could be better.

Regards,

Sudhir

Nice question.

A basic question but SQL script is poor. Though my answer was correct. But I cannot deny bits of fire from folks 😉

--Sudhir

Hi Folks,

Thanks for your nice comments.

Hmmm, I believe some of us didn't read question thoughtfully. anyways... next time!!

Have fun and Happy Janmashtmi (birth day of Lord Krishna) 🙂

Regards,

Sudhir

Nice question Nakul 🙂

Hi Adam,

Sorry but I do not see any valid objections.

Probably you are concerned about the sentence "The master database cannot participate in database mirroring".

"Master can't be mirrored" is right sentence,...

Thanks Ron 🙂

As you know, Master DB is a basic thing to learn for everybody.. So I framed my first question this way.

Can you please eleborate your question?

It's not clear from your question why you want to delete the key/value.

Hi Bevitt,

I would suggest you to go for SSRS because:

1. Improvements in SSRS 2008 and MS looking very aggressive into this area.

2. Work power/ resource requirement.

3. Easy to develop, deploy...

Hi,

As per MS documentation, Though it requires more disk space, but makes faster the rebuilding of the indexes while set to ON.

Again it's a decision whether to turn it ON...

Hi There,

Can you explore about database mail and sql server agent mail? It's easy to configure by looking at Notifications section of your job's properties.

otherwise you can refer to...

Hi Jayanth,

Sorry for late reply. Yes I do agree with you, sysdepends is not reliable because it does not maintain the changes in definitions effectively. But it can help you...

No Jayanth_Kurup,

You can compile your stored procedure with non-existent tables but for the same there is no records being maintained in sys.sql_dependencies. So the above solution is pretty close, I...