865 reputation
1223
bio website
location New York, NY
age 38
visits member for 4 years, 1 month
seen Mar 4 at 20:43

Dec
3
comment User already exists error
Thank you. I need to talk with the company owners and the director of development to see if this will work. Are there any security pitfalls to scripting this as a backup and restore?
Dec
3
accepted User already exists error
Dec
1
asked User already exists error
Nov
6
comment How do I automatically grant all privileges to a schema created by a user in mysql?
so you have a user who has permissions in schema a. but is creating objects in schema b? Or does your user only have permissions to a specific set of objects?
Nov
6
answered Optimizing SSIS Packages
Oct
11
comment Auto Script DB Objects for SVN
looks like I need to learn powershell. Thanks.
Oct
11
accepted Auto Script DB Objects for SVN
Oct
11
comment Auto Script DB Objects for SVN
Can Generateing scripts like that be automated as a job?
Oct
11
comment Auto Script DB Objects for SVN
Honestly there are several workflows that I think could work for us. However I'd like to regain the time that is used up in managing these files if at all possible. Especially now because were doing a lot of database design work. so there is a lot of script changing right now.
Oct
11
asked Auto Script DB Objects for SVN
Oct
9
accepted Security Question involving Sys tables
Oct
9
asked Security Question involving Sys tables
Oct
4
accepted User can't see database in SQL Server 2008 R2
Oct
4
awarded  Analytical
Oct
4
accepted SQL Log Shipping Firewall settings
Oct
4
answered SQL Log Shipping Firewall settings
Oct
4
answered User can alter procedures without permission
Oct
3
comment User can alter procedures without permission
Aaron thanks for the hand. fn_my_permissions returned an empty record set. The select query returned db_datareader and db_datawriter. They haven't been granted db_owner that I'm aware of and I'm not running any custom roles.
Oct
3
asked User can alter procedures without permission
Sep
26
answered linking databases for reporting