Jeff Moden (1/7/2010)

---

CirquedeSQLeil (1/7/2010)

---

Jeff Moden (1/6/2010)

---

The Tally table is not a panacea and isn't good for this. Dynamic SQL would be good for this. So would an (ugh!)...

This can be done (connecting to SQL 2k8 database from SSIS 2K5 package). As was suggested, test your connections first from within the package.

Robert Davis (1/7/2010)

---

The_SQL_DBA (1/6/2010)

---

Just to add my take on becoming a master, I guess one needs to follow on things told by Gail,Steve,TheSQLGuru and any other SQL Expert that I...

Are there any routers, firewalls between the servers that may block ICMP? Some places do not block ICMP traffic, some do though (to protect the database network for instance).

If...

kgbs12 (1/7/2010)

---

Please, correct me if I'm wrong. If I use the @Dept within the Where clause, I would then have to declare it? Which, I don't particularly want...

emily-1119612 (1/7/2010)

---

>>As far as replication goes, I have read all about it

It sounds like you know as much or more about it then me then. I wasn't sure if you...

Yes, you will need to use...

In the meantime, here is some reading material

http://technet.microsoft.com/en-us/library/ms187956.aspx

As Gail said, don't exaggerate yourself. You need to sell yourself, try to do it honestly. Knowing that you don't know everything will be helpful and knowing how...

AndrewSQLDBA (1/6/2010)

---

Hello Everyone

I need some help with a tally table.

I want to be able to query a list table, get the list of a few ID's and then fire off...

Are you feeling...

John Rowan (1/7/2010)

---

I would gladly trade my snow shovel for shorts and t-shirts. All of the snow and cold started here the day after I returned from the Bahamas....

I use a different app altogether for RDP. It seems to be more friendly about the double-hop thing and pinning/unpinning. Try VisionApp Remote Desktop.

I have a male friend named Kim and another male acquaintance named Shannon - so I will go with male on those.

Lynn, if it...

Ray K (1/7/2010)

---

Actually, I understand that Alomar has since apologized, and the umpire who was the intended target has not only forgiven him,...