Browse by Tags
All Tags »
SQL Server (
RSS)
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 »