LOGINPROPERTY doesn't show that (bol ref http://msdn.microsoft.com/en-us/library/ms345412.aspx)

Off course you can enable login recording to sqlservers errorlog file, but you'll have to process that yourself and off cours, depending on the...

Let's see what full error info OP provides and work from there on.

since we don't know the actual dbcc output .....

If...

Still ... NO NO NO convert to the correct datatype !!!!

Declare @data varchar(MAX)

, @Delimiter char(1)

Select @data= '3/8,3/9,3/10,3/11'

, @Delimiter...

Post the actual dbcc output !

Can you drop and re-create all indexes of that / those tables ?

First of all .... buy huge servers to be able to cope with the little load you need !

Use the correct data type for your columns and make it mandatory.

Only...

simply sead :

Powershell is the new vbscript.

SQLCMD is only intended for usage related to sqlserver.

So .... two different worlds with a bit of overlap.

SQL2008 right ?

Check books online ! "Backing Up and Restoring Replicated Databases "

I would just feed the varriables value in a "variables" table and have the job or dts pick it up from there.

I stongly discourage this kind of constructs.

sp_oa stuff is known to frequently suffer memory leaks, ... which may cause your sql instance to be unstable and crash or reboot.

Workaround:

Create...

You should provide as much error info as possible !

Error text, sqlserver errorlog info, sqlagent.out logging info, ...

As well as your used setup scipt! (of...

IMO it shouldn't matter if you have only one db with a single user, or 100 db with n users.

The cost of having a systems db backup should not...

Well ... in your typical scenario .... there shouldn't be any user databases !

From the moment you add a user database, you should have a DRP in place !

That DRP...

Yes, Yes, Yes ....

- master is a must !

- resource db files .... maybe ... so YES too ! but only once after every install/hotfix/cu/sp

- model ? I don't,...

I join Lynn in the advise !

sp_send_dbmail is the way to go !

Have a look in books online to see how (easy) sp_send_dbmail can serve you.

It has nice features (profiles,...