I was trying to use a conditional split to filter out data based on a timestamp column for Getdate()-3 and I am getting this error.

The data type "DT_DBTIMESTAMP" cannot be...

I also faced a requirement today similar to what you had... and I was successful in implementing all the ideas I told and the url on how to use FOR...

The issue is because of data in the tables. Identified the bad data and deleted it and created the foreign key and it got created without error.

Table A was:

CREATE TABLE [dbo].[Workspaces](

[WorkspaceId] [uniqueidentifier] NOT NULL,

[Name] [nvarchar](50) NOT NULL,

[IsMultiLanguage] [bit] NOT NULL,

[IsMultiUseCase] [bit] NOT NULL,

[IsAllowAlternateMapStrings] [bit] NOT NULL,

[AccountId] [uniqueidentifier] NULL,

CONSTRAINT [PK_Workspaces] PRIMARY KEY CLUSTERED

(

[WorkspaceId] ASC

)WITH (PAD_INDEX...

Will be thankful if you can shed some light on me.

Yes... You are right... its waiting on a key to stop the console...is there anything that can be done to stop the console at the registry level while the console...

I am able to open the blg file on my system normally.

No Problem. I have DDL Triggers in place now.

Thanks.

Thanks for the urls. I will run the profiler with events mentioned in your blog and check.

Thanks for the response Gail.

At this point of time the recompilation is not the issue but since it is adding overhead on memory I was looking at them. Also I...

Oops you are right...I was off track for sometime...I changed the isolation level to RCSI not only to prevent the concurrency issues but also to prevent dirty reads.

Thanks Gail

Can you please advise.

Hey Guys..I have a quick question here..Looking at my deadlock graph and the isolationlevel being serializable which query is using the isolation level as serializable? the update or select? per...

Check if DB Shrink is part of your backup maintenance plans or anyother.

Yes. I am currently stuck and had a discussion with the developers on the change in isolation level.

Thanks Gail and Michael.