Okay, got it. Make sure you're specifying the correct name of the server with the appropriate port number,...

I've never heard...

If you're already running it as a local administrator, then it should run and at least tell you something. Check your running processes and make sure there's nothing in...

You're talking about the application's interface. You'll want to react to the dropdown's event that fires when you change the selection, which will vary depending on what environment you're...

Raxter, what they're saying is that we need to be able to reproduce enough of your environment to be able to work on the problem. Keep in mind that...

Venki508 (2/7/2016)

---

Hi,

Thanks for the reply,

Here i go with the exact requirement

We have implmented ERP recently with sql server 2008 database. we are facing some of the issues with client data..so...

rajemessage 14195 (2/7/2016)

---

q1) where ever i need order by to assign unique and sequencial number i use following while insert , so if insert , inserts in any...

You mention server restarts not impacting the series of numbers. Please understand that the temp table is limited in scope to your current session.

You could just fire...

SQL Server certainly has some quirks, but what mature database platform doesn't have them? Having worked in Oracle for years and then SQL Server for years, I have to...

Perry Whittle (2/6/2016)

---

Tis the same thing, db_owner provides the power to backup and restore the...

Hugo Kornelis (2/6/2016)

---

Ed Wagner (2/5/2016)

---

The ms_foreachdb uses a cursor to iterate through the databases on the instance. If you have to cursor through only a few databases, why not...

The ms_foreachdb uses a cursor to iterate through the databases on the instance. If you have to cursor through only a few databases, why not write your own cursor...

Luis Cazares (2/5/2016)

---

curious_sqldba (2/5/2016)

---

I have a stored procedure which takes varchar type variable as an input, the variable should be able to loop through multiple values and execute for each...

jasona.work (2/5/2016)

---

SQLRNNR (2/5/2016)

---

WayneS (2/5/2016)

---

Lynn Pettis (2/5/2016)

---

jasona.work (2/5/2016)

---

So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had been...

I guess my first question is about the TAB1 and TAB2 tables you're inserting into. Do they both have an ID column?

The next one would be about all your...