It was the firewall. I shut it down on the server and it works fine. Now I'll work on the firewall on Server 2008 to get it to...

that should give me something to mess with for a while. i'll let you know how it turns out.

thanks

The browser was running on the server. it's not on the client, but I'm assuming that is not necessary since i am not trying to connect to the...

sorry about that. i am trying to connect using Management Studio from my client. I can connect to the default instance, but not to the named instance. ...

I'm not running this one on a cluster.

thanks Bradley. It's not that I do not want to use your script. It's just that I've already wasted enough time on it and it since it is...

I didn't use .csv. Just plain old csv. I don't know why the Maintenance Plan does not work, but it doesn't. I'd like to get SQL to...

So I think I got it. What I am going to do is create the same table in a different DB and have the data dropped then inserted from...

When you do a differential backup, it does a backup of...

To be honest, I was looking to see if there was some kind of flag in the system that would identify that they row had been changed. Doesn't the system...

bitbucket-25253 (3/4/2010)

---

How does the CSR add/change an address i.e.,...

ray-SQL (3/4/2010)

---

Can you add a trigger or does that consitute "changing the table"?

What about the part where insert/update happens, can you change that and add an OUTPUT clause to them...

I was not aware of that. Thanks

For the last 13 months, I would use

where datediff(mm, OrderDate, getdate())<=13

edit: Mine will include the whole month, so for today it would have 13 months and 4 days to...

The MD, RD, ID, etc are coming from the Customer Table. They are the Class of Trade codes that we use. There isn't a table that says that...