Home Forums SQL Server 7,2000 General Determinating the space used in specific user table(s) RE: Determinating the space used in specific user table(s)

  • Good afternnon, thanks for your idea, but its a little bit confusing for me this expression:

    i know the characret + is used to concatenate but the expression 'exec sp_spaceused '''

    itself what does mean?, when should i use simple quotes or doble quotes, and the construction of this instruction gets me a syntax error,

    when using double quotes:

    "select 'exec sp_spaceused ''' + name + '' from sysobjects where type = 'U' and name like 'paso_hechos%'"

    error: Could not find stored procedure 'select 'exec sp_spaceused ''' + name + '' from sysobjects where type = 'U' and name like 'paso_hechos%''.

    without double quotes:

    select 'exec sp_spaceused ''' + name + '' from sysobjects where type = 'U' and name like 'paso_hechos%'

    output:

    exec sp_spaceused 'PASO_HECHOS_TRAFICO_ABONADO

    exec sp_spaceused 'PASO_HECHOS_TRAFICO_LLAMADAS

    exec sp_spaceused 'PASO_HECHOS_TRAFICO_LLAMADAS_CDRS_TARJETA

    exec sp_spaceused 'PASO_HECHOS_TRAFICO_LLAMADAS_ENTRANTE_ELITE

    what is wrong with the above sentences?

    id appreciate again your help