Forum Replies Created

Viewing 15 posts - 46 through 60 (of 167 total)

  • RE: T-SQL script

    Thanks LutzM!

    I have attached the data in ready to use format (INSERT INTO TABLE () SELECT VALUES()).

    Also attached sample data in xls format as well as .txt format.

    User's last...

  • RE: Backup Job history shows nothing

    ssismaddy (7/15/2011)


    In the Job Properties ->Steps, Edit the step and go to advanced. You will find include step output in history, check that option.

    Perfect. Now I see the Job view...

  • RE: Backup Job history shows nothing

    Hi John, Thanks for your reply.

    Created a scheduled plan in maintenance plan itself. So automatically job is created and running as per schedule.

    This is only maintenance plan I created in...

  • RE: error : subquery returned more than 1 value

    LutzM (7/6/2011)


    The error message usually include a line number to point you in the right direction.

    It can be any of the three updates using a subquery.

    The TOP 1 ORDER BY...

  • RE: SSIS package execution error

    I have corrected the metadata in data source and ran the package, still getting error

    Package execution results:

    ….

    [Flat File Destination [61]] Error: Data conversion failed. The data conversion for column "entryanswersfreetext"...

  • RE: SSIS package execution error

    rgtft (7/1/2011)


    What happens when you change your data source's SELECT to put double quotes around that field?

    SELECT '"' + [FreeTextColumn] + '"' AS QuotedFreeTextColumn

    I am getting package validation error.

    Package validation...

  • RE: SSIS package execution error

    most of the rows have a "

    also have comma's in most of the rows.

    Is there any way in SSIS package to resolve this and export the data correctly into...

  • RE: NonClustred Index on Primary key vs Clustred Index on Primary key

    Hi Krish,

    Indexes are stored separately from tables, thus overall database size increases. A properly selected index can increase performance. A poorly selected index can actually slowdown your database.

    When to use...

  • RE: backup

    PaulB-TheOneAndOnly (6/24/2011)


    laddu4700 (6/24/2011)


    Any idea what is evault backup and difference between evault and SQL agent backup jobs?

    Yes! 🙂

    I did't get you.

  • RE: SQL Server 2008 DB diagram

    And also wondering can I take the hardcopy of diagram?

    Not sure what you are asking? Do you mean print the ERD from Visio?

    [/quote]

    Yes, I meant taking print -hard copy of...

  • RE: using Index in different systems

    Is it fair to provide the unique identifier (generated by our system).

    Just wondering how they sync username with unique identifier in their system

    any suggestions for best practice. THanks

  • RE: delete rows

    Resolved.

    parent table column referring itself. that is why my sp is getting error nesting level exceeded (limit 32).

    I have modified SP and it worked

    WHERE SO2.Name = @cTableName and so1.name <>...

  • RE: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

    Hi,

    Looks like my question is related to this thread.

    I am trying to delete some rows in parent table and related rows in child tables. I am using below sp, but...

  • RE: delete rows

    Thank you for your reply.

    i did't get you exactly

    But I am trying to update the sp, updating in where clause will work it seems.

    WHERE SO2.Name = @cTableName

  • RE: security events in sql server 2008

    thanks, how can i do this, you mean setup a trace in sql profiler

    In SQL 2008, I could see audit option, is these security events are possible to track with...

Viewing 15 posts - 46 through 60 (of 167 total)