This:

Set @CntNow= ('Select COUNT(*) From ') +@Path

You're attempting to set the @CntNow value, which is defined as an integer in your variable declaration, to a string value. If you're attempting...

squvi.87 (9/24/2015)

---

Hi There,

Im have a situation to insert data from multiple sources to a single table.

ie., multiple and concurrent insert on same table

will it lead to dead lock at...

Not sure what you're looking for? The link I posted shows how to call stored procedures from the command...

Hibernate, nHibernate, Entity Framework and Lynq are just a few of the Object Relational Mapping tools you're going to see more of. They actually can work very well for most...

You can simply use the SQL Server command object from Powershell to make these calls. It's easy. Here are some examples.

Captain Scarlet has it nailed. Each differential backup is going to take longer and longer because they are cumulative since the last full backup. I'm not sure I'd bother taking...

The positive impact when you already have SSDs is probably going to be less, but it will still be there. Primarily because we're talking not about accessing your database files,...

Went back to the train wreck... uh, I mean Jet discussion.

I just keep hearing "MongoDB is web scale" over and over.

And if anyone searches that up, fair warning, the video...

Since we seem to be largely Godwin-free on The Thread, I thought I'd point out this really cool article about using data to test Godwin's Law (short version, the law...

Assuming there's a naming standard based on date & time, that's one way to check. Another is to use PowerShell, then you can look at the date on the file.

But, if it's already dropping this single log backup (and please, note my concerns above), what more are you looking for?

You just have to reference the location and get the...

WayneS (9/23/2015)

---

Grant Fritchey (9/23/2015)

Good gosh. I went back and read through what I've missed. This guy is a classic troll. He's been fed so much I'm surprised he doesn't pop....

Ed Wagner (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

Lynn Pettis (9/23/2015)

---

Steve Jones - SSC Editor (9/22/2015)

---

jasona.work (9/22/2015)

---

I think I need an intervention...

I keep going back to the "Jet" topic, it's like watching a train...

Also, remember that if the load process is doing UPDATE/DELETE in addition to INSERT, that the indexes, especially any primary keys, may be very necessary to assist in finding the...

I'm with Anthony, why not just use log shipping. It's built into the product and will do what you want.

However, a couple of suggestions. First, check the msdb database. There...