Viewing 15 posts - 8,866 through 8,880 (of 9,244 total)
Why have you specified
exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Profiler'
twice
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 7:14 am
ALZDBA (9/27/2008)
I think my little article regarding sqlserver and SOx can help out.
its ok but i think he just wanted a quick and dirty guide on the usage of the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 6:48 am
roger this is the clue 😉
Roger Abram (9/30/2008)
Msg 19055, Level 16, State 1, Procedure sp_trace_setfilter, Line 1Filters with the same event column ID must be grouped together.
can you post the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 6:32 am
SanjayAttray (9/29/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 6:29 am
Carlton Leach (9/29/2008)
restore the MSDE DB's to 2005
that's exactly what you do
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 6:25 am
BOL is a good start
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 6:23 am
as a side make sure you change the account details via SQL configuration manager 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 6:21 am
the datareader role should grant select to all tables
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 6:16 am
you should be able to patch both instances at once, did you select both detected instances?
Have you checked the patch log file to find out why it failed?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 6:14 am
Mike (9/29/2008)
My current VM Instances are configured with 20 gig of hd space and 2 gig of memory
wow as little as that. 20GB will just about home the OS,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2008 at 2:16 pm
ramyours2003 (9/15/2008)
how can we solve space issue in sql server?
stick it on the moon then its got all the space it needs.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2008 at 9:52 am
dakshinamurthy (9/26/2008)
I would like to start and store the sql profiler trace in a location, but it should be automated, i mean to say instead of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2008 at 9:47 am
onlo (7/2/2008)
However, I found both of its "Total Server Memory" & "Target Server Memory" are far below the physical...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2008 at 4:54 pm
steveb (9/22/2008)
You will need a different maintaince plan for T-Logs and Full Backups.
you can use 1 maint plan if you like, launch the wizard and it asks "schedule for each...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2008 at 2:21 pm
Ray Herring (9/23/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2008 at 2:11 pm
Viewing 15 posts - 8,866 through 8,880 (of 9,244 total)