Reputation
669
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 19 36
Impact
~158k people reached

  • 0 posts edited
  • 1 helpful flag
  • 43 votes cast
Jun
13
awarded  Popular Question
Jun
12
comment Restricted user on my local SQL Server database?
I right clicked on the SSMS icon and then "Run as Administrator". Then logged in to .\SQLEXPRESS using win. authent. Under Security>Logins I double clicked on the BUILTIN\Users login and tried adding it to the sysadmin server role but got an error saying "Add member failed for ServerRole 'sysadmin' User does not have permission to perform this action." I also created a login with my Domain\Username but I also get the same error message when I try to add it to the sysadmin server role. Even though I am running SSMS as Administrator like u mentioned I am not Admin on my PC cld that be issue?
Jun
12
comment Restricted user on my local SQL Server database?
Thank you, so basically I will need to do a default installation of SQL Server before following the steps you suggested right? In other words with the SQL EXPRESS installation I currently have I will not be able to create databases right?
Jun
12
accepted Restricted user on my local SQL Server database?
Jun
11
asked Restricted user on my local SQL Server database?
Jun
11
accepted SSIS keeps force changing excel source string to float
May
29
awarded  Notable Question
May
4
awarded  Notable Question
Apr
15
comment SQL Server Isnull Returning 1900-01-01 when field is null
Got it, thanks for the clarification.
Apr
13
awarded  Popular Question
Mar
13
awarded  Yearling
Feb
25
awarded  Notable Question
Feb
13
awarded  Notable Question
Jan
22
comment SQL Server Isnull Returning 1900-01-01 when field is null
it's a varchar data type that I am converting to date
Jan
22
comment SQL Server Isnull Returning 1900-01-01 when field is null
Makes sense. So what I am seeing is that basically a NULL date is equivalent to 1900-01-01 (in this particular situation with the way the ISNULL function handles dates). Thanks.
Jan
22
accepted SQL Server Isnull Returning 1900-01-01 when field is null
Jan
22
revised SQL Server Isnull Returning 1900-01-01 when field is null
added 31 characters in body; edited title
Jan
22
asked SQL Server Isnull Returning 1900-01-01 when field is null
Jan
15
awarded  Notable Question
Dec
31
awarded  Popular Question