Viewing 15 posts - 21,016 through 21,030 (of 26,490 total)
Is this in a VB.NET or C# application or ASP.NET configuration file?
Have you looked up Connection Strings in the Visual Studio help files?
May 14, 2009 at 7:08 am
hb21l6 (5/14/2009)
May 14, 2009 at 7:03 am
Lynn Pettis (5/13/2009)
May 13, 2009 at 6:05 pm
Something else I'd look at since you want the insert to complete regardless of the processing in the trigger, look at Service Broker. Move the processing done inside the...
May 13, 2009 at 5:02 pm
rdprecure (5/13/2009)
Here is the connecton string:
Provider=SQLOLEDB;Data Source=machinename\sqlexpress;Initial Catalog=databasename;User Id=*****;Password=*****;
With the above connection string I get this error message:
Keyword...
May 13, 2009 at 4:30 pm
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
Viewing 15 posts - 21,016 through 21,030 (of 26,490 total)