Forum Replies Created

Viewing 15 posts - 256 through 270 (of 783 total)

  • RE: Login faield for user 'sa'

    SQLRNNR (5/4/2011)

    Another possibility is an app is trying to do something against that instance. Somewhere there is a connection string with sa in it that needs to be changed...

    Regards
    Sushant Kumar

    May 4, 2011 at 8:16 am

    #1319812

  • RE: Login faield for user 'sa'

    No Job is supposed to run every minute.

    Regards,

    Sushant

    Regards
    Sushant Kumar

    May 4, 2011 at 8:14 am

    #1319810

  • RE: How to transform table results into another table

    Koen Verbeeck (5/4/2011)

    So you have data in one table, you want to manipulate it with TSQL and put the results in another table.

    I would use an Execute SQL Task.

    Why does...

    Regards
    Sushant Kumar

    May 4, 2011 at 7:11 am

    #1319719

  • RE: How to transform table results into another table

    Koen Verbeeck (5/4/2011)

    What is a table named query?

    I only know about named queries in SSAS, so I'm not sure what it has to do with SSIS.

    When I import data from...

    Regards
    Sushant Kumar

    May 4, 2011 at 6:51 am

    #1319701

  • RE: How to transform table results into another table

    @ phil

    Exactly

    Regards
    Sushant Kumar

    May 4, 2011 at 6:49 am

    #1319698

  • RE: Stored proc output to Report

    thanks a lot

    Can you provide some links for all that stuff, so

    that i can read and understand the basics..

    Thanks

    Regards,

    Sushant

    Regards
    Sushant Kumar

    April 28, 2011 at 1:11 pm

    #1317495

  • RE: Backup Job error

    Yes there is enough free space on it...360gb out of 1.2TB is free.

    Regrds,

    Sushant

    Regards
    Sushant Kumar

    April 27, 2011 at 8:41 am

    #1316645

  • RE: Backup Job error

    I am storing the backup via job in SSMS to another server.

    Regards,

    Sushant

    Regards
    Sushant Kumar

    April 27, 2011 at 8:14 am

    #1316612

  • RE: Product level to low

    When I scheduled the SSIS package in sql agent job, and ran from there

    the error came up different :--

    Column 'Description' cannot convert between unicode and non unicode string data types...

    WARNING...

    Regards
    Sushant Kumar

    April 21, 2011 at 2:21 pm

    #1314713

  • RE: Data Import from SQL 2000 to SQL 2005

    Phil Parkin (4/15/2011)

    Have you tried connecting to the 2000 instance from within 2005 Management Studio? Once that's in place (use a linked server), you can just use standard queries to...

    Regards
    Sushant Kumar

    April 15, 2011 at 7:02 am

    #1312099

  • RE: What's Today?

    Horrible!!!

    This is sql server forum for people all over the world...

    How can u ask questions related to US....????

    Wat abt the people outside states??

    Regards
    Sushant Kumar

    April 15, 2011 at 6:53 am

    #1312087

  • RE: Data Import from SQL 2000 to SQL 2005

    Phil Parkin (4/14/2011)

    SKYBVI (4/14/2011)

    I think I am getting near to the answer of my own question...:-P

    So far, you haven't mentioned anything that can't be done in a stored proc ...

    How...

    Regards
    Sushant Kumar

    April 14, 2011 at 10:36 am

    #1311729

  • RE: Data Import from SQL 2000 to SQL 2005

    I think I am getting near to the answer of my own question...:-P

    Regards
    Sushant Kumar

    April 14, 2011 at 10:11 am

    #1311717

  • RE: Data Import from SQL 2000 to SQL 2005

    Phil Parkin (4/14/2011)

    SSIS can move data around as much as you want, but if you are new to the product you are going to have to spend some time getting...

    Regards
    Sushant Kumar

    April 14, 2011 at 10:09 am

    #1311715

  • RE: Service pack

    [Jim].[dba].[Murphy] (4/13/2011)

    Service Packs definately fix many issues, but also potentially alter the behavior of SQL Server too. They can include adjustment to how the Query Optimizer decides how to...

    Regards
    Sushant Kumar

    April 14, 2011 at 7:09 am

    #1311558

Viewing 15 posts - 256 through 270 (of 783 total)