Viewing 15 posts - 21,016 through 21,030 (of 26,484 total)
Scott Coleman (5/13/2009)
-- Get the initial transaction nesting level (will be...
May 13, 2009 at 3:43 pm
Is there a reason you are attempting to use dynamic sql instead of the code (or something similar) that I had provided? It would seem to me that would...
May 13, 2009 at 3:38 pm
I'd say that a heavily used IIS WebSite/Server should be logging to text files and then load those log files on a scheduled basis. I used direct logging of...
May 13, 2009 at 3:35 pm
Glad I was able to assist. As for the syntax highlighting, I used the IFCodes [ code ][ /code ] (no spaces inside the brackets).
May 13, 2009 at 1:19 pm
Run this query. You may find that a full backup was run between the differential backups you successfully restored and the one you didn't.
select * from msdb.dbo.backupset
May 13, 2009 at 11:00 am
Jacob Pressures (5/13/2009)
May 13, 2009 at 10:48 am
This function:
/****** Object: UserDefinedFunction [dbo].[DelimitedSplit] Script Date: 05/13/2009 09:25:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE function [dbo].[DelimitedSplit] (
@pString varchar(max),
@pDelimiter...
May 13, 2009 at 9:29 am
I have a two year old HP laptop with a 17" display. Yes, I wish the battery lasted longer and it is a bit slow at times. It...
May 13, 2009 at 9:16 am
John Sansom (5/13/2009)
This of course does not work, unless the folder structures are in place on the system in question. Otherwise errors of the form below are returned.
Msg 5133, Level...
May 13, 2009 at 8:24 am
John Esraelo (5/12/2009)
You must also consider the fact that there are "volunteers" out there that are trying to assist others and yet can not understand...
May 12, 2009 at 1:12 pm
Florian Reischl (5/12/2009)
Alvin Ramard (5/12/2009)
You can sing that at our next meeting, next week.Send me a link when it's online!
Might not like this idea, but make it a video and...
May 12, 2009 at 1:06 pm
John Esraelo (5/12/2009)
You must also consider the fact that there are "volunteers" out there that are trying to assist others and yet can not understand...
May 12, 2009 at 12:22 pm
John Esraelo (5/12/2009)
I do not see any relevance here but to satisfy your curiosity;-); let say ad-hoc!!
Okay, first, you aren't getting hammered on this site. I am trying to...
May 12, 2009 at 10:36 am
No. A differential backup is all the changes since that particular full backup. You can not apply a differential backup taken after one full backup with one taken...
May 12, 2009 at 10:30 am
John Esraelo (5/12/2009)
The caller needs to get a table value PERIOD.
How is it being called? Is it a Report? Is it an application? ...
May 12, 2009 at 10:20 am
Viewing 15 posts - 21,016 through 21,030 (of 26,484 total)