Viewing 15 posts - 46 through 60 (of 331 total)
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...
August 11, 2011 at 12:57 pm
Have you tryed seeing if there is a repair or recreate through SharePoint? Because I know this is a typical name of SharePoint.
August 11, 2011 at 8:55 am
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...
August 11, 2011 at 8:52 am
So you already have fixed the isssue? Please post results of what you did for anyone else looking.
August 11, 2011 at 8:40 am
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...
August 11, 2011 at 8:37 am
Do you have a recent backup? it looks like it is corrupt database based on this "Check statement terminated due to unrepairable error"
August 11, 2011 at 8:31 am
What log info? SQL Agent Log, Error Log, Log on .....etc??????
August 11, 2011 at 8:29 am
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...
August 11, 2011 at 8:23 am
Daniel Bowlin (8/11/2011)
Ziggy Stardust
Itchy and scratchy
August 11, 2011 at 6:54 am
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...
August 11, 2011 at 6:10 am
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...
August 10, 2011 at 6:40 pm
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 *...
August 10, 2011 at 1:39 pm
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
August 10, 2011 at 11:18 am
Viewing 15 posts - 46 through 60 (of 331 total)