Viewing 15 posts - 2,896 through 2,910 (of 2,917 total)
Is the backup happening to local disk or network attached storage?
If it is network attached storage, you could bug your network admin to see if there are any network issues...
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.
November 16, 2016 at 8:29 am
Did a quick google of that and found this link: http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/error-the-application-has-failed-to-start-because/df019c0d-746e-42d0-ad68-465e18e3f3ef
which had the following answer:
Error message: "Side-by-side configuration is incorrect"
The machine is missing the correct C++ runtime components for your...
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.
November 16, 2016 at 7:43 am
Now, I am no SQL expert, but if I had to guess, I would say it is part of how SQL Server handles ACID.
If you do an update and something...
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.
November 16, 2016 at 7:37 am
Should also be noted that this is for SQL version greater than SQL Server 2005 which according to the microsoft documentation at https://msdn.microsoft.com/en-us/library/ms174335(v=sql.90).aspx states:
expression
Is a constant, a variable, or an...
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.
October 17, 2016 at 8:35 am
OH, so you are using SSIS.
why not use a data flow task to copy the data over instead of a script?
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.
October 12, 2016 at 10:38 am
Eirikur Eiriksson (10/12/2016)
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.
October 12, 2016 at 9:44 am
you could do it as a stored procedure instead of a hard coded SQL command, but if you don't like that solution how about:
public static SqlDataAdapter InsertSQL()
{
SqlDataAdapter adapter = new...
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.
October 12, 2016 at 9:12 am
The reason it is failing is that the variable doesn't exist on the MYSQL side. When you do the execute AT command, you are telling it to run 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.
October 12, 2016 at 8:54 am
I agree with you Andrew.
It also doesn't help that every time I think I partially understand most of the features they add in something new or I find a feature...
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.
October 12, 2016 at 8:20 am
Abu Dina (10/7/2016)
I love it when I get a notification about a thread I posed in 4 years ago!Miss SQL Server so much! :crying:
Geeze. Sorry about that. Didn't...
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.
October 7, 2016 at 10:30 am
That is a good question. Where I work we have 23 live SQL Instances, 51 test/development instances that are not always up (due to disk space constraints mostly) 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.
October 7, 2016 at 8:33 am
Jeff Moden (10/5/2016)
bmg002 (9/27/2016)
Sean Lange (9/27/2016)
bmg002 (9/27/2016)
if you are using 3 values in the object declaration, you are declaring the database, the schema and the object.
so...
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.
October 6, 2016 at 8:43 am
I recently took this test and pass first try.
The training I went with was uCertify.com. The price was decent and the content was exactly how I learn. 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.
September 30, 2016 at 8:24 am
I could be wrong, but I think you are missing a few ;
I think the command should be:
sqlcmd -S %_var1% -d %_var2% -Q "DECLARE @status varchar(100); exec dbo.sp_RunSQLAgentJob @job_name =...
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.
September 27, 2016 at 1:48 pm
Sean Lange (9/27/2016)
bmg002 (9/27/2016)
if you are using 3 values in the object declaration, you are declaring the database, the schema and the object.
so in your case:
JIREM10.dbo.JIRABConcentration
JIREM10...
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.
September 27, 2016 at 1:45 pm
Viewing 15 posts - 2,896 through 2,910 (of 2,917 total)