Welcome to MSDN Blogs Sign in | Join | Help

November 2009 - Posts

Friday, November 20, 2009 10:03 PM

Unable to run SQL CLR procedure with System.Security.SecurityException

Recently, we have troubleshoot a customer issue related to SQL CLR. The problem is that the assembly is configured to use external_access but he kept getting an exception similar to this (this is a sample call stack): Msg 6522, Level 16, State 1, Procedure
Posted by psssql | 0 Comments
Filed under:
Friday, November 20, 2009 7:04 PM

SQL Server 2005 Cumulative Update or GDR fails when trying to rename the mssqlsystemresource files

I’ve seen a few customers run in to this recently when the resource database is in a different location than the master database.  A cumulate update or GDR for SQL Server 2005 may fail with the following for the SQL Server Database Services 2005
Posted by psssql | 1 Comments
Tuesday, November 17, 2009 9:35 PM

How It Works: Controlling SQL Server memory dumps

I just completed a lengthy bit of research and thought I would share it with everyone.   There are several trace flags and registry keys outlined in this post.    !!! As always USE WITH APPROPRIATE CAUTION !!!   From: Robert
Posted by psssql | 0 Comments
Friday, November 13, 2009 5:02 PM

How It Works: How many databases can be backed up simultaneously?

Previously I have posted details on backup/restore designs and how to tell what backup/restore is doing. http://blogs.msdn.com/psssql/archive/2009/03/03/how-it-works-sql-server-vdi-vss-backup-resources.aspx http://blogs.msdn.com/psssql/archive/2008/01/28/how-it-works-sql-server-backup-buffer-exchange-a-vdi-focus.aspx
Posted by psssql | 0 Comments
Filed under: , , ,
Tuesday, November 03, 2009 5:56 AM

The SQL Server Wait Type Repository…

As part of my talk at the 2009 US PASS Summit here in Seattle called Inside SQL Server Wait Types , I’m creating this blog post as a reference point that can be used to find out information about wait types in SQL Server 2005 and 2008.  My hope is
Posted by psssql | 3 Comments
 
Page view tracker