Clive,

Thanks for your reply. I have tried it, and althought it executed without error, the file size remained the same. I tried it on another db, and it...

Thanks, I appreciate it

Hi,

Sorry for delay, I had already left the office when your reply was posted.

The tale which comtains the four FKs is called TableColumnDisplay - related to TableColumn.

I have pasted all...

Good article, as I am not a production DBA, and find the plethora of tools really confusing.

Does the wizard only do complete backups? Should I use this...

Hi,

Thanks for speedy reply.

I ran the script and I still got errors. I then ran it another three times, and eventually all of the FKS were renamed. (4 is...

You hesitate to give your husband datawriter permissions on the family planner.

Thanks Andy, I am going to give it a go. I also found this posted by: Arvind Krishnan SQL Server Support Microsoft Corporation

on google:

"In SQL Server 2000, multiple...

It seems to work sometimes. Which makes me think that the SPID returned is different to that which I am capturing at the point of connection. But to...

I am pretty sure that the trigger is OK, As when I set @userid to 'somestring', he trigger fred prtfrctly everytime. I am just wondering...

I have added the where clause, which is obviously esential. However, it hasn't fixed my problem. At the moment I am the only one using the db so...

DOHHHHH!!!! Thanks, I knew I would end up feeling like a numbnut!!

Andy,

I am soo sorry for not replying, my ISP went down, and then I was OOB.

Here is the generated code:

BEGIN TRANSACTION

SET QUOTED_IDENTIFIER ON

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

COMMIT

BEGIN TRANSACTION

EXECUTE...

hi,

I used OLAP some time ago, but not in SQLServer. the product was bought by Oracle a few years back. I worked in a Direct Marketing Co, and...

Thanks Andy,

The article was very useful. I think DMO is great for certain tasks, like creating metadata,triggers and other administrative tasks. What I don't think is very useful...

The generic subs and routines remain the same, but I have rewritten the bit to drop & recreate the audit triggers, as the triggers are now diferent. This...