Can you suggest a template for the profiler or which events would be most useful to capture.

Cheers

That's interesting to hear, the trigger is updating the same table that its attached too. So i'm not sure that is the problem, unless it builds the trigger first and...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TRIGGER [dbo].[trg_TableAIdentity]

ON [dbo].[TableA]

AFTER INSERT

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering...

Master stroke

Thank you so much 🙂

Cheers Noel, i've managed to find out what was the problem but this would had make it a whole lots quicker 🙂

Yes we moved the DB from a sql2000 environment to SQL2005. I have to admit i'm a little lost to what to do to either re-enable the Full-text or disable...

Cheers dude for sending me that link i now know what it is offline. Only problem is i don't know what it is or how to make it online

DB1_DataD:\MSSQL\DATA\DB1.mdfONLINE

Db1_LogD:\MSSQL\DATA\DB1.ldfONLINE

sysft_Db1D:\MSSQL\FT\DB1 ...

Cool thanks, thou I've just found out that views can not contain aggregates functions or Group by 🙁

So looks like it back to the drawing board for me.

Thanks for all...

hehe found the answer with a bit of digging, but for those who want to know

sp_configure 'max text repl size',

Cheers

Sweet very cool 😀

Thanks for the heads up 🙂

Thanks heaps Steve, i really wanna understand all the pros and cons from peoples experiences 🙂

Cheers thanks for that. If i use mirroring and the primary server goes down can the backup act as the primary, maintaining identify fields so that once the primary is...

Cheers for that, and yeah i've decided to use identity range for the tables, thanks again 🙂

Cheers guys for all the replies and you were all right it was down to a permissions issue, i was using EncryptSensitiveWithUserKey for the dtsx package.

Which as you know,...