Forum Replies Created

Viewing 15 posts - 12,991 through 13,005 (of 26,486 total)

  • RE: Add user with Admin Access

    djustice 20821 (4/11/2012)


    I need to give them full access to everything.

    Please define full access to everything. Do they need only access to a specific database or the entire server?

  • RE: Wasting Time

    jfogel (4/11/2012)


    I'm surprised there isn't a huge amount of complaining about smoke breaks. Myself and nearly every other DBA I've know smoke. There has never been a shortage of people...

  • RE: CTE Usage

    GilaMonster (4/11/2012)


    Semicolons are statement terminators, as such they should terminate statements, not start them. We don't start sentences in English with fullstops.

    I agree with Gail. I have gotten into...

  • RE: Table Column with only time

    jkount 49745 (4/11/2012)


    Problem Solved.

    Ty all for fast replies.

    Keep up the good Job

    Forum etiquette would have you tell us how you solved the problem. Your solution may help others with...

  • RE: sql server

    asranantha (4/10/2012)


    if u know answers plz tell me

    Why don't you do your own research and try to answer your questions yourself? As you do the research if you have...

  • RE: Mirroring Error

    Perry Whittle (4/10/2012)


    jitendra.padhiyar (4/10/2012)


    Yes Pettis,

    I selected the option " Restore With Norecovery" during restore of db. But still the same status.

    you also need to take and restore at least 1...

  • RE: Group Current and Previous Month of 22-Work-Day-Dates By a "Group Number"

    I missed the middle column of numbers, sorry.

  • RE: Group Current and Previous Month of 22-Work-Day-Dates By a "Group Number"

    Something doesn't look right. The first column of dates goes from 2 to 3 with gaps. The second column goes from 21 to 2 with no gaps.

  • RE: Mirroring Error

    jitendra.padhiyar (4/10/2012)


    Yes Pettis,

    I selected the option " Restore With Norecovery" during restore of db. But still the same status.

    That is right, it isn't going to change. Now you need...

  • RE: Mirroring Error

    The mirror database needs to be in restoring mode for you to configure database mirroring. That is why the instructions say to restore the backup using WITH NORECOVERY.

  • RE: Backup & Restore Oracle DB!

    rocky_498 (2/12/2012)


    Hi guys,

    I am very new in Oracle. I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like...

  • RE: Banker''s rounding in T-SQL (like Math.Round in .NET)

    If anyone is interested, I just rewrote my scalar function as an inline table valued function:

    create function dbo.itvf_BRound(

    @val decimal(38,20),

    @pos int

    ) returns table...

  • RE: Reading microseconds from Sql server into oracle 10g

    Out of my depth. Oracle experience is light and I didn't have to pull data from a SQL Server database over a DBLINK.

  • RE: Reading microseconds from Sql server into oracle 10g

    caramelkaps (4/10/2012)


    I meant to say milliseconds....whatever it records after seconds I want to bring it over to oracle.

    any value after seconds is currently becoming 00000 in oracle.

    Also I tried using...

  • RE: Reorganize Index Task

    GilaMonster (6/14/2010)


    It's generally not a good idea to rebuild all indexes on all tables on anything other than a tiny database. The log impact and the time required just become...

Viewing 15 posts - 12,991 through 13,005 (of 26,486 total)