Viewing 15 posts - 1,651 through 1,665 (of 2,917 total)
My opinion (experts correct me if I am off on this) - the "secondary" server when doing log shipping is usually in place for disaster recovery. If the primary server...
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.
July 31, 2020 at 8:36 pm
Reading through your SP's something is wrong. Your "Procedure 1 Data" calls "EXEC Procedure1" twice but puts the data into 2 different tables with 2 different sets of columns. That's...
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.
July 31, 2020 at 8:30 pm
according to the documentation for SQL Server 2012 - no:
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/ms143506(v=sql.110)?redirectedfrom=MSDN
Here it says that you are looking at Windows Server 2012 if you want to be in a supported configuration. That...
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.
July 31, 2020 at 3:52 pm
I expect that anyone on the forum is going to need more than this. Since the backup failed, it is obvious (to me) that the restore failed. Without the backup,...
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.
July 31, 2020 at 3:42 pm
FKBEYS - I think you are thinking about the calculation wrong or I may be looking at it wrong. If I understand right, your table contains the columns "Price", "Discount1","Discount2","Discount3",...
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.
July 30, 2020 at 9:23 pm
I like the idea of moving SSRS to the web server. I will run that past our IT team.
PolyServe was a fun tool when configured correctly for sure. We ran...
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.
July 30, 2020 at 9:12 pm
Thanks for the tips!
We currently have a single SSRS instance, but were toying around with the idea of a second to handle a subdivision of the company. One instance per...
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.
July 30, 2020 at 8:11 pm
Are you getting the same error? If so, my next thought is a trigger on the table is doing something silly.
But, just to address potential other pain points, how large...
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.
July 30, 2020 at 5:42 pm
Hello Steve,
Thanks for the reply. I was not aware of the 25 instance limit; that is a good thing to know!
That is a good future state for sure, but current...
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.
July 30, 2020 at 5:35 pm
What have you tried so far?
I can think of a few ways to do this. A LEFT JOIN onto table #location where the values match is the approach I'd take. ...
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.
July 30, 2020 at 2:35 pm
Thanks Thom! I didn't actually look into the permissions on this, was just going based on our setup. We have 3 DBA's all of who are sysadmins so just went...
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.
July 30, 2020 at 2:21 pm
My first step would be to compare datatypes on a lot of that. For example, what is the datatype of TBL.City and N.City and N.CompanyID (guessing that is N.CompanyID 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.
July 30, 2020 at 2:16 pm
One way to do this would be to have a stored procedure with EXECUTE AS in it. This way, you can set the stored procedure to run as sysadmin 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.
July 30, 2020 at 2:02 pm
you say that the system needs to be pluggable into "any SQL database" then talk about using reading from the data page and the transaction log files. Not sure I...
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.
July 29, 2020 at 8:26 pm
heh... now you have me second guessing myself on that atom file thing... Been forever since I used that as I found it to be unreliable and annoying to work...
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.
July 29, 2020 at 6:57 pm
Viewing 15 posts - 1,651 through 1,665 (of 2,917 total)