Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thoron6
Starting Member
7 Posts |
 Posted - 2014-07-03 : 07:37:22
|
| Afternoon All, Apologies in advance as I am unable to post the script, however, I am running the exact same script as 4 other computers on the company network (two admins and one who has the exact same permissions as me), they are all getting the correct results and I am getting completely different figures. Any ideas at all would help as we don't have a clue? I thought it was permissions but that has now been ruled out. Maybe system settings? The script contains: SELECT USE CREATE UPDATE INSERT BEGIN and some group by. I don't believe it's the code as we are all using the same one. Thank you in advance! |
|
|
stepson
Aged Yak Warrior
545 Posts |
Posted - 2014-07-03 : 07:56:40
|
| Hi,Probably you are connected to another DB (DEv/OA DB), if you are running the same script. You are running from SSMS ? or running from a client application?First think I will do , is to see what is send to DB (start a trace and see what is send to DB)sabinWeb MCP |
 |
|
|
thoron6
Starting Member
7 Posts |
Posted - 2014-07-03 : 08:02:17
|
| Hi,I am running from SSMS and have double checked the DB I'm running from. They all match the other users? |
|
|
|
stepson
Aged Yak Warrior
545 Posts |
Posted - 2014-07-03 : 08:18:13
|
| Any triggers define?I will add some PRINT statement, to be sure that is touch ,is enter every blocksabinWeb MCP |
|
|
|
AApraveen
Starting Member
1 Post |
Posted - 2014-07-03 : 08:20:03
|
| My name is praveen chandra. In 2004, I started a commercial real estate company which acquires, develops and manages single and multi-tenant commercial buildings. We own and operate multiple building across Southern California.http://www.pinterest.com/Praveenchandras/pins/[url][/url] |
|
|
|
thoron6
Starting Member
7 Posts |
Posted - 2014-07-03 : 09:05:26
|
| No triggers in the code, no |
|
|
|
stepson
Aged Yak Warrior
545 Posts |
Posted - 2014-07-04 : 00:48:53
|
| With out seeing the code , I have no more idees.Maybe someOne else have another idee.sabinWeb MCP |
|
|
|
|
|
|
|
|
Same code, different results