I don't know if this is an issue or not, but the example select is incorrectly written.

It specifies a LEFT JOIN, but since all the R.column filters are placed in...

Here's a way you can do it.

If I understand the question correctly, you want to strip out each letter that corresponds to each day in a month (like october).

This...

So this is your original data:

The' Big -- Blue Fox 'Jumped Over the fen'ce but couldn't

Turn off quoted identifer and add a double quote at the beginning and end works...

For 2005 the recommendation is to use sys.dm_os_performance_counters instead of the old sysperfinfo.

sys.dm_os_performance_counters requires VIEW SERVER STATE permission.

/Kenneth

What are you trying to determine?

If the agent is currently executing a job, or if the service itself is running?

/Kenneth

To make this as easy as possible for development, managing, maintenance, changes etc, and to insure the highest chance of success for this 'project' - Yes. Go for separate db's...

Well, there may be more problems down this path than perhaps is apparent.

What you're looking at is extensive use of dynamic SQL. This is a real Pandoras Box.

In order to...

Maybe a silly question, but why on earth does schema need to be an input parameter?

This is exactly the same as saying the table name must be an input parameter..

..or...

There's always a readme-file that goes with every hotfix / sp.

It's suggested to always read those, and it will be clearly stated in there if and how any given fix/sp...

This is a subject far to great for a single post on a forum.

I suggest you start from square one, and read this book:

http://www.amazon.com/Handbook-Relational-Database-Candace-Fleming/dp/0201114348

...that will provide the groundwork...

Not exactly. It's not entirely correct.

This is because the full name of a database is servername.dbname

Even when you have two instances installed on the same server, the servername part is...

Ambuj Mathur (4/8/2008)

---

Whatever you do, please be sure that you do not restart the server while the transaction is in the rollback state...this might lead to database going into 'SUSPECT'....

As long as you can throw enough hardware (resources) at just about anything, mostly things are fine from that perspective. (assuming coding is proper as well)

As I said, it depends...

I'd say stick to dbo as the owner, for making things much simpler.

Users vs groups is pretty much an administration issue.

Mostly it's easier to just set a group of permissions...

Agreed.

There seems to be nothing wrong with your DatabaseMail. It works just fine.

Any issues with mails not being recieved or such, is something with the SMTP server you're using.

/Kenneth