I got confused somewhere. Here is the code that should have been used to create the event. I must have combined 2 of the practices. I have no idea what...

From what I read, and think I understood, this code is creating a watchdog that looks for SQL statements that contain the "Having" clause. When it sees that clause, it...

I am flattered to have piqued the interest of some SSC heavy hitters. I do not have an execution plan for you. I am not even certain what it should...

• This reply was modified 2 years, 2 months ago by  Tobar.

Check out the picture of the banner. The ad and the search look like one object.

 

Foreign keys in the file. Good call Jeff. (I have not been active in this...

• This reply was modified 2 years, 2 months ago by  Tobar.

If you are unfamiliar with the ascii character set, you will need to look that up.

The hammer would be to process each character in the string with ASCII() and only...

• This reply was modified 2 years, 2 months ago by  Tobar.

MMgrid by Mister.Magoo is my only add-in. What a time saver.

When I first started using SSMS (after years of Toad and Oracle tools) I hated it. After 7 years of...

Yep. I was scanning for "My Messages". :Whistling:

Thanks.

Thanks. My eyes just finally rested upon it a couple of seconds before I saw your post. Unfortunately, what I am really looking for is the messages I have sent/received....

Black_T: Thanks for the insight. I recently stumbled upon part of your solution, but didn't know the extent of changes that "coulld" be needed.

g_britton: Sorry about not posting the error...

I deleted the header and the column. It left a blank space and when I ran it it gave me an error.

Other thoughts? Clarifications.

Thanks everyone. Sean's implementation fits the bill. I appreciate all the help.

BrianAltmann (6/26/2014)

---

I am using ErWin to design

...

However I typically get blank stares when I discuss the value of an ERD tool for DB projects, even with experienced developers.

I wish I...

In my opinion many ERD tools today cater to the intensive (concerned about physical and logical modeling) crowd, and therefore unless you have a large organization who has the specialists,...

tim.berry 88829 (6/12/2014)

---

The key resolving the conflict is...

Thanks for the wonderful message Ben.

I am thankful for blokes like the previous responders. I am thankful for a God who loves. I am thankful for the opportunities that I...