Viewing 15 posts - 2,071 through 2,085 (of 2,917 total)
The link in the whitepaper seems to be broken :(.
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 1, 2020 at 2:48 pm
Not looking through the logs sounds like you don't really want to find out what caused the problem. That is what the logs are there for. Without finding the cause,...
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.
March 31, 2020 at 7:27 pm
My best guess as to why it suddenly broke is that something changed on your system. Could have been a windows update, a sql update (although those are both unlikley),...
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.
March 25, 2020 at 9:55 pm
To address the security certificate message, that is semi normal. Computers generate a certificate to be used for RDP connections. It is used to encrypt the connections. It should have...
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.
March 25, 2020 at 9:36 pm
My advice - First script will be dropping the server name from the SQL Instance. So this will NEED to be the one that is stored in your databases. Since...
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.
March 25, 2020 at 7:41 pm
One thought on how to create the excel file dynamically would be to have a "template" excel file that has the table headers already entered, but no data and 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.
March 25, 2020 at 4:26 pm
My laptop that I grabbed for cheap came with 6 GB of RAM and a 64GB disk. Got it new and first thing I did was install the latest windows...
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.
March 25, 2020 at 2:27 pm
Might be a dumb question but why would you want to install different editions of SQL Server on the same physical machine?
I would recommend having a different folder for each...
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.
March 23, 2020 at 9:54 pm
A 32GB disk is pretty small for sharing both Windows and SQL Server. Plus 4 GB of RAM is pretty low for SQL and Windows to play nice.
To install SQL...
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.
March 23, 2020 at 9:14 pm
Sounds to me like a version issue. Is your VS2017 project set to use the same SQL Server version as your SSIS server?
Failing that, you can export the ispac file,...
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.
March 20, 2020 at 7:52 pm
From the article linked in the question:
SQL Server Management Studio uses Microsoft.NET FrameworkSqlClient for execution in regular and SQLCMD mode. When run from the command line, SQLCMD uses the OLE...
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.
March 13, 2020 at 7:56 pm
I think this information should already be captured in a few tables. Looking at the table ReportSchedule, joining that back to Schedule, Catalog, and ExecutionLogStorage, you can see the timed...
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.
March 5, 2020 at 6:29 pm
I wasn't trying to rag on you Steve. I was just commenting on the different data types (at least in SQL 2008 R2 which I tested it in) that give...
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.
March 2, 2020 at 8:08 pm
While I agree with Jeff, it doesn't apply to all larger numbers. TINYTINT, SMALLINT, and INT's have the same behavior but bigints throw an error instead.
As for the VARCHAR value,...
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.
March 2, 2020 at 6:53 pm
Can you post more information?
What I expect you are doing is something like:
SELECT *
FROM <TABLE>
WHERE <COLUMN> = 12.3
If that is the case, double check the datatype 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.
February 28, 2020 at 4:19 pm
Viewing 15 posts - 2,071 through 2,085 (of 2,917 total)