Nice basic question. Good to have point added.

--- babu

However try to use isnull(Pricemoney,1) * 100 if you have got any null related columns on the pricemoney. This way the result won't be null.

+ 1.

Nice question.

Good Question. Back to the basics. +1 to the total.

Yeah I got it. I got 1.

Before getting into the technical points.

What is the error you are getting?

I suggest you to please google and get some scripts to restore the database. if you encounter...

Good Question. Today I learned something new !!!!.

Wow. I did not knew there are DMV's to see the Service accounts.

Good to knew it.

Very good question.

I scored one today. Thanks for the easy question.

EL Jerry (2/21/2012)

---

Nice and easy. As someone said before, it's good to go back to the basics.

In your experience, how often have you seen DBs with Bulk-Logged recovery models and...

A good question to learn something.

But the new db created are not with read only option.

Are we missing something here. 🙂

Other than security I did not see any other reason to implement schemas in my database. The other possiblity is the needs of business may require to create schemas....

Sp_change_users_login 'report'

This gives you the list of orphaned users in the database.

sp_change_users_login 'auto_fix','orphaned users'

this will fix the orphaned user in the database.

Cheers !!!!

---- Babu

Oh well I thought the last option was increase memory in the server. Where as this found in the link provided by you.:w00t: But the option of constraint is not...

Thank you Antony. I decide to leave the file without shrinking.

---Babu