Hi Barry,

I couldn't get the upgrade to work. I took the .mdf/ldf files and attached to another server with the same version/build, then reset orphan logins then I uninstalled...

Luckily we had our own backup procedure outside of the server/file backup and was able to restore to the correct point in time...

You saw that huh? No answer on that board either...neither in the product white paper or specifications...it is like the biggest kept secret.

Oh that's the kicker...they assign someone to review each job every day...yeah...chew on that again...my mouth was still on the floor

And we are a company of about 4000

Great..one last question...

if the sql server stops by expiration does go through the process of detaching user databases?

I ask this because if I attach on the other server will I...

Not to hijack this thread...but to make a long story short we found a production server with an evaluation copy that expired...

I would simply like to extend the end date...

I found this on microsoft...the question is what if the evaluation had expired?

The 180-day trial version of SQL Server 2005 Enterprise Edition can be upgraded to the fully licensed version...

Jason greatly appreciated I was playing with this for over 2 hours yesterday...

Now it works...

Francis,

Your code was the best fit...thanks to all for the help...

Tried that and no dice

SELECT *, CONVERT(decimal(3,2),[Column 13]) AS CONVERT13

INTO #TEMP2 FROM #TEMP

Hi Rajib,

I did the following query:

SELECT ISNUMERIC(column_13) from #temp

The column brought back 0 and 1s

Again this column that has budget data. So values like 100, 105, 105.67, 9845.43, #MISS...

Thanks for the info...I remember about two years ago revisiting this. See the users do not drop and add often. In fact probably once every six months.

Dropping then...

Ok maybe because I am racing around trying to complete all loose ends before I leave this job..

How can I create a DDL trigger that tells the warm server a...

Hi Steve,

That would be good and all but I am on my way out at this position and altering the delivered database from the ERP company is not what I...

Found the problem...

the bcp command is using -T for trusted connection..this is a mixed SQL server environment and thus the -U and -P parameters must be used.

Once used I am...