Viewing 15 posts - 10,186 through 10,200 (of 19,560 total)
Track down the ip address from that log table you just created and find out what application resides there. An application is using .Net 3.5 to connect to the...
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, 2011 at 11:42 am
Try the first suggestion by Ninja and see if that works in this case.
If not, please post some sample data and desired results
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, 2011 at 11:38 am
JCSQL (5/4/2011)
OK so the last post I just hard coded amp (which is &). I need this to come back as & and not amp.Thanks
K - i was posting mine...
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, 2011 at 11:36 am
JCSQL (5/4/2011)
Here are the results:
<import_Request>
<daily_deal>
<category>Beauty, Spas, "&" Salons</category>
</daily_deal>
</import_Request>
As you can see the & was converted to...
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, 2011 at 11:35 am
Do you have a calendar table?
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, 2011 at 11:32 am
can you reformat it to show exactly what you are seeing?
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, 2011 at 11:29 am
Ninja's_RGR'us (5/4/2011)
I think you should both get over yourselves and stop trying to be right... but I'm just an outside observer :hehe:.Just my 0.02$
Yes?:w00t:
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, 2011 at 10:51 am
Try
May I help you?
or
How may I be of assistance?
And do it with an nasally accent 😀
I would rather hear what than yes - but it all depends on tone.
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, 2011 at 10:42 am
ALZDBA (5/4/2011)
Failedconnectiontracker is using sqlserver event notifications to capture all login info.
We have a dba database on every sqlserver instance to host all sysadmin/dba systems stuff.
In...
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, 2011 at 10:31 am
Excellent - glad it worked.
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, 2011 at 10:09 am
That seems to print fine. I have seen it in the past where it was throwing that error but was actually referring to the second set of items being...
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, 2011 at 8:43 am
Ninja's_RGR'us (5/4/2011)
SQLRNNR (5/4/2011)
@ninja - very nice
Just for the fun of it... I added a filter to ignore my latest 2 backups to simulate lost or corrupt backups files...
Still runs in...
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, 2011 at 8:37 am
comment out your exec statement and just print the variable
Like this:
print @cmd
Post the result of that print statement
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, 2011 at 8:36 am
Good to hear
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, 2011 at 8:21 am
what do you get if you print the variable to screen after setting it?
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, 2011 at 8:20 am
Viewing 15 posts - 10,186 through 10,200 (of 19,560 total)