Viewing 15 posts - 14,296 through 14,310 (of 19,560 total)
GabyYYZ (5/4/2010)
Hmmm...I think Random Word is becoming Son of Thread.
Hey, if Freddy can keep coming back - so can the spawn of the thread!!
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2010 at 11:43 am
Paul White NZ (5/4/2010)
It seems the glass is definitely half-empty for you guys tonight! 😛I prefer to think of the glass as being massively over-specced for the task at hand.
Nice...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2010 at 11:42 am
Paul White NZ (5/4/2010)
CirquedeSQLeil (5/4/2010)
Paul White NZ (5/4/2010)
Awesome - a KB article on how to post questions to an online forum: http://support.microsoft.com/kb/555375
Most excellent indeed. I had never seen that...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2010 at 10:10 am
I would enable logging from within the package. That will give you more detail as to what is actually happening with the package when executed as a job.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2010 at 10:07 am
Lynn Pettis (5/4/2010)
Field Trip - Going to the Denver Museum, seeing the Body works Exhibit with my youngest and her class.
That would be fun!!
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2010 at 10:04 am
Steve Jones - Editor (5/4/2010)
Baking. Made chocolate croissants this morning.
Picture homer drooling here...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2010 at 10:03 am
Paul White NZ (5/4/2010)
Awesome - a KB article on how to post questions to an online forum:
Most excellent indeed. I had never seen that before but it has been...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2010 at 10:02 am
Wow...
Who would have thought the QOD would have unveiled a bug and produced great discussion. Congrats to all who have contributed to this discussion!!
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2010 at 8:49 am
Thanks - good luck.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2010 at 8:42 am
Kenneth W Kasper (5/3/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 3, 2010 at 10:41 pm
According to MS,
http://msdn.microsoft.com/en-us/library/ms188664.aspx, you must be a member of the sysadmin role on both the source and the destination.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 3, 2010 at 8:20 pm
Quick eyeball check sp_who2
you could also check the default trace, and see if there has been any activity.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 3, 2010 at 8:16 pm
Thanks Lowell, that is a good one to know.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 3, 2010 at 8:14 pm
crookj (5/3/2010)
CirquedeSQLeil (5/3/2010)
hungrificationemulsification
pacification
Joe
humidification
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 3, 2010 at 8:12 pm
Are you getting any error messages?
If so what are the errors?
Do you have logging enabled within the package?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 3, 2010 at 8:09 pm
Viewing 15 posts - 14,296 through 14,310 (of 19,560 total)