Cheers Elliot , I have set the port numbers to be 7022 , rarther than 5022 which I think was the defaults.

Any thing else I could check ?

many thanks for quick reply.

We have intially performed a backup and restore to populate the test server.

I suppose my question should be what do recommend as a method for keeping Test and Live in...

Sorry , when I say Test I mean we have another SQL server set up for all our application testing before committing to live.

It will be table contents and table...

thanks for the quick reply , will give it a go

Well managed to sort this.

What we did was to re - run the index creation script on the said table. Following this we were able to add records via app...

many thanks Brian

Thanks II , will look into those ideas and let everyone know.

Thanks everyone , some good tips there.

Thanks Mike

Thanks Derek

Still a bit stuck with this. Set up alert as defined above . All set up alert to monitor 014 and 016 events.

Doing some testing I try to log...

Thanks everyone.

Hi , thanks for the reply.

What account are the SQL and SQL Agent services running under?

These are running both under the same domain account.

Also, are you using exchange

Not an expert...

Thanks Martin

Ran that during some testing on another server, not exactly sure what I am seeing.

Returns 3 rows.

1           

2 LPC        

3 Named Pipes

Do I need to check to see...

Many thanks for the replies everyone , would anyone be able to confirm that I have detailed the correct proceedure to disallow named pipes...