840 reputation
820
bio website
location New York, NY
age 37
visits member for 3 years, 5 months
seen Jun 3 at 13:53

Apr
25
comment Hidden user rights
ok to test the public theory I created a new user assigned to the public role. logged into that user and attempted to create a table. The create table failed.
Apr
25
comment Hidden user rights
the user can create tables and temp tables yes. I'm not sure about the rights associated with the public role. I'll need to look them up.
Apr
25
comment Hidden user rights
Not using impersonation, No application roles defined. I ran both queries as sysadmin account and got the same results.
Apr
25
comment Hidden user rights
if it's helpful the login does not have any roles assigned to it either.
Apr
25
comment Hidden user rights
It is not a windows login. The user appears to be able to do this on all dtabases although I have been using a single database as my test case.
Apr
25
comment Hidden user rights
I've logged in as the sqlserver user that the apposes and yes username is returning the correct name. Query number 2 came back as a blank set and query number 3 gives me the name of one of our developers as the owner. Not the user that I'm troubleshooting.
Apr
25
comment Hidden user rights
the first query only came back with Connect Database. The second query came back with nothing. I tried running the revoke anyway but that didn't help. The user is still able to drop and create a table on the database.
Mar
6
comment incorrect value from SUM Function
@ypercube - Thanks. I'll read up and correct my ignorance.
Mar
6
comment incorrect value from SUM Function
@ypercube I don't understand. Why would a float data type all of a sudden cause sql to incorrectly add the values?
Feb
4
comment linked server hanging
Sorry I should have guessed that. It's something I hadn't thought to try but I can't take that db offline during regular hours. Thanks though.
Feb
4
comment linked server hanging
Unfortunately the linked server doesn't seam to like that command. I get an error: User does not have permission to alter database, the database does not exist, or the database is not in a state that allows access checks.
Feb
4
comment linked server hanging
+1 as that's an excellent reply unfortunately though not the answer. I have no msaccess processes open. I do a copy of the db down to my location which ensures the SQL Server is the only connection.
Jan
29
comment unclear SQL Server Issue
Maxdop is set to 6. The network admin said that he didn't see anything in the windows logs. I'll have to find the cluster logs. I'm not certain if those were checked.
Oct
1
comment select row data as column list
@AaronBertrand yeah sorry I'll get that up in a min
Jul
30
comment Need to understand parallel query execution error
Thank you. You've been a huge help.
Jul
29
comment Need to understand parallel query execution error
is there anything that would be indicative of a run awway query? Anything I can use to attempt to identify queries that are at risk of this?
Jul
29
comment Need to understand parallel query execution error
@Kin I thought that 0 ment that SQL Server managed how many threads it should be using. Why would this result in starveing SQL Server for thread resources?
Jul
29
comment Need to understand parallel query execution error
max worker threads Min = 128, max = 32767, config = 0, run = 0
Jul
29
comment Need to understand parallel query execution error
@Kin I have 12 processors (0 - 11) processors then two logical processor to NUMA Node map: entries Node 0, Node 1
Jul
29
comment Need to understand parallel query execution error
Max Degree of Parallelism is set to 0