Is it always object ID 7:1086626914:0 that suffers this issue ?

declare @ObjectRef varchar(128)

Set @ObjectRef = '7:1086626914:0'

Declare @DbId varchar(128)

Declare @ObjectId varchar(128)

Select @DbId = substring(@ObjectRef, 1, charindex(':',@ObjectRef)-1)

, @ObjectId = substring(@ObjectRef,...

parthi-1705 (1/27/2010)

This Time my problem is bit different

I am having a database with daily Full backup i did not put Translog backup for...

As you have seen I prefer these kind of "lookup" values in table rows.

If you really need the "original" parsed value, on top of the actual individual value, just extend...

I have the vast impression it must be something with this sqlinstance... the box should be able to cope with the threads without a problem.

Another thing is we are having...

any progress ?

Keep in mind HOW a between works with string values !!

Here's another way to get started ...

-- TEST IT -- TEST IT -- AND SEE WHAT IT DOES !!!

Declare @InputTable...

As always it depends ...

Partitioning only uses a single column to work on ...

If you aim to partition on one of the columns that currently composes your primary key ......

- removed because of stupidity - to early in the morning :hehe:

[Second Edit]

... after the furst cup of coffee :w00t:

Did you try this ?

/*

dd 20100128

http://www.sqlservercentral.com/Forums/Topic699260-1291-1.aspx

How can I create a temporary...

Good feedback.

OT : Keep in mind you should avoid running in lower edition db-level ! So switch to your engines dblevel whenever you can !

Well .... altough I cannot get the point of using a "don't know what status it is in, but it is not a known status" ....

This may be what you...

Don't use the identity property in your reference table !

Create a trigger for Insert and and use the inserted object to load your target table.

Keep in mind to do this...

Hi Barry, must have been "last day of the week syndrome" 😉

Off course I should have posted the used DDL.

As stated in my previous post, i tried to play with...

As Gail already stated, you should implement this trigger to be able to cope with more than one row in the inserted and/or deleted internal objects !

e.g

--TEST IT -- TEST...

That's very promissing towards the near future (post exit goodwill)...

You've been there for 6months, so you know your role/part.

Ask him how is day looks like, what he does when he comes to the office,

- what are/were his main...