Viewing 15 posts - 31,846 through 31,860 (of 39,819 total)
My guess is you're doing too much work in the trigger. Trigger code should be tight and do minimal work.
July 23, 2007 at 9:55 am
I would agree with Sergiy, though I see Kenneth's point.
The reason, in my opinion, that the square brackets came into being was due to extensions to SQL. Many common words...
July 23, 2007 at 9:54 am
Kenneth has the only items I know of (unless you had a trace running).
ApexSQL has ApexLog
Lumigent has Log Explorer
Red Gate has Log Rescue
Probably more out there.
July 23, 2007 at 9:51 am
Thanks. Please put suggestions for other stuff in here. I watch it and often this goes to the developers.
July 23, 2007 at 9:04 am
Al,
Which tool? I've used ER/Studio and ErWin. Didn't like ErWin, like ER/Studio, but both $$$.
July 23, 2007 at 9:03 am
I don't worry about getting rusty, that will drop off fast. Being a good employee, communicating, etc. shines through above technical skills in many jobs. The basic principles of being...
July 23, 2007 at 9:02 am
That's a good one. I'll see if we can get a query for that one.
One of the issues is that we used a purchased forum code so that we didn't...
July 21, 2007 at 10:04 pm
Let's hope. I get tired of moving stuff around ![]()
July 21, 2007 at 10:02 pm
It should, but I didn't trust my high school Latin to find the word ![]()
July 20, 2007 at 9:28 pm
If you figure out the schema tool thing, write me an article. I'd be interested to see that work.
I think some people use it when they do an all...
July 20, 2007 at 10:20 am
You can still use the trigger to record the update, just don't send the email.
July 20, 2007 at 10:13 am
Are you sure that your LUNs aren't sharing physical drives? I'd definitely have the SAN people dig into the configuration and while you are doing a restore, check and see...
July 20, 2007 at 10:11 am
I'm not sure what you are asking here? Are you looking to spread the load of querying?
July 20, 2007 at 10:09 am
OK, bad question. I'll award points back for Profiler and throw this one away.
July 20, 2007 at 8:50 am
If you click "Active Topics" at the top, it shows the topics with new posts since your last login. That's easier than scanning a board from the main forum page.
The...
July 20, 2007 at 8:49 am
Viewing 15 posts - 31,846 through 31,860 (of 39,819 total)