Reputation
718
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 21 38
Impact
~179k people reached

  • 0 posts edited
  • 2 helpful flags
  • 48 votes cast
Aug
24
awarded  Nice Question
Aug
20
accepted SSIS File System Task (Copy File Operation) OverWriteDestination functionality
Aug
20
asked SSIS File System Task (Copy File Operation) OverWriteDestination functionality
Aug
11
comment SSRS Report drop down parameters. Use SP or embeded SQL query for datasource?
I was wondering more if there was an existing generally accepted standard or best practices way of populating the values of a dropdown parameter in SSRS (SP vs embedded query). Pros and Cons of using 1 method vs the other.
Aug
10
asked SSRS Report drop down parameters. Use SP or embeded SQL query for datasource?
Aug
5
accepted SSIS Update (Replace) record instead of append based on Primary Key
Aug
5
answered SSIS Update (Replace) record instead of append based on Primary Key
Aug
4
awarded  Constituent
Aug
1
awarded  Inquisitive
Jul
31
asked SSIS Update (Replace) record instead of append based on Primary Key
Jul
30
accepted When does SSIS SQL Server Configuration write to the configuration table?
Jul
30
asked When does SSIS SQL Server Configuration write to the configuration table?
Jul
30
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