Viewing 15 posts - 4,126 through 4,140 (of 6,216 total)
Well, it could be a before trigger - depends on how you could it. An instead of trigger fires before the action actually completes. That gives you a chance to...
May 31, 2002 at 9:38 pm
Take a look at OpenXML. Within SQL its the easiest way to handle XML, essentially treats it like a table. Pain to set up, but works well.
Andy
May 31, 2002 at 9:32 pm
Hardly ever. In my experience they are very reliable, I'd at most you need to run after a bad shutdown or as part of a monthly mainteance routine.
Andy
May 31, 2002 at 4:48 pm
xp_msver will give you some info, not sure if what you need though. Lots of information available via WMI, though it takes time to figure out, might be faster to...
May 31, 2002 at 4:47 pm
Cant defrag, have to rebuild. DBCC reindex I think.
Andy
May 31, 2002 at 2:54 pm
Totally agree. The gaps are fine. In extreme cases (financial records maybe) where you must preserve the numbers, you can added a deleted column - just have to remember to...
May 31, 2002 at 2:53 pm
You can redirect the output using osql and the ">" operator. There is also an option in QA to save to a file.
Andy
May 31, 2002 at 2:52 pm
Leading wildcards can often cause a table scan since indexes arent useful. You can look at whether you really need that functionality, or maybe provide it as a non-standard option,...
May 31, 2002 at 2:51 pm
May 31, 2002 at 12:47 pm
I cant speak for the other two, but for me no money required - just part of what we do here. Hope you'll continue to ask (and answer) questions.
Andy
May 31, 2002 at 12:38 pm
I agree with what Antares suggests - add a versionid col to the relevant tables. Im currently working on a solution that uses version across multiple tables, all using that...
May 31, 2002 at 12:11 pm
Sure. Even in SQL7 a standard "after" trigger gives you the logical deleted table which contains all the info from the deleted rows except text columns. In SQL2K you can...
May 31, 2002 at 12:09 pm
It's possible to limit bandwidth using a quality of service policy, never heard of one that actually counted the rows - would be interesting! Not impossible I'd say.
Andy
May 31, 2002 at 6:20 am
If you want to move from XML directly then I think XSLT is probably the way to go, or a lot of string parsing! If you can get the info...
May 31, 2002 at 4:41 am
You're right. It's one of those things I don't use and forgot about! Had to look back to see how it worked - have to stop/start svc when you enable...
May 31, 2002 at 2:48 am
Viewing 15 posts - 4,126 through 4,140 (of 6,216 total)