Viewing 15 posts - 7,846 through 7,860 (of 14,953 total)
porwal.naveen (11/9/2009)
I have one more question here.
If I create trigger on update of some column, does it lock that row till the trigger finishes updation of the...
November 9, 2009 at 6:53 am
Company MSDN subscription or get your own TechNet subscription. Either one will allow you to do what you're doing.
If they won't go for that, then get them to get...
November 6, 2009 at 2:50 pm
If you have the driver correctly installed, then the error is most likey to be from not having the correct filename and/or path in the openrowset command.
November 6, 2009 at 11:14 am
Triggers are not the right tool to use to prevent SQL injection. By the time the code has fired off a trigger, it's WAY too late to be preventing...
November 6, 2009 at 11:12 am
SQL 2005 has a default trace running that tracks that kind of change (and other DDL commands). You might find what you're looking for in there.
November 6, 2009 at 9:53 am
kkapferer (11/6/2009)
November 6, 2009 at 9:50 am
J-F Bergeron (11/6/2009)
November 6, 2009 at 9:46 am
I think RedGate has a product for that. ApexSQL, too.
November 6, 2009 at 8:57 am
Whichever machine the job was scheduled on.
November 6, 2009 at 8:56 am
Absolutely. I take a very strong stand on questions of ethics and legality. Always.
If I were the manager, and I found out that a DBA had given himself...
November 6, 2009 at 8:55 am
It's a valid point that many businesses still have SQL 2000 servers, and will continue to have them for some time yet. Could be a niche market in the...
November 6, 2009 at 8:48 am
There are several third party tools for debugging T-SQL.
Management Studio for SQL 2008 includes some debugging tools built in.
I generally just use raiserror, select, print, etc., at various points throughout...
November 6, 2009 at 8:43 am
Denormalization is deliberately breaking normal forms, usually for report performance.
The usual process is to take normalized data from multiple tables and eliminate the joins between them by putting the data...
November 6, 2009 at 8:42 am
Right-click the job and select History.
That's your best bet.
November 6, 2009 at 8:38 am
If I'm not mistaken, PASS was Mon-Thu, right? So what's traditional for people to do on Friday? Fly home? Ad hoc activities? Or is there something...
November 6, 2009 at 8:37 am
Viewing 15 posts - 7,846 through 7,860 (of 14,953 total)