chitandaa 90 (7/25/2013)

---

Thanks Elliot this is the information that I was looking for. In terms of my current set up how would you suggest that i split up my 2...

Is the provider name the same for 64 and 32 bit?

You likely will need to run the package with the 32-bit runtime, this is harder in SQL 2005, they made...

This is a very easy to do, you need to first get the third machine all built up, added to the domain. Once that is done add it to...

You are most of the way there. I recommend though that the destination DB NOT be included in the command, set the destination database in your destination connection.

I have...

Please answer the question I posed.

SQL will show local drives on the node it is on I believe. I believe it will not show drives that are in another...

poratips (7/25/2013)

---

Thanks Elliott for quick response as i need to do it today.

1) When i install sql 2005 on same server, i can leave the default instalaltion, right?

2) We have...

poratips (7/25/2013)

---

Hi,

I need to create another instance but will be the same DB name on same server, is it possible?

1) i have server called Server1 and it has instance called...

jpettigrew (7/25/2013)

---

I cannot see the main backup drive in SQL cluster when attempting to do a restore. The backups for the cluster is stored on this drive. I only see...

Paul Hernández (7/25/2013)

---

The situation is the following:

- I have an OLE DB source.

- Then I perform some lookups and splits

- I update some records using an OLE DB commmand

- Then...

LightVader (7/25/2013)

---

Elliott Whitlow (7/24/2013)

---

...

2. I have an article in the works that discusses NEVER using 3 part names in code and using synonyms to point to objects external to the...

I think you would want to look at:

http://www.windowsazure.com/en-us/pricing/details/virtual-machines/#service-sql-server

You get a VM with SQL all licensed..

CEWII

QC Pass, Eastern Iowa, Quad Cities.

CEWII

I'm very excited myself. I got emails about the beta MONTHS ago and have been checking in periodically. I used the on-site version at a previous employer and...

Have not done that myself, however I do run both on a single machine and have had zero issues. Off the top of my head I can't think of...

If they have the same names they will usually automap, but if they don't then no, you have to handle the mapping.

CEWII