Forum Replies Created

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

  • RE: multiple joins

    Are there any missing entities in your join? I'm (probably wrongly) assuming that there can be several contributiong factors to an accident/driver. What is the definition of the...

  • RE: Query performance (7.0 SP4)

    Can you test on another server at SP4 to possibly isolate whether it's indeed an SP4 problem or maybe a problem with your server's tempdb?

    Cheers,

    - Mark

  • RE: Query Results in job notification

    Unfortunately job notifications will not show such information. You need to look at the job history to see such information.

    Cheers,

    - Mark

  • RE: Database suspect status~

    It appears your database is truly corrupted and attempts to reset the status will not be successful (as you've found out).

    Do you have a recent full backup to restore from?

    Were...

  • RE: Memory usage

    quote:


    What am I looking at when I run "DBCC MEMUSAGE"? dbid and objectid I got, but units of measurement is "Buffers",...

  • RE: Enterprise vs. Standard Edition

    Look up "editions of SQL Server" in BOL's index. The most relevant topics are "Maximum Capacity Specifications" (where, if you scroll down, you'll come to number of CPUs and...

  • RE: Import Excel spreadsheet to .adp file

    quote:


    now that we will soon be having an Access forum


    Are we? Shows how much...

  • RE: "median" stored procedure

    I've tried another method of grabbing the middle rows. Using TOP to get the top half (and a bit) of the rows, and TOP again to get the bottom...

  • RE: restore error

    Do you get any joy from a RESTORE HEADERONLY or from a RESTORE VERIFYONLY?

    Cheers,

    - Mark

    Edited by - mccork on 08/14/2003 9:48:27 PM

  • RE: Import Excel spreadsheet to .adp file

    I don't know if this is the right forum for Excel to Access questions, but I'll have a go anyway....

    Is it possible that any of the column headings aren't valid...

  • RE: Collation Sequence Changing (850 to 1252)

    I could only think of "warnings" (in which fapel isn't interested). I have no facts on why it wouldn't work. I can only strongly recommend following documented MS...

  • RE: Dealing with special characters

    Your could create a UDF that could be called from a CHECK constraint to prevent unwanted characters being entered. Or, it could be used by an INSERT/UPDATE trigger to...

  • RE: Passing data between 2 tables

    Unfortunately you can't BCP between tables.

    Maybe a future version will have a BULK EXTRACT to complement BULK INSERT, or BULK INSERT from a table?

    You can use DTS but...

  • RE: SQL 7 - Set Single_User

    Thanks Jimmy.

    Time zone sometimes prevent a prompt reply.

    Cheers,

    - Mark

  • RE: String Output in a Stored Proc

    quote:


    The conversion error is actually happenning when I attempt to set the value of @_Out_TradeCID


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