Here is the quick script I use find last backup time for all the database in my server instance.
SQL SERVER – Fix: Error: MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode.
I recently got email from blog reader with following error. MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode. The fix of the same is very easy. Fix/Workaround/Resolution: sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Ad Hoc…
Read MoreSQL SERVER – Are you a Database Administrator or a Database Developer?
This blog post is written in response to T-SQL Tuesday hosted by Paul Randal. I think following questions has been always very interesting question for everybody who is working with SQL Server. Are you a Database Administrator or Database Developer? The answer of this question varies from organizations to organizations…
Read MoreSQLAuthority News – 4th Birthday of Blog – 20 Million Views – Blog Anniversary – A Milestone
Today is Nov 1, 2010. Four years ago, on the same day of the year 2006, Â I wrote my first blog without thinking or even understanding where this blog was going to. The reason I started blogging was very simple- I just wanted to keep a note of what I…
Read MoreSQLAuthority News – New Banner of Blog
As this blog is approaching 4th anniversary, I have decided to change few things in this blog. I have finally decided to change the blog banner and I have created internal poll for the blog banner. I have uploaded the winning banner as the title of the blog and I…
Read MoreSQL SERVER – Minimum Maximum Memory – Server Memory Options
I was recently reading about SQL Server Memory Options over here. While reading this one line really caught my attention is minimum value allowed for maximum memory options. The default setting for min server memory is 0, and the default setting for max server memory is 2147483647. The minimum amount…
Read More
SQL SERVER – List of all the Views from Database
My earlier article SQL SERVER – The Limitations of the Views – Eleven and more… has lots of popularity and I have been asked many questions on the view. Many emails I received suggesting that they have hundreds of the view and now have no clue what is going on and how many of them have indexes and how many does not have an index. Some even asked me if there is any way they can get a list of the views with the property of Index along with it.