how do I set /3GB and where do I check AWE?

Thanks

Sql 2000, 32 bit.

How much should I leave the OS?

Thanks for the idea. Something in your code just got me thinking. And I was trying to make things more difficult then they are.

Here is all I needed to...

Its been a looonnnnggggg day, there was not record in the table.

I think its time to close up. Thanks

thank you

I found my error, it was dealing with one of my SSIS Scripts.

Thanks

Thanks.

I can't belive I could not get that SQL. Soooooooo Simple.

THanks Again

I apoligize I did not mean to.

I tried on 2005 first then I downloaded the Free version of 2008 to try the same.

That is why I posted on both.

SP3.

You think I should try upgrading to SP4, then try the migration?

Weeks in a month for me mean...

Number of weeks in a month.

Example: Week 1, Week 2, Week 3, Week 4

New Month:

Week 1 to Week 4

I apoligize if I did, but when posting the site gave me an error and I did not think it got posted...

but its fun to see you have nothing better...

Thanks everyone for the code and examples, but the code around the web is incorrect.

On some years (2004, 2005,2009, 2010) it gives you 53 weeks in a year.

Dont know...

thanks for the help.

But this does the same thing I do. I need to append the system date to the file after I copy or move it.