Viewing 15 posts - 796 through 810 (of 1,583 total)
Interesting! I thought running the script to "Allow In Process" would have fixed that - good to know when dealing with a web server 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 28, 2013 at 1:05 pm
It can also be quite helpful to look at your cached execution plans to see which queries/procedures have inadequate query plans, this can be found by running the code belowSELECT...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 28, 2013 at 10:32 am
I take that suggestion back!
Verify these things are true:
1. Install Office 2007 Data Connectivity Components (http://www.microsoft.com/download/en/confirmation.aspx?id=23734) - which I'm sure is already installed as it currently works when runing as...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 5:31 pm
Oh ok, gotcha - very true, linked server not needed here...all I can suggest is that you need to verify that domain users have access to the file folder being...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 5:22 pm
Have you tried launching a new install of 2012, but only choose the Client Tools?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 4:48 pm
Um...no linked server? Are you certain? I am under the impression you can't import data from EXCEL without using a linked server or some System DSN (which then...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 4:43 pm
As BitBucket has stated, it's a challenge to assume what you want without the basics needed for everyone to give it a whirl. Not sure if the example below...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 4:39 pm
You also may wish to check out these links:
http://stackoverflow.com/questions/9687631/openrowset-with-excel-file
And also make sure the file isn't currently open while running your process, this error can pop up if the file is...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 4:23 pm
"Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".
Check the security settings for the linked server. Is security set to "without security context", ""login's current security context", or "this...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 4:19 pm
Scott, for the record I agree with what you're saying (really, I do), just wanted to provide an option to what the OP originally requested. To fulfill his/her initial...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 12:59 pm
And Yes, changing the job name itself would still cause an issue, however hopefully changes like that would be made by a DBA or otherwise communicated that a change was...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 12:38 pm
Of course, could happen 😀 One should takes measures to avoid that...I'd create a function to look up the job_id based upon the job name (that way no matter...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 12:35 pm
newdba_sql (1/25/2013)
So this script will check if the job's last run status is successful, then it will move...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 12:10 pm
Please post the DDL for the "abc" table, and a few sample rows of data. Most likely it's just a matter of a missing row terminator or something similar...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 9:16 am
Did you run it as-is?
You need to replace the string UID with the "proper" job_id from your msdb..sysjobs table - I have no idea what the job_id's stored in your...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2013 at 8:57 am
Viewing 15 posts - 796 through 810 (of 1,583 total)