I think I was misunderstanding you. Now that you have this, what is the goal? Why would you want a job to fail...

Brain fart today... Erasing irrelevant comment...

Interesting... So this:

IF @@ROWCOUNT = 0

BEGIN

RAISERROR('You need...

DeanORenO (1/11/2012)

---

I'm not really testing to see if a table exists or not but if rows in a table exist:

and I figured it out here is my answer for my...

There's actually a recent thread with some discussion on this: http://www.sqlservercentral.com/Forums/Topic1233529-391-1.aspx

Jason Selburg (1/11/2012)

---

In order to dynamically name the columns, you would need to use dynamic sql. Search BOL or this site for more details on that.

Otherwise, this gets what you...

I just force it to fail. SELECT * FROM tableThatDoesNotExist

select

pub.srvname,

sub.srvname,

publisher_db,

subscriber_db,

a.publication,...

We have a script... Let me find it for you and I will post it shortly.

jpomfret7 (1/11/2012)

---

Hooray!! That worked!

Did some additional testing there must be something weird going on...

jpomfret7 (1/10/2012)

---

The file name and info matches in sys.database_files, sys.master_files, sys.sysaltfiles and dbo.sysfiles...

We are in...

JagWalia (1/10/2012)

---

GilaMonster, thanks for replying those questions. I got these questions prior to the interview. I can see login ID question is a syntax issue and I can find the...

Ignoring the fact that these questions and answers are not worded correctly, it is clear with...

mdonald 98074 (1/10/2012)

---

You guys are right. I will go the route of counting my delimiters and adding 1. Thank you. Sometimes you look at something for so...

Just follow the multiple choice...