Comments
Sort by recent activity
Many thanks for that tip. Use my full size database, this test is taking 15 mintues on the development box, and 58 minutes on the live box. It's as I feared - the SAN disk is 4 times slower than the SCSI array.
The sqlBackup even gave me throughput measurements.
thanks again.
Pete Cousins. / comments
Many thanks for that tip. Use my full size database, this test is taking 15 mintues on the development box, and 58 minutes on the live box. It's as I feared - the SAN disk is 4 times slower than th...
Thanks for your post. Even dev and test have different permissions. I've tried creating a local group on the SQL server, and adding that to the DB role, thinking that would give a level of abstraction, but SQL includes the server name with the local group name.
At the moment I'm excluding the definition of the database role from Source Control, but including the permissions granted to the role on table definitions etc. Just need to make sure the role is in each environment before code is deployed.
It gets a bit confusing as SQL compare picks up the role when I do deployments, so I have to actually read the screen and check the right objects before deploying. Wouldn't it be nice just to be able to do a quick check and click 'deploy'. Can objects be excluded from the compare?
Pete Cousins / comments
Thanks for your post. Even dev and test have different permissions. I've tried creating a local group on the SQL server, and adding that to the DB role, thinking that would give a level of abstract...
I've used Run As... on their XP machines to run Redgate SQL Compare under my logon. Although they are administrators on their machine, and I am not, I believe my account uses a different proxy server. This has resulted in giving me the option to activate manually (no idea why it can't connect to the activation server via my proxy), which we've done and everything is now ok. / comments
I've used Run As... on their XP machines to run Redgate SQL Compare under my logon. Although they are administrators on their machine, and I am not, I believe my account uses a different proxy serv...
One of the users has now raised fault F0045833 with Redgate. I'll post the solution here when we get it. / comments
One of the users has now raised fault F0045833 with Redgate. I'll post the solution here when we get it.
Disabling in BIDS work around still working for us. / comments
Disabling in BIDS work around still working for us.
We managed to get it sorted on one Windows XP machine by installing all Windows Updates (I think the problem was fixed by a .net update). Have another machine with the same problem, which I'll look at today to see if this corrects it. / comments
We managed to get it sorted on one Windows XP machine by installing all Windows Updates (I think the problem was fixed by a .net update). Have another machine with the same problem, which I'll look...
I have SQL Prompt 5.1.8.2 installed, but still having the same problem in BIDS 2008. When adding an expression to define the colour of a text field, previewing the report causes BIDS to crash. I've disabled SQL Prompt in BIDS, and everything is fine. / comments
I have SQL Prompt 5.1.8.2 installed, but still having the same problem in BIDS 2008. When adding an expression to define the colour of a text field, previewing the report causes BIDS to crash. I've...
Just installed on live server and same problem...the account definately has access to SQL. I suspect it doesn't have access to some folder or registry key. Goodness knows which one. / comments
Just installed on live server and same problem...the account definately has access to SQL. I suspect it doesn't have access to some folder or registry key. Goodness knows which one.
Yep.
I've just had the same problem with the test server I've built. Had to add the account into the Administrators group. Not a complete disaster, but less than ideal. / comments
Yep.
I've just had the same problem with the test server I've built. Had to add the account into the Administrators group. Not a complete disaster, but less than ideal.
Many thanks for your help. It's got shared memory and tcp/ip enabled. / comments
Many thanks for your help. It's got shared memory and tcp/ip enabled.