Forum Replies Created

Viewing 15 posts - 406 through 420 (of 518 total)

  • RE: how does this execute

    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...

  • RE: "Real" execution plan for a user-defined function

    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...

  • RE: Problem importing AS400 generated text file

    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...

  • RE: Update a table's multile columns in a sub query

    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...

  • RE: Cluster Problem HELP

    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...

  • RE: how does this execute

    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...

  • RE: Lock:Timeout

    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...

  • RE: locking

    It is if that app is creating a database.

  • RE: Problem importing AS400 generated text file

    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...

  • RE: Merge Replication - Can't Remove

    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...

  • RE: Where are all the Replication books?!

    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...

  • RE: Problems replicating - sql2000 and MSDE

    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...

  • RE: Version of SP on Client Side

    I've never had any problems doing it....just make sure you do your backups...

  • RE: Formal Design Methodologies

    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...

  • RE: SQL Mail and SMTP

    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...

Viewing 15 posts - 406 through 420 (of 518 total)