Browse by Tags
All Tags »
SQL Server (
RSS)
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'...
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,...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
I'm not a command line gal and I wanted to document that in order to use the SQL management studio included in SQL 2005 workgroup/R2 to do this , doing this didn't work. Instead as the comment said in the prior blog post, I have to use a pipe...
FIX: Event ID: 1 may be logged when you use a Volume Shadow Copy Service (VSS) writer to back up a snapshot in SQL Server 2005: http://support.microsoft.com/default.aspx?scid=kb;en-us;934396 Okay that's a slightly weird hotfix When I get a hotfix...
If you are running SBS standard and you want to control the SQL that comes with WSUS 3.0 the EXACT tool you need can be obtained from THIS link: http://go.microsoft.com/fwlink/?LinkId=65110 (Image courtesy of Handy Andy Goodman as I still haven't...
So you've seen this post but don't have OSQL on your system and you want to stomp on the memory of WSUS 3.0? So how do you do it in a GUI format? Now keep in mind these instructions are for Standard machines, not premium as I am blocked from downloading...
FIX: Event ID: 1 may be logged when you use a Volume Shadow Copy Service (VSS) writer to back up a snapshot in SQL Server 2005: http://support.microsoft.com/default.aspx?scid=kb;en-us;934396 If you are running a SBS 2003 box with SQL 2005 workgroup and...
More Posts
Next page »
![[There's a reason that Yoda is the unofficial mascot of SBS. Size indeed matters not.]](http://www.sbslinks.com/images/headertop.png "There's a reason that Yoda is the unofficial mascot of SBS. Size indeed matters not!")