richardmgreen1 (3/7/2014)

---

...I need to update 50 codes from the temp tables and I'm trying to find out the best way to do it (either 50 joins, 50 update statements or...

Does field [AbstractID] need to be datatype "varchar(44)"? This is quite a large field to JOIN upon...

And do you really need 50(!) JOINs of that same structure? Perhaps this single...

Take a look in the mentioned log file (this will point to more detailde log files) for more descriptive error messages.

You mentioned you allready installed SQL2012. Is this installed on...

You could probably rename a job, but when you alter a maintenance plan all jobs will be deleted and re-created from scratch. Your changes will be undone.

That's why I posted that remark with a smiley!

Have you read the rest of...

You can CAST the column with datatype NTEXT to a NVARCHAR(MAX) datatype. Next you can do a replace on that column. Something like:

select replace(cast(value as nvarchar(max)), 'string_to_find', 'replacement_string')

I have a folder on my diskdrive where I store all my (larger) scripts. When I'm working in a team I put these scripts on a network share so all...

As you probably are allready aware of, this is a bad table design ;-). Read up about normalisation (http://www.sqlservercentral.com/blogs/jamesserra/2012/01/06/normalizing-your-database/) for better design.

Now back to your situation: A possible solution is...

ISO is an extention for a DVD. You can burn the ISO to a writable DVD or use a DVD-ROM emulator to access the ISO as if it was inserted...

Yes, you can use that one for 180 days with all features.

Yes, the error points to a misspelled or removed profile name. Check the profile settings again in the database mail configuration and the SQL Agent properties.

If the problem persists you...

mattias.lundqvist (3/5/2014)

---

Hi

this how the columns look like and datetime should look like Column3

(Column3) ...

Use the query below to get a list of all mails sent from the instance during the last week. Take a look at the description column to see for any...

Like the previous poster (Ed Wagner) allready mentioned, it depends on how your integer values represent a particular date or time.

Can you post some sample values and include the date/time...

When you look at your messages window you'll notice the message "Warning: Null value is eliminated by an aggregate or other SET operation." which will explain your situation.

It is because...