Activity overview
Latest activity by GarryB
Thanks for the response. But something in the users settings got out of wake. He did a reset default settings and everything started working as he expected. / comments
Thanks for the response. But something in the users settings got out of wake. He did a reset default settings and everything started working as he expected.
SQL Permissions Required for SQL Prompt
I have granted user view definition on the database role they are in, but they still report they do not get column and schema items returned via sql prompt. What exact permissions will allow this ...
Sweet, thanks for that info. / comments
Sweet, thanks for that info.
Setting Data and Log locations
Are there any plans to allow for the user to select the data and log locations for the SQL clone files that are created during the clone process?
I guess I could find and replace to remove the INSERT INTO and VALUES to nothing.
I actually just need the actual data in the () for what I am trying to accomplish.
So I ended up breaking it up. Do 1000, then sort desc and grab the extra 346 values. / comments
I guess I could find and replace to remove the INSERT INTO and VALUES to nothing.
I actually just need the actual data in the () for what I am trying to accomplish.
So I ended up breaking it up. D...
Love Script as Insert, but just found odd behavior
I was just doing some work and using the handy feature script as insert.
So I ran a select top 1000 query and get the following scripted insert output:
I then realized the table had more than a 100...
Send Feedback anoying
Can the send feed back be a little less intrusive. On RDP screen with little real estate this is a pain. Can it hide after a certain amount of time, can it have a hide button.
I have it running now and will compare the times to these last two runs and then a time before now that I can mine this data. / comments
I have it running now and will compare the times to these last two runs and then a time before now that I can mine this data.
$redgateCloneURL = 'http://devclndbs01.exclaim-dev.com:14145'
Connect-SqlClone -ServerUrl $redgateCloneURL
$imagelist = Get-SqlCloneImage
$clonelist = Get-SqlClone
foreach ($name in $imagelist) {
$clonelist | Where-Object ParentImageId -EQ $name.Id | Select-Object @{Name="Image Name";Expression={$name.name}}, Name, State
}
$clonelist = Get-SqlClone
I put this code together. Do you know how I can return the located on server that the clone is hosted on? I could not figure out how to capture this server name. / comments
$redgateCloneURL = 'http://devclndbs01.exclaim-dev.com:14145'
Connect-SqlClone -ServerUrl $redgateCloneURL
$imagelist = Get-SqlCloneImage
$clonelist = Get-SqlClone
foreach ($name in $imagelist) ...
We patch the OS monthly. So Windows patches are applied the servers are rebooted. I had a lot of issues in the beginning of SQL Clones release that the order in which things came up caused issues with clones hosted on other servers. This has not been an issue with the latest versions. I patch SQL Clone manually since we have issues with certificate authorizations. Wish there was something you could do about that. / comments
We patch the OS monthly. So Windows patches are applied the servers are rebooted. I had a lot of issues in the beginning of SQL Clones release that the order in which things came up caused issues...