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 |
|
vigneshprabu82
Starting Member
6 Posts |
 Posted - 2015-03-17 : 12:18:52
|
| Hello,The sql server admin says I have all the proper access to the DB. When I login using the management studio, I am able to connect to the server, DB and see the tables. But when I run any query, it does not retrieve any data. What are the possible fix for that? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
vigneshprabu82
Starting Member
6 Posts |
Posted - 2015-03-17 : 12:31:36
|
This is just a sample query but it doesn't retrieve any data for any of the other query as well. I suppose its something to do with my access. I would like to understand if I have access to the DB and the tables but still not retrieving any data, what additional access am I missing?SELECT TOP 1000 [USERID] ,[MANUFACTUREORDERST_I] ,[MANORDERSTART_I] ,[MANORDEREND_I] ,[STTITNUM] ,[ENITMNBR] ,[STRTDATE] ,[ENDDATE] ,[STTLOCCD] ,[ENLOCNCD] ,[STRTRTNGNM] ,[ENDRTNGNM] ,[STARTBOMCAT] ,[ENDBOMCAT] ,[STARTBOMNAME] ,[ENDBOMNAME] ,[EXCLDMOSTATUS_1] ,[EXCLDMOSTATUS_2] ,[EXCLDMOSTATUS_3] ,[EXCLDMOSTATUS_4] ,[EXCLDMOSTATUS_5] ,[EXCLDMOSTATUS_6] ,[EXCLDMOSTATUS_7] ,[PSTGDATE] ,[COMPLETECLOSEDATE] ,[COMPCALCOPTION] ,[SHOWMRPORDERS] ,[STARTPLANNERID] ,[ENDPLANNERID] ,[DEX_ROW_ID] FROM [CISCO].[dbo].[MOP1070]quote:
Originally posted by tkizer
Show us the query.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
|
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-17 : 13:15:17
|
| Is the query completing? I would be suspicous of it still running and you were just impatient for the results. If you didn't have access, it would return an error.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
vigneshprabu82
Starting Member
6 Posts |
Posted - 2015-03-17 : 13:59:21
|
| It says Query executed successfully. 0 rows affected. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-17 : 14:03:58
|
| I would check with your DBA then. Something weird is going on. Perhaps [CISCO].[dbo].[MOP1070] is a view with some weird logic.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
|
|
Not able to retreive any data