Reputation
935
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 14 27
Impact
~102k people reached

  • 0 posts edited
  • 0 helpful flags
  • 32 votes cast
May
22
comment Backup Restore Procedure error SQL Server 2008 R2
@AaronBertrand - well in the original the file paths are passed in as NVarchar variables so.... No. No quotes. However, I suspect I should have put them in for my example. sorry about that.
May
22
comment Backup Restore Procedure error SQL Server 2008 R2
@RLF - We are running SP2. Version number 10.50.4000.0 (x64)
May
22
comment Backup Restore Procedure error SQL Server 2008 R2
@AaronBertrand - I've added a print of the sql that is created as reqyested.
May
22
revised Backup Restore Procedure error SQL Server 2008 R2
added 408 characters in body
May
22
comment Backup Restore Procedure error SQL Server 2008 R2
Nope. Only one mdf and only one ldf file.
May
22
asked Backup Restore Procedure error SQL Server 2008 R2
Apr
25
comment Hidden user rights
That query returns nothing as well.
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.
Apr
24
asked Hidden user rights
Apr
16
awarded  Popular Question
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?
Mar
6
asked incorrect value from SUM Function
Mar
1
awarded  Yearling