WOW, Steve, great post! There's a lot I could say, relevant to what you said, but I don't think it would necessarily be a good thing to say. I'll just...

Steve, I agree with your article, but with the caveat that I agree mainly in principle. I've been in my current job for many years. It wasn't what I wanted,...

Ah, that makes sense, Keith, thank you.

And sorry that I didn't post the table definitions as well as some data, to get a feel for what the query would likely...

Hi Luis,

I like your two solutions. Especially the first one, which I take to be an example of using a common table expression. I've heard of CTE's, but have never...

I've never heard of sp_WhoIsActive. I've done a quick search and found some information on it. I've downloaded it, too, but WOW, is the stored procedure big!

Markus (4/1/2014)

---

I guess it depends on when you say you have Mgt Studio open... are you just connected or did you have an open query or something?

I know if you...

When I run the batch file and redirect it's output, the first thing I see is this:

The contents of the output.txt file are...

sreekanth bandarla (3/11/2014)

---

I think, That's where you are having issues with. Type it manually and let me know how it goes...

syntax:

sqlcmd -S .\SQLEXPRESS -E -Q "EXEC master..sp_BackupDatabases @backupLocation='C:\SQLBackups\', @backupType='F'" -o...

Gary Varga (3/11/2014)

---

calhorg (3/11/2014)

---

Taking a slightly different tact, I don't see myself doing development on an iphone. Apparently neither does the big MS. I've heard it stated that MS suggests...

I copied the text from the KB article and pasted it into my batch file.

Thank you, Steve, for posting this. I didn't even know that Stack Overflow did this sort of thing. I use Stack Overflow frequently, but tend to go straight there, post...

sreekanth bandarla (3/10/2014)

---

Rod at work (3/10/2014)

---

sreekanth, I went to the link you provided. I've gotten the SQL...

Keith, in this situation I am OK with it. You see our application is written so that it saves the data in two places, at the same time. It saves...

sreekanth, I went to the link you provided. I've gotten the SQL script that's on the page,...

You all are giving me great feedback here. I've got to consider what would be best for my situation. I'm sure that the user's SQL Express instances are all set...