I think our infrastructure team just did a "repair" installation to fix it. Not a nice solution but it worked :-D.

Regards,

Jan

Hi,

no cluster, its an Microsoft SQL Server Enterprise Edition (64-bit) Server with 3 named instances.

Regards,

Jan

Hi,

I know its a very old posting, but we are having the same issue since today, so did you ever work out?

Regards,

Jan

Hi,

have you been able to create system.web assembly in SQL2005? I'm always getting this error (looks like it references itself):

Warning: The Microsoft .Net frameworks assembly 'system.web, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=x86.'...

Hi Jonathan,

what I want to do is easy: I will have a staging table with parameters, and I have to run a stored procedure with each of them. My assembly...

Hi,

I tested this 6 months ago, I had to import 12 files into the same destination but different tables. Running these in paralell on a 8 core machine with 16GB...

Hi,

this worked a few months ago on my side:

/*

--1. step, repair

ALTER DATABASE kaputtDB SET EMERGENCY

ALTER DATABASE kaputtDB SET SINGLE_USER

DBCC CHECKDB (kaputtDB, REPAIR_ALLOW_DATA_LOSS)

*/

/*

--2. activate db

ALTER DATABASE kaputtDB SET Online

ALTER DATABASE kaputtDB...

Hi,

this is what we use to start a package without having a job:

create PROCEDURE [dbo].[proc_execute_ssis]

-- Add the parameters for the stored procedure here

@date varchar(10) = NULL,

@path varchar(255) = NULL,

@filename...

Hi,

thanks for post, it is exactly the information I was looking for.

Best Regards,

Jan

Jacob Luebbers (4/9/2008)

---

The same is true (though to a lesser extent) with any of the algorithms supported by HashBytes(). There is no guarantee that two of your rows that...

I tried using checksum at first, but this doesn't work. In some cases checksum for two rows is the same although they differ in one column. This happenend on my...

Hi,

I'm using the hashbytes function of SQL Server 2005, this is a example:

hashbytes('md5', isnull([column_1], '') + isnull([column_2], '') + ...)

There are a few things you need to know to get...

Hi,

this is what I build to check replication state. 99% of our replication failures are caused by an missing initial snapshot, so this procedure just checks if there is a...

Hi,

I need to import 900k rows with 210 columns each out of a text file. As this file contains the whole data, not only changed data I need to check...

Hi Mikelyn,

it's not exactly what I'm looking for, but as I now know the associated tables and views I can build a check.

Thank you very much.

Regards,

Jan