Forum Replies Created

Viewing 15 posts - 196 through 210 (of 331 total)

  • RE: Which table is used last

    Any other 3rd party tool can solve this.

    Trigger or not good to used on all the tables in the DB

    Server side trace may be good for one point of time...

  • RE: Which table is used last

    GilaMonster (10/27/2010)


    Server side trace, triggers. Maybe extended events, I'm not familiar with them. Also maybe worth a look into Change tracking/change data capture and SQL audit.

    There's a fair few more...

  • RE: Which table is used last

    GilaMonster (10/27/2010)


    Server side trace, maybe extended events, triggers will also work since you mean modification only. The info is not tracked automatically.

    I seriously hope those are not the real names...

  • RE: How to Add Line feed in query result

    xyzxyzxyzxyz123 (10/26/2010)


    Hello

    I have a query where I have to append line feed in one column result among 8 columns like below

    Month Name Amount ...

  • RE: Need DateTime format and count of records

    srisagar_p (10/25/2010)


    Hi all,

    I need small query which determines DateTime and count of records of a table.

    Example:

    Table1: this table has records like...

  • RE: How to run a Remote sql job

    balaji.ganga (10/25/2010)


    Hi All,

    How can i execute a job from one server to other server?

    Say for example: lets Server A having backup job. so i...

  • RE: sql server blocking issue

    sqlserver.0606 (10/25/2010)


    hi frnds can u please give the solution for my problem

    finding and sending alert message when blocking occurs by using Storeprocedure

    hi

    Find this it may help you

    http://support.microsoft.com/kb/271509

    Thanks

    Parthi

  • RE: SSIS Rollback Transaction

    fenwicc (10/22/2010)


    We have some ETL jobs that feed our data warehouses. If you try to insert a duplicate primary key, the primary key constraint should cause the update to fail....

  • RE: Error in Execute SQL Task

    Hi

    What is the Version u are using ?

    This problem occurs because of memory utilization after you install SQL Server 2005 SP2. When you use SMO to generate SQL...

  • RE: SSIS Rollback Transaction

    Hi

    Any one has any idea about how to proceed for the above.It is on urgent

    Thanks

    Parthi

  • RE: Delete Records older than 90 days

    div4u22 (10/20/2010)


    I have two tables one contains @300 millions records & the other contains @ 500 millions of record.I want to create two stored Procedure that will delete records older...

  • RE: SSRS

    Raunak Jhawar (10/18/2010)


    Parthi,

    How many times did you tried before posting the query?

    Try using google. It helps!!!

    Please follow here

    I tried as the above but i was not OK for...

  • RE: SSIS's example in a single point

    chandrakala_h_s (10/15/2010)


    Thanks Parthi.... its sorted.....:-) i changed the column width values in the advanced option as u said....

    I am glad that i could help u in solving ur problem

    Thanks

    Parthi

  • RE: SSIS's example in a single point

    chandrakala_h_s (10/15/2010)


    hi,

    Can nyone hlpout on dis err...!!!!

    [Flat File Source [1]] Error: Data conversion failed. The data conversion for column "Column 1" returned status value 4 and status text "Text was...

  • RE: Fibre Channel vs NFS for Data and Log files

    GilaMonster (10/13/2010)


    NFS?

    NFS-->NETWORK FILE SYSTEMS

    storing of data tro network file share system

    http://en.wikipedia.org/wiki/Fibre_Channel

    http://en.wikipedia.org/wiki/Network_File_System_(protocol)

    Thanks

    Parthi

Viewing 15 posts - 196 through 210 (of 331 total)