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?

hb21l6 (5/14/2009)

---

please note: all comments listed below are my personal opinion, all rights reserved for changing at anytime. and not to be taken literally. as It refers to any manufacturers...

Lynn Pettis (5/13/2009)

---

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...

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...

rdprecure (5/13/2009)

---

Hello, I am trying to connect to SQLExpress from an ASP.Net web app.

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...

Scott Coleman (5/13/2009)

---

The tricky thing about savepoints is that after rolling back to a savepoint you still have to do a COMMIT.

-- Get the initial transaction nesting level (will be...

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...

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...

Glad I was able to assist. As for the syntax highlighting, I used the IFCodes [ code ][ /code ] (no spaces inside the brackets).

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

Jacob Pressures (5/13/2009)

---

Do I have to break this query into two different queries? It works perfectly fine when i break it apart. But it just seems strange to have to...

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...

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...

John Sansom (5/13/2009)

---

Hi,

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...

John Esraelo (5/12/2009)

---

Nice posting by you, very nice...

You must also consider the fact that there are "volunteers" out there that are trying to assist others and yet can not understand...