Viewing 15 posts - 916 through 930 (of 19,560 total)
Grant Fritchey (8/12/2015)
Here's an example of a Powershell script that will do this.
Thanks for finding that. I didn't have one handy.:crazy:
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
August 12, 2015 at 11:31 am
Luis Cazares (8/12/2015)
Lynn Pettis (8/12/2015)
GilaMonster (8/12/2015)
Lynn, I think that may have been unnecessarily antagonistic.
Probably, but so was his WTF in his OP and then the bashing because we didn't give...
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
August 12, 2015 at 11:30 am
Lynn Pettis (8/12/2015)
SQLRNNR (8/12/2015)
Let's keep this friendly.Let's not antagonize.
Easier said than done when we get hammered for not providing the answer the OP expected when we did answer the question.
Agreed.
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
August 12, 2015 at 11:28 am
With no SQL engine on C, you have your hands tied a bit more.
Powershell is an option as mentioned by gazareth.
What is the business purpose for not allowing communications directly...
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
August 12, 2015 at 10:26 am
Let's keep this friendly.
Let's not antagonize.
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
August 12, 2015 at 10:21 am
Well, if server C can see both A and B, then you can do this a number of ways.
1. Linked Servers to pull data from A to C, and then...
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
August 12, 2015 at 9:50 am
Hany Helmy (8/12/2015)
SQLRNNR (8/11/2015)
Yes the string length in the messages tab is 4000 characters. And the variable length is 48,893. Are you seeing something different in the messages tab?
Damn :cool:...
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
August 12, 2015 at 9:44 am
Grant Fritchey (8/12/2015)
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
August 12, 2015 at 9:41 am
GilaMonster (8/12/2015)
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
August 12, 2015 at 9:37 am
mar.ko (8/12/2015)
There are two:
1) ISNULL(@ColDefaultVal,'-')
That variable was the one preventing the PRINT from executing.
2) RAISERROR ('ColDflt=%s',0,1,@ColDefaultVal);
This is even better as it indicates...
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
August 12, 2015 at 9:33 am
Without a datetime component in the table and without the possibility to join to another table to get that information, you are somewhat stuck.
You would need to add a column...
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
August 12, 2015 at 9:23 am
WayneS (8/11/2015)
Any other Threadizens going to the Louisville SQL Saturday next week?
Nope - I have plans.
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
August 11, 2015 at 7:50 pm
dearth
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
August 11, 2015 at 7:08 pm
Yup, SQL injection is still serious business and still a pretty sizable problem.
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
August 11, 2015 at 7:01 pm
Alvin Ramard (8/11/2015)
Lynn Pettis (8/11/2015)
Alvin Ramard (8/11/2015)
WayneS (8/11/2015)
Lynn Pettis (8/11/2015)
What an attitude.Duly smacked
It's actually the last variable, that's NULL. 😀
I think we scared him off.
WTF = Where's That Fellow...
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
August 11, 2015 at 4:24 pm
Viewing 15 posts - 916 through 930 (of 19,560 total)