Viewing 15 posts - 1,381 through 1,395 (of 5,685 total)
weston_086 (7/5/2012)
These tables have no indexes.so if i have to create index which column would be the best in each table .
Schema please? I'd rather avoid giving...
July 5, 2012 at 5:44 pm
weston_086 (7/5/2012)
please find attached query plan for that.
Please also include the schema and indexing. In particular for ipv6_Daily_reporting, IP_Ver_Access_Point_Name, IP_Ver_Cl_Hset_Tac_OS_PDP. From what I see here these are simply...
July 5, 2012 at 5:02 pm
It's FileSpec, not FileNameRetrieval. Sorry about that.
July 5, 2012 at 4:59 pm
No problem. HAd a chance to setup a really simply test, and we've got the wrong expression. Trying to figure out which one it needs.
July 5, 2012 at 4:58 pm
PHXHoward (7/5/2012)
Because I have the directory specificed in the line above, I don't need it in the file name do I? I've tried fully qualified and name only.
Nope, you...
July 5, 2012 at 4:38 pm
While we could make guesses at this from just the code, there's a few pieces of it that we desire to try to help with optimization issues like this.
Please click...
July 5, 2012 at 4:35 pm
mw112009 (7/5/2012)
So you are saying I don't have to modify this any more.You mean, if there is one error along any path the entire package will stop ?
Cool.
Please reply
Unless you've...
July 5, 2012 at 3:41 pm
Welsh Corgi (7/5/2012)
What type of an Account are you using for the SQL Server Agent Account?
It's not the agent, but right idea. XP_CmdShell has a proxy user on the...
July 5, 2012 at 3:38 pm
PHXHoward (7/5/2012)
The file name will be CCYYMMDD_HHMMSS_update.txt
I know that I can not ask SSIS to match...
July 5, 2012 at 3:37 pm
That should already be occuring unless someone's been messing around with the allowable error counts and error inheritance in the components. A single fail should stop the process completely...
July 5, 2012 at 3:29 pm
WayneS (7/5/2012)
GilaMonster (7/3/2012)
For anyone not on/not paying attention to twitter.....It seems to be official.... I'm a Microsoft Certified Master for SQL Server 2008.
https://twitter.com/SQLintheWild/statuses/220252281847808001
Awesome Gail. Major congratulations!
Woot woot, go Gail! ...
July 5, 2012 at 3:03 pm
matthew.brown-746365 (7/2/2012)
July 2, 2012 at 6:23 pm
Your sysadmin will need to do it. Google it up, the list of instructions is long and intricate. Basically you need to end up having kerberos on Machine...
July 1, 2012 at 3:03 pm
You're asking us to look at the results of something when we have no schema nor data to work from, unfortuantely we're not going to be able to help much...
July 1, 2012 at 3:01 pm
Les Cardwell (7/1/2012)
>>Please define 'chokes'. You get an error message?Msg 102, Level 15, State 1, Procedure UpdEPCollectorAssociation, Line 15
Incorrect syntax near 'sp_getapplock'.
That's incredibly odd... I wonder if it's whining...
July 1, 2012 at 1:41 pm
Viewing 15 posts - 1,381 through 1,395 (of 5,685 total)