March 24, 2010 at 8:37 pm
The application code generates the full path of a table it will be cross referencing in the server: servername.dbname.ownername.tablename>. But when it comes to SQL server engine, it comes as ...tablename, and fails. Nothing else had changed in the code or in the database/server in the past 2 months, and this has been happening for the past 4 days. Is this anything related to permissions? (again, nothing has changed) :hehe:
Any other thoughts?
Dan.
March 24, 2010 at 8:55 pm
If the servername, databasename, and schema are no longer present in the query being sent, then something has changed in the application. I would check again.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 27, 2010 at 2:33 pm
repent_kog_is_near (3/24/2010)
The application code generates the full path of a table it will be cross referencing in the server: servername.dbname.ownername.tablename>. But when it comes to SQL server engine, it comes as ...tablename, and fails...
How do you know what the application is passing and what the server is receiving?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 27, 2010 at 3:53 pm
very interesting.. Here is the challenge to find out what changes could have been done at application side.. definitely its not related to SQL Server settings.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply