Kids,

Try this: it will print all your SPs text. I just modified the original query from the article to include OBJECT_DEFINITION function. You have to set Query Results In Text...

Brian,

The app uses sp_executesql, this is from the profiler that I just ran for the PW change. The password I submitted to the app was completely different.

execute sp_executesql N'sp_password NULL,...

Nice article, Brian!

I share your opinion about application roles and would like to give you one workaround how users can not access the database outside the application without using application...

Donald,

In 80% of cases you have no say as to store documents\images in or outside of the database. The third-party applications handle things its own way.

Also, storing in the database...

Data Storage is a great concern in terms of the SW upgrades.

We do have to keep data for many years due to FDA (more then 40 years), Sarbanes Oxley etc....

Hi Hugo,

To tell the truth, I was surprised too. The info in this article that I references is to the contrary of what we always say: Read Only Forward Only....

SAinCA,

this is so neat!

I too was going to reply that this is very useful for NUMBERS table for the use with matrix - like operations (read " Inside Microsoft SQL...

What about the other BOL article that says: "Dynamic cursors open faster than static or keyset-driven cursors" . All other recommendations in this article are to use the default settings...

All changes have to be tested together. There has to be only one QA environment for all who use it. It is called Integration Testing. And we are talking about...

This is an excellent article by itself and even better that it suggests alternative solutions by other authors. I will try them all.

When you need to do something quick, you...

As I replied to a presenter of SQL Server 7 "English Query" Feature about 10 year ago when he asked if I liked it: "Not sure. My Sequel (SQL) is...

Wildcat,

This is the problem!

The developers MUST have all their changes scripted and re-apply to the restored database

They have to have them scripted anyway to apply to Production at some point.

Slava,

You...

The easiest way to do it is to write a detach/attach or backup/restore script for all databases and use it. That is what our DBA is doing. She spent not...

Hello Mark,

Check the user's default language

I am getting these results when I switch the language for my login from English to German and back

Do not forget to disconent and re-connect...

Hello Sandhya

Please read this article, it explains the sequence of events for different Mirroring Operating Modes and scenarios.

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

Database Mirroring in SQL Server 2005