Forum Replies Created

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

  • RE: Adding additional filegroups to a database on a virtual server?

    Lisee (8/11/2011)


    I believe they can set up additional virtual drives.

    I'm not sure about the RAID.

    I know there had been discussion that if the project did explode in...

  • RE: Today's Random Word!

    SQLRNNR (8/11/2011)


    Strengths

    Weakness

  • RE: Cannot open tables in Database

    Have you tryed seeing if there is a repair or recreate through SharePoint? Because I know this is a typical name of SharePoint.

  • RE: Adding additional filegroups to a database on a virtual server?

    I have found when dealing with VM's. Find a good size for the log files to cut down on the growth of the log files and that usally has a...

  • RE: Cannot open tables in Database

    So you already have fixed the isssue? Please post results of what you did for anyone else looking.

  • RE: Offline info

    Beginner2008(8/11/2011)


    I use dbcc loginfo('database')

    to see the status...

    i want to see vlf status....

    You are not making any since. The dbcc loginfo command returns the status of the virtual log files within...

  • RE: Cannot open tables in Database

    Do you have a recent backup? it looks like it is corrupt database based on this "Check statement terminated due to unrepairable error"

  • RE: Offline info

    What log info? SQL Agent Log, Error Log, Log on .....etc??????

  • RE: Very cool problem -- with Dymamic SQL, Backups/Restores, and variables (maybe)

    How about this code you can tweak it to do what you want:

    create table ##fileTable (id int identity(1,1),Files varchar(max))

    insert into ##fileTable

    exec master.dbo.xp_cmdshell 'dir C:\Test\'

    --select * from ##fileTable

    DELETE from ##fileTable...

  • RE: Today's Random Word!

    Daniel Bowlin (8/11/2011)


    Ziggy Stardust

    Itchy and scratchy

  • RE: Very cool problem -- with Dymamic SQL, Backups/Restores, and variables (maybe)

    skcadavre (8/11/2011)


    I already showed osql here.

    I understand you showed that here but----

    jpSQLDude (8/10/2011)


    But basically what y'all are saying is there is no way to take the output of...

  • RE: Today's Random Word!

    Ray K (8/10/2011)


    Evil Kraig F (8/10/2011)

    --------------------------------------------------------------------------------

    bopeavy (8/10/2011)

    --------------------------------------------------------------------------------

    crookj (8/10/2011)

    --------------------------------------------------------------------------------

    bopeavy (8/10/2011)

    --------------------------------------------------------------------------------

    SQLRNNR (8/10/2011)

    --------------------------------------------------------------------------------

    Daniel Bowlin (8/10/2011)

    --------------------------------------------------------------------------------

    bopeavy (8/10/2011)

    --------------------------------------------------------------------------------

    SQLRNNR (8/10/2011)

    --------------------------------------------------------------------------------

    pitty

    Hole

    in one!!

    Fore

    Three, Two, One

    Blast Off!!!

    Major Tom

    Can you heeeaarrrr meeeee.... sitting...

  • RE: Today's Random Word!

    IDK

  • RE: Very cool problem -- with Dymamic SQL, Backups/Restores, and variables (maybe)

    You could try osql or bcp. You would just need to put your results into a table to output.

    --osql.

    declare @cmd varchar(1000)

    select @cmd = 'osql -U -P -S -Q"select *...

  • RE: Today's Random Word!

    crookj (8/10/2011)


    bopeavy (8/10/2011)

    --------------------------------------------------------------------------------

    SQLRNNR (8/10/2011)

    --------------------------------------------------------------------------------

    Daniel Bowlin (8/10/2011)

    --------------------------------------------------------------------------------

    bopeavy (8/10/2011)

    --------------------------------------------------------------------------------

    SQLRNNR (8/10/2011)

    --------------------------------------------------------------------------------

    pitty

    Hole

    in one!!

    Fore

    Three, Two, One

    Blast Off!!!

    Major Tom

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