SBSDiva Mobile : SQL Server

So you want to know what version of SQL you are running on SBS 2008

THE OFFICIAL BLOG OF THE SBS "DIVA" — Tue, 22 Sep 2009 05:05:00 GMT

So you want to know what version of SQL you are running on SBS 2008... run this query in your SQL management studio express... SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition'...(read more)

More tips for SQL 2008

THE OFFICIAL BLOG OF THE SBS "DIVA" — Sun, 29 Mar 2009 20:13:00 GMT

The Official SBS Blog : Requirements for Installing SQL 2008 Standard Edition for Small Business: http://blogs.technet.com/sbs/archive/2009/03/23/requirements-for-installing-sql-2008-standard-edition-for-small-business.aspx To follow up on this post,...(read more)

Top SQL issues from the Managed newsgroup

THE OFFICIAL BLOG OF THE SBS "DIVA" — Sat, 14 Feb 2009 05:23:00 GMT

Top issues from the managed newsgroup Partner Online Technical Support Communities Newsgroups: https://partner.microsoft.com/US/40014662 In this Issue: TOP SUPPORT ISSUES NEW & UPDATED KB ARTICLES NEW & TOP DOWNLOADS NEW WEBCASTS RECENT SUPPORT...(read more)

Top SQL issues this month

THE OFFICIAL BLOG OF THE SBS "DIVA" — Fri, 16 Jan 2009 03:29:00 GMT

In this Issue: TOP SUPPORT ISSUES NEW & UPDATED KB ARTICLES NEW & TOP DOWNLOADS NEW WEBCASTS RECENT SUPPORT ISSUES =================== Issue ---------- After you added a SQL Server 2008 to 2005 cluster, you encountered the following errors: 1...(read more)

How to troubleshoot SQL memory issues part II

THE OFFICIAL BLOG OF THE SBS "DIVA" — Fri, 16 Jan 2009 03:22:00 GMT

Part two of debugging SQL server issues.... from the Partner managed newsgroups. (There's good stuff in there) (II) *Internal Physical memory pressure: SQL Server detects high memory consumption internally, causing redistribution of memory between...(read more)

How to troubleshoot SQL server memory related issues (Part 1)

THE OFFICIAL BLOG OF THE SBS "DIVA" — Fri, 16 Jan 2009 03:19:00 GMT

From the Partner managed newsgroup: This section specifically addresses low memory conditions and ways to diagnose them as well as different memory errors, possible reasons for them, and ways to troubleshoot. Background It is quite common to refer to...(read more)

SQL Server 2008 Cumulative Update 1 is available

THE OFFICIAL BLOG OF THE SBS "DIVA" — Tue, 23 Sep 2008 19:45:00 GMT

Aaron Bertrand : SQL Server 2008 Cumulative Update 1 is available: http://sqlblog.com/blogs/aaron_bertrand/archive/2008/09/23/sql-server-2008-cumulative-update-1-is-available.aspx They just RTM'd SQL 2008 and already there's an update. And ya...(read more)

SQL information from the Partner newsgroups

THE OFFICIAL BLOG OF THE SBS "DIVA" — Tue, 09 Sep 2008 04:38:00 GMT

In this Issue: TOP SUPPORT ISSUES NEW & UPDATED KB ARTICLES NEW & TOP DOWNLOADS NEW WEBCASTS RECENT SUPPORT ISSUES =================== Issue ---------- When you tied to install security update 948109, you encountered the following error: Product...(read more)

MSDE a memory hog....

The Official Blog of the SBS "Diva" — Wed, 20 Feb 2008 03:12:00 GMT

MSDE a memory hog..... Who da thunk... not me .... Dear Susan Bradley, After extensive research and monitoring, it has been determined that the resource used by SQL express engine causes a dramatic performance decrease for the server. Futhermore, it creates...(read more)

Per my read...

The Official Blog of the SBS "Diva" — Sat, 05 Jan 2008 07:59:00 GMT

http://support.microsoft.com/lifecycle/?LN=en-us&p1=2852&x=4&y=8 SQL 2000 falls out of mainstream support in April of 2008. If your line of business vendor is still only supporting SQL 2000, sit them down and have a talk with them. Ask them...(read more)

Keepin' up with SQL

E-Bitz - SBS MVP the Official Blog of the SBS "Diva" — Tue, 18 Dec 2007 03:15:00 GMT

The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released: http://support.microsoft.com/kb/937137/LN/ I have no idea what build number I have of SQL 2005 to be honest with you...but I'm losing track of 'em...(read more)

Downgrade rights for SQL

E-Bitz - SBS MVP the Official Blog of the SBS "Diva" — Sat, 15 Sep 2007 01:38:00 GMT

How to downgrade to SQL Server 2000 on a computer that is running Windows SBS 2003 R2 Premium Edition: http://support.microsoft.com/?kbid=935573 Buried in yesterday's KB listing was that gem. Okay read it again.... you know what it means? I'll...(read more)

Detach/reattach revisited

E-Bitz - SBS MVP the Official Blog of the SBS "Diva" — Sat, 11 Aug 2007 21:45:00 GMT

http://msmvps.com/blogs/bradley/archive/2007/08/11/detach-and-reattach.aspx So Chad informs me that all that SQL command line stuff I was so proud of could have been all done via the GUI 'sure nuff. Detach and reattach via the GUI.... Now he tells...(read more)

Detach and reattach

E-Bitz - SBS MVP the Official Blog of the SBS "Diva" — Sat, 11 Aug 2007 16:26:00 GMT

So you need to move a SQL database 'eh? First off the trick is to "get" to that database with a management tool http://msmvps.com/blogs/bradley/archive/2007/06/12/connecting-to-the-wsus-database-with-sql-2005-s-tools.aspx If you don't...(read more)

I am such a SQL newbie it's not funny

E-Bitz - SBS MVP the Official Blog of the SBS "Diva" — Tue, 07 Aug 2007 05:59:00 GMT

When I go to check the mg_EmailQueue table it gives off an error and tells me to run DBCC CHECKTABLE. I am such a SQL newbie dweeb it's not funny... okay so reading this... http://msdn2.microsoft.com/en-us/library/ms174338.aspx What do I put as view...(read more)