ok, so you're attempting to Migration your production data from one server to another with 0 downtime? If you either a) use the Copy DB Wizard or b) a...

There are a number of products from the USPS to handle this type of thing. I think they even have an API that you can just pass them your...

Even if they don't have anything scripted, you can install Windows Server on a Vitual image in about 30 mins - 2 hours depending on speed and options selected. ...

1) Do you have the appropriate permissions for both the source and destination servers?

2) since you don't want down time and you want to schedule it, why not create a...

The OP specified this in the WHERE statement

sales_in_no >= 199901 AND sales_in_no <= 199701

Reordered that becomes

EDIT: modified due to GT LT tags getting stripped out.sales_in_no <= 199701 AND ...

Actually, SQL Server stores date times as 2 4byte ints. the first is the number of days before or after the base date (1900-01-01) and the second stores the...

to copy a db from one server to another, I typically will do one of two things depending on time, size restrictions etc. The easiest way, if you can...

GilaMonster (9/23/2008)

---

Jeff Moden (9/22/2008)

---

Considering that BETWEEN is reevaluated by the optimizer as an AND similar to the original query in this thread, I'm really surprised. I think it may...

Additionally, I'd get with the Network folks and figure out why your server is using a dynamic and not static IP address. If they say it must be handled...

That's correct, but you can still do full and differential backups to keep your SLA if it's...

also, I didn't address years prior to 2000 because I didn't figure you had any prior to that, but you could easily adjust the code to deal with that.

-Luke.

moving forward I'd no longer keep it in a varchar(4). I'd either use 2 char(2) columns one for month and 1 for year. Additionally I'd make sure the...

Or because they don't share the same vision as the company.

Or because no one mentored them enough.

Or there was a personality conflict.

Or stuff happened in their personal life...

by default SQL Express doesn't allow connections via TCP/IP or Named Pipes, Only be Shared Memory. Depending on your connection string you may need to allow one or both...

Yeah I've used the free calls as justification for my MSDN subscriptions in quite a few companies I've worked for. If they won't buck up for a full Blown...