Comments
Sort by recent activity
Really!? "try again with an account with more permissions."
What permissions do you require? Have you not heard of the LUP principle? I am not going to give it SA privileges, tell me what it needs at a minimum to run.
Sorry to rant, you guys are smarter than this, I have spoken with many of you at PASS and SQL in the City events.
Here is what I have so far:
Ran the downloaded DLM Dashboard script
Created the SQL Login DLMAdmin;
GRANT EXEC ON dbo.RG_SQLLighthouse_WriteEvent TO DLMAdmin;
GRANT EXEC ON dbo.RG_SQLLighthouse_ReadEvents TO DLMAdmin;
GRANT EXEC ON dbo.RG_SQLLighthouse_WriteError TO DLMAdmin;
GRANT VIEW ANY DEFINITION TO [DLMAdmin]
Created the SQL USER DLMAdmin for the DLMAdmin login on the target database;
Does this sound correct or is that too much access? / comments
Really!? "try again with an account with more permissions."
What permissions do you require? Have you not heard of the LUP principle? I am not going to give it SA privileges, tell me what it needs...
Hi, I just ran into this same issue yesterday. It tried to recreate triggers on the table in the new schema before the ALTER SCHEMA statement. Moving it up also fixed my issue, but this seems like a bug.
Thanks,
Chris / comments
Hi, I just ran into this same issue yesterday. It tried to recreate triggers on the table in the new schema before the ALTER SCHEMA statement. Moving it up also fixed my issue, but this seems lik...
Aaron, I downloaded your 6.1.0.42 version and it does seem better for me so far. I turned off synonyms but did not see the option for partial matches. I will continue to test and monitor for future updates. / comments
Aaron, I downloaded your 6.1.0.42 version and it does seem better for me so far. I turned off synonyms but did not see the option for partial matches. I will continue to test and monitor for futu...
I am one of the slowest typers in our company and it can't even keep up with me. The other database developers that upgraded are really screaming or turning off/uninstalling it. Better do something or no one is going to want to renew the license next time. / comments
I am one of the slowest typers in our company and it can't even keep up with me. The other database developers that upgraded are really screaming or turning off/uninstalling it. Better do somethi...
Yes, I meant TDE, sorry aobut that, but I am not talking about SQL Backup. This is about the Compare products and we do not use SQL Backup. / comments
Yes, I meant TDE, sorry aobut that, but I am not talking about SQL Backup. This is about the Compare products and we do not use SQL Backup.
Thanks, that worked great.
You were correct, I had created the original repository against the database when it was still on 2005 and did not know about this attribute.
For others clarification what I found was the line:
<DatabaseVersion>9</DatabaseVersion>
and I changed it to
<DatabaseVersion>10</DatabaseVersion>
Besides the new data types that I was noticing, after the change and a new compare I also found that it was quietly ignoring filtered indexes we had added in 2008. I am glad to have this resolved before I had to rebuild from svn and lost those features.
Thanks for your help.
Chris Luttrell / comments
Thanks, that worked great.
You were correct, I had created the original repository against the database when it was still on 2005 and did not know about this attribute.
For others clarification wha...
Brian Donahue wrote:
I'm emailing you a new build of IronRuby generator. Extract it to your "Generators" folder - seems to work for me on v2.
Brian, any chance of posting this for others to use? Sounds like it worked great for tilo23.
Thanks, Chris / comments
Brian Donahue wrote:
I'm emailing you a new build of IronRuby generator. Extract it to your "Generators" folder - seems to work for me on v2.
Brian, any chance of posting this for others to use...
I just downloaded V3 last night. I will see if that clears it up.
Thanks,
Chris / comments
I just downloaded V3 last night. I will see if that clears it up.
Thanks,
Chris
I have also experienced a dramatic slowdown and seen that error message in the log. I am glad this fix has solved Rick's problems, I will email Paul for the link and hope it solves mine as well.
Thanks,
Chris / comments
I have also experienced a dramatic slowdown and seen that error message in the log. I am glad this fix has solved Rick's problems, I will email Paul for the link and hope it solves mine as well.
T...
Just to add my vote for this issue and let you know John is not the only one seeing this. We have a few hundred tables and aprox. 2000 procs in our database. Is this something that we are doing wrong or is this not going to work on larger databases like ours? / comments
Just to add my vote for this issue and let you know John is not the only one seeing this. We have a few hundred tables and aprox. 2000 procs in our database. Is this something that we are doing w...