3,929 reputation
11428
bio website
location
age
visits member for 3 years, 1 month
seen Dec 5 at 15:15

Huge fan of SQL Server, I've been searching for opportunities to work on more MSSQL projects which is why I'm here.

I have been working in mixed environments with a combination of MySQL, PostgreSQL, LDAP and SQL Server for the past 15 years.


Dec
9
awarded  Popular Question
Dec
8
awarded  Notable Question
Dec
1
comment Dropping a table with powershell
Awesome, thank you JNK
Dec
1
accepted Dropping a table with powershell
Dec
1
comment Dropping a table with powershell
Hi Kin, no I haven't. The DROP works fine if I execute right after a create. But all by itself, it fails. I don't think its an issue with the naming. Besides, it's adding .dbo. all by itself, if you look at the error.
Dec
1
asked Dropping a table with powershell
Nov
25
accepted How to save and then restore permissions after refreshing a database
Nov
25
comment How to save and then restore permissions after refreshing a database
hello Kenneth, the script does what I need, thank you again for your answer.
Nov
24
comment How to save and then restore permissions after refreshing a database
Thank you, I am checking out the script now.
Nov
24
comment How to save and then restore permissions after refreshing a database
Hello @RemusRusanu, that is definitely doable, but to start, I need to be able to at least store what's currently there.
Nov
24
revised How to save and then restore permissions after refreshing a database
edited title
Nov
24
revised How to save and then restore permissions after refreshing a database
added 152 characters in body
Nov
24
asked How to save and then restore permissions after refreshing a database
Nov
24
comment Verify if user has read access to a table
Hello Paul. One question, how does this answer take into account database and server role permissions?
Nov
23
awarded  Yearling
Nov
21
comment How can I check for stored procedure consistency across multiples servers
Hello, yeah my pleasure. Been using your software for about a year. Kankuru is épatant!!
Nov
21
revised How can I check for stored procedure consistency across multiples servers
added 81 characters in body
Nov
21
comment How can I check for stored procedure consistency across multiples servers
Hello @aasim.abdullah, I updated my answer with some configuration information
Nov
21
revised How can I check for stored procedure consistency across multiples servers
added 611 characters in body
Nov
21
revised How can I check for stored procedure consistency across multiples servers
added 12 characters in body