sudonjn (7/25/2013)

---

I have recently started using replication in SQL 2012 SP1. When a stored procedure is altered on the source, the changes are replicated to the subscribers; however, the...

OK That helps. With those changes, then I stand by my previous advice to inner join on...

ms-techie (3/25/2014)

---

Get output of SQL Procedure and assign it to a variable used in WHERE Clause

Later I want to use this variable in my code in the WHERE Clause

Declare @ProjectNo...

Randy Doub (3/25/2014)

---

A vendor was backloading a ton of data. At one point they asked for more disk on the K drive. Filegroups are spread across both K and...

WebTechie38 (3/21/2014)

---

Hello,

As I am monitoring my sql servers, I noticed something in one server. In the error log, I see that one databases has more than 1000 virtual log...

Koopa (3/25/2014)

---

Okay, it's been a long day, I am going crazy.

I have a database that has some stored procedures that need to view sys.dm_exec_connections.

Stored procedures are execute AS OWNER. Owner...

Hi - we don't have enough to go on.

First, you have two tables named "Staging" with two different definitions.

Second, you have described your left outer join with aliases but we...

My first temptation is to issue a wiseacre answer like:

1. SSMS

2. Control...

Hi.

1. What problems are you running into prior to using the SP?

2. Exactly what solution are you trying to accomplish that the DTSX is not accomplishing for you?

The question is...

SQLSteve (3/24/2014)

---

I have set up database mail on a server which is working fine and I am getting alerting when SQL jobs finish.

I get alerted when the snapshot job...

Marcus Farrugia (3/17/2014)

---

Hi ck2,

If I were to use a Bulk Insert, using the link you provided as an example. The .csv is in an excel file, what would the...

bkrankel (3/7/2014)

---

I meant to setup a certificate and symmetric key for a specific database on one of my servers. I accidentally created the key while pointing to the master...

Hey Moden,

Just tried this for the first time. Bravo. Clean and very speedy!

Thanks

John.

Hi. I read Moden's splitter article. You are correct. It is stinking brilliant! I'm typing this at lunch on my iPhone. But I will be testing this sucker and...

skaggs.andrew (3/7/2014)

---

Hi,

I need help parsing out a field, but I am not sure how to extract just the specific part that I need.

Examples:

ELA-DUPLECHEIN, KELLIE-13-14-2(A-B)

READING -LANDRY, MICHELE B-13-14-2(A)

What I...