1and1 also do Sharepoint hosting 1and1 Sharepoint

If the need is there I have 5 hours a week I can provide.

Some of the RSS work and others don't, seems to be very random. Also I've seen delays of a couple of hours before items show up in the feed.

Filesteam datatypes only work on the local system, you'll not be able to use a samba share.

Here's some activex that we use to check for a file and depending upon whether or not it exists you choose a different workflow, this can be used for looping

'**********************************************************************

'...

I have a loop which performs a file check, if the file does not exist it goes back to sleep for 10 minutes and then tries again. Once the file...

CirquedeSQLeil (4/6/2010)

---

Kit G (4/6/2010)

---

Perhaps there should be a series of small labs, like a problem on query tuning, another on restoring a database, another on indexing, another on normalization of...

I use a trigger on the sysjobhistory table.

It sends emails to different people depending upon the job and it's completion.

So on the Protocol tab you have

-Enabled Yes

-Keep Alive 30000 (example value)

-Listen All Yes

Have you changed the values under IPAll and set

-TCP Dynamic Ports to nothing (leave blank)

-TCP Port...

CirquedeSQLeil (4/1/2010)

---

Is this a default instance or a named instance?

It also looks like you are still using port 1533 - thus it is still a static port configuration.

Here is an...

How about your client? Checked to make sure that's attempting to use TCP/IP?

Just a note with native compression, make sure that you are running SP1 or greater. There was a bug that would cause the backup process to sit in a hung...

The error you've posted states that you aren't able to connect with named pipes, can you check that you have SQL listening on TCP/IP?

Take a look at this best practices article from the SQLCat team out on MSDN http://msdn.microsoft.com/en-us/library/dd894051.aspx. It's got some really in depth information and a graph that shows the difference...

As Shawn pointed out, you need to declare the variable before you can use it

DECLARE @message varchar(255)

set @message = 'Enjoy a wonderful Spring break!';

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'yourProfile',

@recipients = 'GemMine@gmail.com', --...