Forum Replies Created
Viewing 15 posts - 2,431 through 2,445 (of 2,919 total)
-
RE: DSN Tests successfully, but unable to use in C# application
When you say DSN, I am assuming this is an ODBC connection? If so, those do not store the password for the credentials. You can verify this by looking at...
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. -
RE: Explicit value must be specified for identity column in table 'TABLEA" either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.
That changes things (good thinking Gail!).
The instead of trigger would change how the insert is performed.
I imagine you'd want to disable the trigger, do the insert, enable...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. -
RE: Collapsing Hierarchy of messages into single row
Zidar - Thursday, July 13, 2017 10:50 AMBut somebody else on here may have a better idea
Any book on...
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. -
RE: excel source
Which part is slow? The loading of Excel into the staging table or merging the staging table into the live table?
You are using SSIS. How much memory does...
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. -
RE: Explicit value must be specified for identity column in table 'TABLEA" either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.
I just ran the above code with minor modifications and it ran without any problems.
The modification I did was to change it from a permanent table to a table...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. -
RE: What do you do when you make a mistake?
I try to own the mistake if it was me who made it and I use that to update our release documents to prevent it from happening in the future...
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. -
RE: Msg 203, Level 16, State 2, Line 38 s not a valid identifier.
This line looks a bit odd to me too:
SET @TABLE_NAME = (SELECT...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. -
RE: TRY_CONVERT and IsNumeric
I am slightly confused.
I took the code, copy-pasted it into SSMS 2016, connected to a SQL 2016 SP1 instance and ran it. I got a different answer than 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. -
RE: Inner/Outer Join
As a thought, does this query give you any results:
SELECT *
FROM tblA
WHERE tblA.id NOT IN (SELECT id
FROM tblB)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.
RE: SQL SERVER 2016 Error:
May actually have a solution for you:
https://support.microsoft.com/en-us/help/3053960/fix-a-system-assertion-in-longrec.inl-1318-occurs-when-you-rebuild-or
I see you posted this in the SQL 2016 section and the above article applies to SQL 2012. I'm guessing...
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.
RE: Delete multiple SSRS reports from report portal using Powershell
The other thing you can do is go into the SSRS web portal, navigate to the folder that has the reports to remove, change the view type to "list" instead...
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.
RE: SQL SERVER 2016 Error:
2 things come to mind:
1 - did you run DBCC CHECKDB to ensure the database is not corrupt?
2 - did you check the SQL Server error log for...
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.
RE: SQLServerAgent Error 22022
Another thing to watch, if you are using an SSIS catalog (might apply to the non-catalog method too), the job doesn't need to reside on the same server as 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.
RE: Create Multiple SSRS Subscriptions for a Parameterised SSRS Report - Programmatically / Dynamically / Quickly
Adding to what has been said, I am slightly confused as to why you would manage the subscriptions for end users.
I understand if the subscriptions are emails being sent...
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.
RE: SQLServerAgent Error 22022
Adding to Sue's response, if user XXXX doesn't explicitly exist in your database, but is a windows user, they could be a member of an AD group that has permission...
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.
Viewing 15 posts - 2,431 through 2,445 (of 2,919 total)