Forum Replies Created
Viewing 15 posts - 7,336 through 7,350 (of 19,560 total)
-
RE: The Data Resolutions
I have a list full of things I have been planning on doing such as articles, blogs, basement and BI certification. I plan on knocking some of those things...
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 -
RE: Are the posted questions getting worse?
GilaMonster (12/30/2011)
Stefan Krzywicki (12/30/2011)
SQLRNNR (12/30/2011)
Stefan Krzywicki (12/30/2011)
Cool. I used to play RPGs, but just can't get interested in them any more.This is what you guys are talking about, right?
Sometimes!...
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 -
RE: Query Result in Mail
Use the file attachment option
, [ @attach_query_result_as_file = ] attach_query_result_as_file ]
@attach_query_result_as_file = yourfile.xls or csv
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 -
RE: New Year's Eve Query
L' Eomot Inversé (12/30/2011)
jeff.mason (12/30/2011)
If someone says that the registration date is more useful in their country and that this is an American-centric difficult question I will scream.Now, let me...
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 -
RE: Setting up Database mail using gmail account
tcnolan (4/6/2009)
Mark Sumner (4/6/2009)
tnolan (4/6/2009)
Try this...Use smtp.gmail.com for the server
smtp.gmail.com is the outbound from gmail smtp server. It will refuse your relay request.
If that doesn't work, you could try installing...
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 -
RE: Query Result in Mail
Using your proc and the email query it works fine for me under the following circumstances.
The database the query is executing from is msdb or I use the three part...
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 -
RE: Today's Random Word!
L' Eomot Inversé (12/30/2011)
A newspaper is a device for making the ignorant more ignorant and the crazy crazier.
And for killing flies.
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 -
RE: Query Result in Mail
Are you able to send a test email through dbmail?
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 -
RE: Are the posted questions getting worse?
Stefan Krzywicki (12/30/2011)
Cool. I used to play RPGs, but just can't get interested in them any more.This is what you guys are talking about, right?
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 -
RE: Use an AD group for SQL Authentication
SQL Server permits the use of groups no problem. The issue actually seems to be that your syspro app requires SQL Auth.
Here's an article on the authentication methods of...
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 -
RE: Get the delta records between 2 tables with same structure
For things like this I usually rely on RedGate Data Compare.
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 -
RE: Are the posted questions getting worse?
Roy Ernest (12/30/2011)
Before I forget, Let me wish you all a very happy and prosperous New Year, 2012.What if we decide to visit your casino - do you still wish...
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 -
RE: Query Result in Mail
Does JobSummaryUtil exist in msdb?
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 -
RE: Are the posted questions getting worse?
Stefan Krzywicki (12/30/2011)
GilaMonster (12/30/2011)
Ninja's_RGR'us (12/30/2011)
Good game Steve???Err, yeah. Sorry. Too much online gaming lately.
On the plus side, an online play-by-post roleplaying game is better than nothing and can be a...
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 -
RE: Query Result in Mail
K - how about the send_db_mail query that you are using?
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
Viewing 15 posts - 7,336 through 7,350 (of 19,560 total)