Have a look on below link

http://blogs.digineer.com/blogs/jasons/archive/2007/08/20/identify-reporting-services-version-and-edition.aspx

same here...

Its not going to hurt the server performance either.

It still fails for me

Message

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2009-04-07T08:45:10). Exception Message: Cannot send...

That's great ! how u got that port number is 587, not 465 as provided by google.

Try this and let us know -

BACKUP DATABASE [Navision Live] TO Navision_device

GO

As name of your database contains space, sql will give syntax error, you should use square bracket "[]"...

I tried gmail - never worked.

then i tried other free POP/SMTP server hotpop.com , the smtp address is smtp.hotpop.com , port number 25

although it also failed for me,...

By putting varchar instead of char, it started handling blank and single space properly. But it is not recognizing between single space and more than one space.

set ansi_padding OFF

drop...

If i have understood your problem properly, let me rephrase

1. You want to run a script which is dynamic in nature

2. You dont want to update ur DTS /...

Ok, based on the situation and problem you provided, I can provide a workaround for this problem.

This workaround is -

1. not recommended to use, unless you are very confident...

Mike Levan (4/4/2009)

---

Actually here is what i am trying to acheive..

I have PRoduction and Stage Server.

1. Restore production database "Employees" backup onto stage

2. Update stage with latest data

3. Backup stage...

this is not a proper way to post any problem, please describe clearly. If I am not wrong this is not M$ help desk, this is a forum. Clearly put...

Yes. I agree. I think this is one of the most commonly used practice in every environment (dev / qa/ prod)

And this should be done just after installation to...

Yes.

alter database tempdb

modify file (name='tempdev', filename='f:\temp\tempdev.mdf')

alter database tempdb

modify file (name='templog', filename='f:\temp\templog.ldf')

Double check the new location, it must be valid, if not - SQL WONT WARN YOU !! while altering,...

i agree, thanks.

on some dll download site its saying "SQL Web Assistant Extended Procedures DLL"

but i m not sure about this