Thanks for the input Jeff. Needless to say I learned a lot about international phone numbers recently. I am pretty confident I have the right codes. I...

The solution in my last post appears to be working just like I want it to. Might not be the prettiest code in the world but it is getting...

What you want to do is not easily done in T-SQL. Usually something like this would be done in SSIS or another package. What about Jon and John...

Yes you can run SQL 2000 and SQL 2005 on the same server. One will have to ba named instance.

You can also run different SP levels on one...

Got this in my SQLServerPerformance.com newsletter today:

Ad hoc updates to system catalogs are not allowed.

Error Message:

Msg 259, Level 16, State 1, Line 1

Ad hoc updates to system catalogs...

You mean to say you added columns to a table IN the ReportServer database? Why?

Select

Convert(varchar(10), user_id) + ' ' + user_name + ' ' + comment as row

From

source

For XML AUTO

Will give you one row...

Check out this link, http://www.systemwebmail.com/faq/4.2.2.aspx#4.2.2. Looks like you need to explicityly set the smtp server.

Where are you setting the value of @extract_start_date and how is it being set? Could be that the error is happening at this point.

Nobody had posted the brainbench test yet. I took it and my score was better than I anticipated as I took the test. When I entered the test...

Glad I could be of help. I wouldn't recommend using sa as the account though. You should have an account that just has the necessary permissions. You...

Could you post the the query, with any proprietary stuff removed of course? It might help me, and others, understand what is going on. I have not worked...

To keep your developers happy:P

Frank,

Thanks for the input. I actually think I have it figured out. I am doing something similar to what you are suggesting. In my destination system I...

It does add some size...