foscsamuels (2/16/2012)

---

first i cant get this query to insert the records. it shows 'Insert Error: Column name or number of supplied values does not match table definition.'

--===== If the...

raotor (2/16/2012)

---

BarneyL (2/16/2012)

---

In that case getting IIS running on your machine and then making use of something like the latest Adobe Dreamweaver trial to build some web pages could be...

This is a...

murthysundara (2/13/2012)

---

IF OBJECT_ID('Consultants') IS NOT NULL DROP TABLE Consultants

GO

CREATE TABLE Consultants (

ConsultantID INT IDENTITY,

ConsultantName VARCHAR(20),

Technology VARCHAR(15),

...

Zeal-DBA (2/3/2012)

---

hello experts,

i have been asked this question many times in many interviews what happenes internally when we take a backup of a database, i dont understand what to answer...

I'm thinking that it might not be timing out waiting on the sql server, rather it might be odbc timing out from trying to get the network connection to work,...

glad it worked!

patrickmcginnis59 (1/31/2012)

---

Mark-545947 (1/31/2012)

---

Can anyone help me the code below. It used to execute perfectly fine in my DTS package on SQL SERVER 2000, but recreating this task in SSIS 2008...

Mark-545947 (1/31/2012)

---

Can anyone help me the code below. It used to execute perfectly fine in my DTS package on SQL SERVER 2000, but recreating this task in SSIS 2008 gives...

GSquared (1/30/2012)

---

GSquared (1/30/2012)

---

As another potential drawback for NoLock, I've actually seen it crash a server, requiring database repair.

A shared connection (from a web server, of course) ran into two concurrent...

GSquared (1/30/2012)

---

As another potential drawback for NoLock, I've actually seen it crash a server, requiring database repair.

A shared connection (from a web server, of course) ran into two concurrent missing...

oh c'mon I like the previous version of this post better.

oskaroh (1/29/2012)

---

do you mean the sql management studio query editor?

using "new lines" (end of line) is...

Nice one thanks!

Brandie Tarvin (1/27/2012)

---

patrickmcginnis59 (1/27/2012)

---

Brandie Tarvin (1/27/2012)

---

If your updates are going to cause a lot of fragmentation, and frequent fragmentation at that, then it is advised you check your database maintenance...