Is there any pattern to how people connect as to which works and which doesn't.  Everyone using the web interface should be fine because you just need to change it...

Are both applications using the OLEDB driver, or is one using ODBC and the other OLE?  Was a security patch deployed yesterday or the day before?  If so what was...

What are the client trying to connect to your database for?  Is this an app that's on thier desktops, a web application, or are you talking about the db client tools?

Is...

It's because 'IS' is a reserve word.  It's just a good idea never to name things that are keywords/Reserved words, but since this is how it is...

Typically you can use...

Yes but in that case you'd probably need to set up some sort of cursor to loop over each database if you want this all executed in one job, and...

Have a look at the sp_MSforeachdb undocumented MS stored Procedure.  You can read about it by searching on this site or reading this...

http://www.databasejournal.com/features/mssql/article.php/3441031

Unfortunately the answer to your question is... It depends.

What is your ability for downtime (can you be down 1 minute, 2 or 15, up to an hour)?  Are you talking...

Sreejith is absolutely correct.  The easiest way I've found to effect password changes on DTS jobs and the connections within them is to make use of Windows Authentication.  Create yoruself...

I look at it as help and also something to hurt you.  I think it will help grandma from her machine being turned into a bot, maybe.

I also so it...

5 years ago I was unemployed after having gotten married and moved a few hundred miles from where I last resided, so I'm definitely working more.

I did however just get...

I agree with many of the other posters that have said that the page peel is MUCH less intrusive than the double underlined words.  As has been said many time...

I think this is fantastic news.  I've been a PostgreSQL supporter for years, even as so many applications and people have switched to mySQL.  It's great to see someone leveraging the...

Could be a simple as a bad cable, or as complex as a switch with a bad port, An intremitently screaming NIC, router etc.

Simply put, It could be justy about...

Is this a SMTP server on your local network, or are you across a WAN/MAN, or is it your ISP's SMTP server? 

If it's yours, check your SMTP server log...

Also what service pack levels are they?  Is your development machien the same as the server you are trying to open the Packages on etc.?