Viewing 15 posts - 406 through 420 (of 518 total)
OK, I'm going to show my ignorance here. I guess I just never thought about it and I suppose it would be easy enough to test, but does anyone know...
November 15, 2002 at 10:17 pm
You have to take the Sql code from the function and run it in a query window seperately. It doesn't actually have a query plan of its own, but is...
November 15, 2002 at 3:09 pm
yes, lots. Click on my handle (scorpion_66) and it will show you my e-mail address. Shoot me an e-mail, and I'll send you all I got till you holler...
November 15, 2002 at 2:59 pm
Looks pretty straight forward to me too, though I think I would use variables to hold the values and do a single select to get them. Another statement to update...
November 15, 2002 at 2:53 pm
What is the resource setup you are dealing with?
It looks like your doing active/passive with you referring to moving the group. Give us some information on the setup...
November 15, 2002 at 2:43 pm
it might be worth mentioning that these top 1000 records will be selected by the heap order (order of insertion), unless the table has a clustered index, in which case...
November 15, 2002 at 2:37 pm
Task manager is running some job that is causing blocking.
Look and see What jobs are running in task manager when this happened?
Get The SQL text from your profile and...
November 15, 2002 at 2:34 pm
Sure, where to start?
There seem to be a lot of people working with EBCDIC files lately...
I will assume you can handle generating the BCP definition files. Here is a striaght...
November 14, 2002 at 9:41 pm
We generally remove replication and go through setting it up all over again, making sure to get rid of the distribution database. Its a pain. There is somewhere in the...
November 14, 2002 at 5:49 pm
You can contact the printers directly to get out of print books if you want, so the SAMS book is not out of the question.
However, I would suggest a lot...
November 14, 2002 at 5:42 pm
How are the subscribers setup? the transfer sends all the ddl and data to a temp directory where its read in. Do they have all the neccessary requirements?
and they have...
November 14, 2002 at 5:35 pm
I've never had any problems doing it....just make sure you do your backups...
November 14, 2002 at 5:31 pm
In the MSPRESS IT Edition series of books, it talks in several places about design methodologies, gives several charts explaining the roles of different participants, and goes into a lot...
November 14, 2002 at 5:28 pm
I send HTML mail using XP_Sendmail every day. Your Text message is the HTML code itself, add any pictures or sound you include as attatchments to the mail or in...
November 14, 2002 at 5:18 pm
Viewing 15 posts - 406 through 420 (of 518 total)