Marcus Farrugia (3/4/2014)

---

Hi I am receiving the following error while trying to query a .csv file using OpenRowset. I've tried every query style I can think of. I'm...

$Raam (3/6/2014)

---

Hi

I Understand, when you delete a row in the parent table, the database server also deletes any rows associated with that row (foreign keys) in a child table.

So...

FIshNChipPapers (2/27/2014)

---

Thanks both for the update. We need to support a 2008 SP1 instance alongside our production 2008 instance and we are not in a position to upgrade the production...

Luis Cazares (2/27/2014)

---

Can you explaing how is this vulnerable to SQL...

AK1516 (2/25/2014)

---

Can some help me reffer to a good document or script to do the table partitioning for a 500gb in sliding window technique ?

In my 4 year experince...

Johnny Ed (2/18/2014)

---

We have several environments that have distinct AD login principles for each environment (e.g. COMPANY\user_basic_dev or COMPANY\user_basic_prod).

I order to simplify post release database comparisons between environments and refreshing...

FIshNChipPapers (2/27/2014)

---

I am struggling to find the answer to this seemingly simple question: is it possible to run SQL Server 2008 RTM and SQL Server 2008 SP1 instances side-by-side on...

Hi...

Why not wrap the UNPIVOT query in a subquery and select where after you unpivot?

Just my $0.02

John.

I agree with Mitchell. This approach opens up systems to SQL injection attacks if the database is utilized by any interactive programming. Performance may be subpar. this...

Jake Shelton (2/14/2014)

---

Hi all,

Just wonder if I can get some help with a script that would allow me to restore 20 + .bak files to a new server with the...

rightontarget (2/10/2014)

---

John,

The reason for openrowset is because the called procedure calls another procedure where insert ... exec is used.

So, I am getting an error "INSERT EXEC statement cannot be nested"

I...

jitendra.padhiyar (1/21/2014)

---

Hello Masters,

We have around 47 MSSQL Servers and have around 1400 databases in it. We are monitoring them manually and runnig backup check script manually. It consumes almost 3-4...

Hi... please do not blast-post. I have seen this issue pop up three times and have answered it myself elsewhere.

When you do this answers are spread all over the...

rightontarget (1/28/2014)

---

Hi all,

I created an app user and granted EXEC privs to run a procedure.

There are no linked server calls in the procedure, but there are 3 instances of the...

JeepHound (1/30/2014)

---

Our management has decided to allow DBLinks from MSSQL to our Oracle system. What things should I consider during this process? What is the best way to...