Viewing 15 posts - 1,456 through 1,470 (of 6,216 total)
I also distribute the procs to each db. Once you build a tool of some sort (as mentioned above), the process is painless. The nice part is that if you...
October 16, 2003 at 5:21 am
I saw a post recently that used xp_Cmdshell to execute 'type filename', should work as long as its plain ascii with no embedded control z.
Andy
October 16, 2003 at 5:18 am
We've got a planning meeting coming up, we'll revisit then.
Andy
October 16, 2003 at 5:16 am
One option might be to make it a composite key, add a one/two char column that would be a set to a default ("A"), combine it with your ident column....
October 16, 2003 at 5:15 am
SQL has minimal support built in, take a look at web tasks, might well do what you need. If the reports are fairly simple you can just write a function...
October 16, 2003 at 5:12 am
I think DMO has a method that will let you do the parse - basically the same functionality you see in QA that lets you check the query before you...
October 16, 2003 at 5:09 am
We actually get that here on the site sometimes, our search package uses FTS somewhere or other. Say "ho" is a noise word and you submit "ho ho ho", you...
October 16, 2003 at 5:07 am
The alert is a nice technique. I went for something simpler (uglier), I check the file sizes and even they are beyond a threshhold, I backup. Works for me because...
October 16, 2003 at 5:04 am
Dont know, but I will look - I can see where it would be useful.
Andy
October 16, 2003 at 4:55 am
I'd enjoy the post more if it didnt include "silly".
Andy
October 16, 2003 at 4:46 am
I tend to avoid bits and bytes myself, but a graphical view of space used would be a helpful tool. Nice write up Chris - good to have some variety!
Andy
October 16, 2003 at 4:42 am
Xp_sendmail supports a query parameter, so it will actually execute a query/proc and email the results.
Andy
October 16, 2003 at 4:40 am
Nice. Maybe you'll do the dance thing at Pass.
Andy
October 15, 2003 at 5:44 pm
If you get that working we'd be interested in a write up that we could publish. Let me know how it turns out.
Andy
October 14, 2003 at 10:06 am
That's correct, no SEH - you have to check @@Error to see if something went wrong.
Why wouldnt you change the columns to type = text, avoiding the warning and using...
October 14, 2003 at 10:05 am
Viewing 15 posts - 1,456 through 1,470 (of 6,216 total)