Viewing 10 posts - 1 through 10 (of 10 total)
Greg Edwards-268690 (4/12/2016)
Since the test user was given only access to 1 object, maybe it is a bug.
Under his own ID, does he have access to more than just the...
April 12, 2016 at 11:17 am
Lynn Pettis (4/11/2016)
Is there a procedure named GO?
No....I am able to put GO after the select statement and it runs with no errors. It is only when it is...
April 11, 2016 at 2:57 pm
Eirikur Eiriksson (4/11/2016)
Are there any tables or views outside the Reporting schema directly or indirectly referenced in the query that's failing? The error message referred to one Stats schema.😎
I am...
April 11, 2016 at 2:46 pm
SQLRNNR (4/11/2016)
April 11, 2016 at 2:13 pm
Eirikur Eiriksson (4/11/2016)
Quick questions, which objects in db CmsTestDB schema Stats are used?
I do not understand this question. Under the DB CmsTestDB, there are multiple tables in multiple...
April 11, 2016 at 2:06 pm
Phil Parkin (4/11/2016)
Very strange indeed.Try this one:
GO 3SELECT
FROM [Reporting].[WorksheetReporting]
Do you see the error once or three times?
Ok...I tried running it, I only see the error 1 time....
April 11, 2016 at 1:47 pm
Ed Wagner (4/11/2016)
I know this is really reaching, but I'm going to ask anyway because the error makes no...
April 11, 2016 at 1:21 pm
I tried the following:
For this code block:
Phil Parkin (4/11/2016)
If you run just these statements, do you still see the error?
USE [CmsTestDB]GO
The above query runs with no errors.
And as to this...
April 11, 2016 at 1:17 pm
Thank you,
I am not in a dorm-like situation (and it appears that is very good that I am not). I have complete control over my database, I however do...
April 11, 2016 at 11:07 am
I will try. I mostly use the UI, so some of the scripts below are after I created it with the UI I then just generated scripts.
Generate Tables:
******...
April 4, 2016 at 2:02 pm
Viewing 10 posts - 1 through 10 (of 10 total)