Viewing 15 posts - 2,641 through 2,655 (of 2,917 total)
That is nice that you have a dedicated VM for testing. I imagine you have the databases set up so they are both running off of the same VM then...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 18, 2017 at 10:47 am
Another thing you could do is look at HA software. Backups are more about DR than HA.
DH2i has a tool called DxEnterprise which handles HA quite nicely as...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 18, 2017 at 10:24 am
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 18, 2017 at 10:05 am
heh... whoops. Guess reading your signature would have helped. I don't know too many men named Gail. Sorry about that. I think the avatar threw me off.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 18, 2017 at 10:01 am
Do you have 1 database for all of the "towns" or 1 database per "town"? Your description makes it sound like 1 database that holds all of the towns.
Rather...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 18, 2017 at 9:47 am
Another good thing to look for is local SQL Chapters or SQL events. Some are free (SQL Saturday for example) while others cost money (PASS Summit, SQL Cruise, etc). They...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 18, 2017 at 9:28 am
To make that easier to read:LEFT(U.FULLNAME,charindex(',', U.FULLNAME)- 1) AA,
CHARINDEX(LEFT(U.FULLNAME,charindex(',', U.FULLNAME)- 1), P.Project_Name) CCOUNT
Next, as a thought, why not try replacing it with: The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 18, 2017 at 8:38 am
ORDER BY
(
CASE WHEN Claims.CrossoverOrigFormNbr =...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 17, 2017 at 3:03 pm
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 17, 2017 at 2:40 pm
you sure the IP is correct? I've seen servers change IP's after reboot.
Can you connect to that via SSMS?
First try connecting via SSMS from the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 17, 2017 at 2:23 pm
First, can we get some DDL so we can test things easier on our end for writing and testing the code?
Next part in my mind is a tad...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 17, 2017 at 2:16 pm
One other thought I have:
your Flat File Connection Manager screen looks different than Phil Parkin's. Which version of visual studio are you guys using?
I've seen oddities with SSRS and...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 17, 2017 at 8:04 am
That is odd. I have not installed 2005 before, but I know with 2008 R2 and higher I've installed and uninstalled using the base media (with no service pack) even...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 13, 2017 at 1:09 pm
I think you'd want to have the same installation media. As you pointed out, using incorrect installation media cannot remove all of the features.
But Microsoft offers all of...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 13, 2017 at 12:05 pm
A difference between the OP and Phil Parkin's post that I noticed is that the OP used the code page 65001, and Phil used 1252.
I am wondering a...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 13, 2017 at 10:34 am
Viewing 15 posts - 2,641 through 2,655 (of 2,917 total)