Browse by Tags

Sorry, but there are no more tags available to filter with.

Change SQL Server Instance Name

After looking around a lot, I found this article that is really accurate, when you changed the server name, and not the SQL Server Instance name... http://www.coderjournal.com/2008/02/how-to-change-instance-name-of-sql-server/ -f.

Posted to Frederick Chapleau weBlog on IT. (Weblog) by Frederick.Chapleau on 07-20-2009
cannot generate sspi context. .net sqlclient data provider

I had this, and found a lot of posts for it... here is an other “simple” solution: change de provider name to Named Pipe, it this case the SSPI context is generating correctly. -f.

Posted to Frederick Chapleau weBlog on IT. (Weblog) by Frederick.Chapleau on 07-08-2009
Deleting without generating log entries in log files

10000 rows at a time. DECLARE @i INT SET @i = 1 SET ROWCOUNT 10000 WHILE @i <> 0 BEGIN DELETE FROM dbo. table SELECT @i = @@ROWCOUNT END SET ROWCOUNT 0 -f.

Posted to Frederick Chapleau weBlog on IT. (Weblog) by Frederick.Chapleau on 06-24-2009
Random error on ReportServer

w3wp!processing!5!03/27/2009-15:24:24:: a ASSERT: Assertion failed! Call stack: Microsoft.ReportingServices.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs...

Posted to Frederick Chapleau weBlog on IT. (Weblog) by Frederick.Chapleau on 03-27-2009
Truncating all databases at Once

I already posted a way to truncate log, so that they do not grow indefinitly. Here a little routine found on the Mark Brown's Blog. A generic way to truncate all the log files. See the disclaimer it's important. http://blogs.msdn.com/mab/archive/2008/01/26/how-to-backup-and-truncate-all-log-files...

Posted to Frederick Chapleau weBlog on IT. (Weblog) by Frederick.Chapleau on 10-15-2008
Great Article about cursors

SQL Server - SQL Example about cursors http://jackdonnell.com/articles/SQL_CURSOR.htm -f.

Posted to Frederick Chapleau weBlog on IT. (Weblog) by Frederick.Chapleau on 02-09-2008
Enable SQL Server Authentication

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer LoginMode =2 ... and restart the service. -f.

Posted to Frederick Chapleau weBlog on IT. (Weblog) by Frederick.Chapleau on 12-20-2007
SQL Server 2000 replication Issue

To troubleshoot a replication scenario that had a replication error 18773, The process could not execute 'sp_replcmds' on 'SERVER'. After profiling the database, and re-executing the statements, I had this problem... Could not locate text information records for column 1 during command construction....

Posted to Frederick Chapleau weBlog on IT. (Weblog) by Frederick.Chapleau on 05-03-2007
During upgrade, database raised exception 211

I had... During upgrade, database raised exception 211, severity 23, state 46, address 019C646E. Use the exception number to determine the cause. The cause was pretty dark, so to diagnose, I tried to restore the database using the hard way . The result was... a success (why the restore database is not...

Posted to Frederick Chapleau weBlog on IT. (Weblog) by Frederick.Chapleau on 04-26-2007

Page 1 of 1 (9 items)