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...

I just took a look at the recovery model used for my instance of the SQL Express database, and I see it is set to Simple. Under those circumstances, what...

DEK46656 (3/6/2014)

---

I think the fundamental issue that drives people to using EF and similar tools is a lack of understanding for relational data concepts. SQL is not OO, or...

My environment is somewhat different. We have MS SQL and MS SQL Express, so in essence the DBMS. However we still use a ORM to help us write our code....