Reputation
686
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 19 37
Newest
 Caucus
Impact
~169k people reached

  • 0 posts edited
  • 2 helpful flags
  • 47 votes cast
3h
accepted When does SSIS SQL Server Configuration write to the configuration table?
4h
asked When does SSIS SQL Server Configuration write to the configuration table?
4h
comment Introduce or not introduce SSIS to an ETL project
@dezso To make it work better, faster, more efficient. Make it easier to maintain or modify in the future.
Jul
27
awarded  Caucus
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