A few more opinions here would be welcome.

Has the question been changed? I just answered it and it specified SQL Server 2005/2008, in a just opened connection (no other commands run).

I was surprised that it would...

Do you have the /PAE switch in your boot.ini file on the server?

Alan. T. (1/29/2010)

---

I have been able to detach and reattach databases both ways. From 32 bit to 64 bit and back again. Quarterly I take the production databases from the...

So, you have 64 bit hardware running 32 bit OS and SQL Server? If this is the case, then yes. Backup all your databases, make several copies of...

Lowell (1/29/2010)

---

i think one problem is you are joining the same table 6 times, when it is not necessary:

SELECT a.ID, RTRIM(LTRIM(a.ID)) as fID,

a.demID,

b.mid AS gp,

c.mid AS op,

d.mid AS oom,

e.mid...

Can you give us a bit more information as to what you are looking for here? For the most part, moving from 32 bit to 64 bit is quite...

Without table defs (CREATE TABLE statements), sample data (as a series of INSERT INTO statements), all I could come up with is this:

select

c.CustomerID,

...

Where do the database files (mdf/ndf/ldf) exist on the source server and what are their logical names?

If the new server is a different configuration, you will need to use the MOVE clause in the restore to move the files to their new location on the new...

select ... where varcharcol like '%[0-9]%'

Does that help?

Take a close look at the frequency portion when you select Monthly.

You can run it a job on a given day of every < number > months. If you...

GilaMonster (1/28/2010)

---

Same as Seattle? That puts you 10 hours behind me. So if you meet at 7pm, it'll be...

Have you looked at exporting the SSIS package to the file system? I haven't done this, as our SSIS packages are also stored in VSS and if we need...

Not necessarily. Concepts are important. Concepts move easily between industries. If you know/understand the concepts, you can easily learn the details. There may be differences, but...