Hi,

Thanks for the update. I'm glad to hear the issue is resolved.

Regards,

John Marsh

Hello,

It sound like it could be a permissions issue to me as well. Can you check which account the SQL Agent runs under? (Via Computer Management --> Services node)

Can you...

Hello,

I would expect this kind of error message if the referenced columns do not exist in the tables.

In particular check the (permanent) table "tbl_stdclient" - Is there definitely a...

My post was in reply to Jerry's last post, not yours.

Hi Jerry,

Thanks for the update. I'm glad to hear your problems are solved now.

Regards,

John

Hi Jerry,

I'm hoping your SQL Server is fairly quiet, otherwise you have to filter the results of the profile to find what you are looking for.

If you already have SSMS...

Hello,

For the manual insert, the T57777 needs to be enclosed in single quotes i.e.

Insert into dbo.Equipment (EquipmentNumber, ProjectID, DrawingID)

Values ('T57777',18,NULL)

It is difficult to tell what is going wrong with the...

Hello,

You are right in thinking Nulls should be allowed in FK fields, which is why I am thinking that may be the Front End Application is trying to write (something...

Hello,

Do you get any related error message? What data access technology is the Front End Application using e.g.ADO.Net? Is there any possibility that the application is trying to write an...

Hello,

Thanks for the update. It is always good to hear when an issue has been resolved.

Best regards,

John Marsh

Hello,

I believe the SNAC referred to in the error messages is the SQL Server Native Client. Did you already have any versions of MS SQL on the target server e.g....

Hello,

I would not expect this to cause any problems. The SP(?) will take up slightly more Server memory when executing.

If the variables are not used anywhere in the code then...

Hello,

It sounds like the SP has been created with the Encryption option.

What does sp_HelpText return for the SP?

If the definition is encrypted then you drop and re-create the SP (without...

Has View Definition of the SP been explicitly denied?

Hello,

These Role memberships do not include the rights to modify DB objects such as SPs.

Membership of the db_ddladmin or db_owner roles would grant sufficient rights, or you can grant the...