Forum Replies Created

Viewing 15 posts - 166 through 180 (of 331 total)

  • RE: Specified cast is not valid error

    EasyBoy (11/12/2010)

    When we are login to our development server we are getting specified cast is not valid error.

    Can anyone please let me know what would be the cause/

    I have attached...

    Thanks
    Parthi

    November 12, 2010 at 5:45 am

    #1249940

  • RE: STATS_DATE return NULL

    Hardy21 (11/12/2010)

    Yes there are 6 rows in the table and index_id = 1 (its primary key). In same table, there are other indexes that has statistic date and their index...

    Thanks
    Parthi

    November 12, 2010 at 5:38 am

    #1249935

  • RE: STATS_DATE return NULL

    Hardy21 (11/12/2010)

    Hello,

    When I fire following code, few records has StatisticsDate as NULL though it is primary key:

    select object_name(i.object_id), i.name, STATS_DATE(i.[object_id], i.index_id) AS StatisticsDate

    FROM sys.indexes i

    What...

    Thanks
    Parthi

    November 12, 2010 at 12:49 am

    #1249858

  • RE: How to print query including line number in SMS?

    adonetok (11/10/2010)

    How to print query including line number in SMS? Line number is display but missing in printing.

    hi

    Try with Row_number() it will give you the line number in your case

    eg:

    Select...

    Thanks
    Parthi

    November 10, 2010 at 8:32 am

    #1248926

  • RE: Recover database on missing Tlog's

    ps. (11/10/2010)

    What about your database on source server. Is it in restoring state? you said you are restoring on a different server.

    On source server there is no space thats...

    Thanks
    Parthi

    November 10, 2010 at 6:38 am

    #1248816

  • RE: Recover database on missing Tlog's

    ps. (11/10/2010)

    Is your database accessible right now? are you trying to restore it to some other server or same server?

    Hi

    Database is in restoring state

    No i...

    Thanks
    Parthi

    November 10, 2010 at 6:25 am

    #1248803

  • RE: Recover database on missing Tlog's

    muthukkumaran (11/10/2010)

    Nope not possible.(upto t3)

    Is it production database ?

    Find out its is deleted or moved.

    Hi

    It is not production it is local some one has deleted the...

    Thanks
    Parthi

    November 10, 2010 at 5:56 am

    #1248782

  • RE: TSQL 2K5 - How to get All parent tables followed by all child tables in one select

    Hi

    Try With

    Select * from INFORMATION_SCHEMA.<view_name>

    this might have solutions for you

    Thanks

    Parthi

    Thanks
    Parthi

    November 9, 2010 at 8:49 am

    #1248357

  • RE: How to list all the objects of another server

    reggae_blur (11/9/2010)

    Parthi,

    Running the query below in Server A gives me an "Invalid Object Name" error...:-)

    SELECT * FROM ServerB.sysobjects

    Try this

    SELECT * FROM [ServerB].Tempdb.dbo.sysobjects

    Thanks

    Parthi

    Thanks
    Parthi

    November 9, 2010 at 7:03 am

    #1248256

  • RE: How to list all the objects of another server

    Hi

    If you are not allowed to have link server then why do you want to query in serverB

    You have to create link server...

    Thanks
    Parthi

    November 9, 2010 at 6:29 am

    #1248211

  • RE: Suspect Database

    vgtestingg (11/9/2010)

    Hi Everyone,

    I am working in SQL Server 2008. My database is displaying "Suspect" in front of database name. Can anyone suggest me, How can I remove...

    Thanks
    Parthi

    November 9, 2010 at 5:59 am

    #1248183

  • RE: Need help with writing TSQL

    Hi,

    Find the below way i have tried

    declare @Temp table (Changedate datetime, stepid int)

    declare @Temp1 table (Changedate datetime, stepid int,Types bit)

    insert into @Temp

    ...

    Thanks
    Parthi

    November 9, 2010 at 5:44 am

    #1248174

  • RE: Retrieve records from a table.

    Hi

    You can have this way

    declare @Temp table (EmpId int, EmpName varchar(50), MngrID int)

    insert into @Temp

    Select 1, 'aaa', 4

    union Select 2, 'bbb', 3

    union Select 3, 'ccc', 4

    union Select...

    Thanks
    Parthi

    November 9, 2010 at 4:57 am

    #1248155

  • RE: How to remove "" in flat file

    steveb. (11/8/2010)

    In the TextQualifier option box on the flat file conntection screen add " into it

    Thanks. It Worked for me so what is the use of TextQualifier ?whether for...

    Thanks
    Parthi

    November 8, 2010 at 8:50 am

    #1247702

  • RE: Date Difference Between to dates

    shanu.hoosen (11/4/2010)

    please check your scripts. you got 4 columns and inserting 3 values.

    HI

    Did u run that script and had the tally table with you.I dont find any issue...

    Thanks
    Parthi

    November 8, 2010 at 3:04 am

    #1247543

Viewing 15 posts - 166 through 180 (of 331 total)