Give this a shot, I couldn't test it as I don't have the same the environment as you:

select

db.name as DatabaseName,

sj.name as JobName

from

...

SQLSteve (8/1/2014)

---

As part of my backup routine, I have a SQL job for each DB which which is called "DB-NAME - Backup Job"

I need to put a script together to...

Ed Wagner (7/31/2014)

---

Jason is braver than I am by upgrading in place. I've had SP installations fail, so I'm a bit wary of upgrading in-place.

When I upgrade, I do...

SQLSeTTeR (7/31/2014)

---

Does anyone have a script handy to fill in a century into a date string. Right now, I'm getting dates in the following format:

7/26/29 = converts to...

lescobar (7/31/2014)

---

so how do I stop or correct this error message?

Failure Reason:

ERROR CODE [30:325]: Error encountered during backup. Error: [Database "VIEWCOMPOSERDB' cannot be opened because it is offline. BACKUP DATABASE...

First, I would do the fixing before I do a final backup and restore.

Second, you can backup a database from a 32 bit system and restore it with no problems...

Matthew Darwin (7/31/2014)

---

Is that true even though they're using different IPs?

Basically what I'm trying to achieve is that both instances will appear as the default instance on seperate DNS entries...

Matthew Darwin (7/31/2014)

---

Hi All,

I'm trying to configure a named instances of SQL Server 2012 SP2 to have specific IP addresses and listen to that IP on port 1433. Alongside...

Unfortunately, what you posted...

GilaMonster (7/31/2014)

---

No...

Lynn Pettis (7/31/2014)

---

SQLRNNR (7/30/2014)

---

It could work - depending on what the data is in that table and...

First question, is there a maximum number of courses a student may take at one time?

Two, if you could post the DDL (CREATE TABLE statement) for the tables involved, some...

SQLRNNR (7/30/2014)

---

It could work - depending on what the data is in that table and the data...

Really?? Let's put a 500 million row table into an in-memory table.

SQLRNNR (7/30/2014)

---

Lynn Pettis (7/30/2014)

---

Careful, we don't want to provoke The Thread. ...