July 28, 2014 at 10:53 am
SQL Server 2008 R2
I opened one of my Stored Procedures today to find a long list of statements like the one below appended to the bottom of it.
I created a new SP with one statment (Select * from a small table) saved it, closed everything. When I opened it back up it too had the statements. Of course I haven't knowingly changed any settings but there's only one other person who works in this db and I can't reach her for a few days. I'm the suspect. :ermm:
Any help would be appreciated. The statements look like this and appear to be one for every table in the (small) db.
[highlight=""]ALTER TABLE [dbo].[tblLot] CHECK CONSTRAINT [FK_tblLot_tblLocation]
GO[/highlight]
8/14/2014 Editing this to say that today I reinstalled SQL and the tools on my laptop and that did not solve the problem. The other programmer does not see these added lines of code when she opens a SP. Any help would be greatly appreciated. I'm stuck as to how to identify the source of the problem.
July 29, 2014 at 9:40 am
The other person who works in this data base does not see this when she opens the procs. I think I may have changed something on my workstation in SQL Server Management Studio Tools-Options, but I can't find anything I want to touch. Can anyone help? Thanks.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply