newbieuser (11/6/2013)

---

Hi friends,

I'm connecting to sql server 2012 database from management studio 2008R2 from my laptop. I always leave the session open on the management studio, but I've...

Oops. Sorry about that. Okay, It turns out I do not have complete notes on this, so I...

dwain.c (11/5/2013)

---

First of all, thanks to Steve for fixing the SQL formatting issues in my recently published article:

How to Design, Build and Test a Dynamic Search Stored Procedure [/url]

So I'm...

dwain.c (11/6/2013)

---

ChrisM@home (11/6/2013)

---

I'll second that - and give...

Thankfully, I don't see it getting cloudy any time soon in my future. 🙂

Perry is right - use a netstat -n to find ports that are in use then simply pick a different one. I'd avoid the known standards like 1433 and...

I have some notes at work from a really good presentation I...

paradoxical

Mile Higher Than Sea Level (11/5/2013)

---

Thank you so very much. This is all very valuable to me.

At least in the past, only new field have been added to the Oracle...

If you're looking for a SQL procedure to read the contents of a directory, here's one approach. This does require xp_cmdshell, so you're going to need permissions to run...

Mile Higher Than Sea Level (11/4/2013)

---

Please look over and comment. This is new territory for me on SQL Server Linked Servers

The Problem: SQL Server's Linked Server (to Oracle) is...

Fire

Cooking

muthyala_51 (11/4/2013)

---

How many user connections can sql server handle? In the sp_configure the default values for min 0 and max 32767. Can we increase these number of connections and configure...

Good eats