Hey, Gail. With Gus it is now up to 5 individuals you now know that know "The Key, the Whole Key, and NOTHING but The Key!"

Jeff Moden (6/29/2009)

---

Paul White (6/29/2009)

---

Peso (6/29/2009)

---

I only have 92 column in my master.sys.columns.

This is because I have an edited very slim version of MASTER database.

This is not something common, but...

It should only access the partition where the data resides. Yo should be able to verify this by having SSMS show you the actual execution plan when running the...

I believe that you have to have Visual Studion 2005 Professional or better to debug stored procedures in SQL Server 2005. And yes, I have heard that they have...

Jeff Moden (6/28/2009)

---

Nah... not the word "correct"......

Michael Valentine Jones (6/28/2009)

---

I have a hard time understanding how agile development would work within the biggest trend in software development, outsourcing development to offshore teams that have little direct...

Grant Fritchey (6/28/2009)

---

RBarryYoung (6/28/2009)

---

Jack Corbett (6/28/2009)

---

GilaMonster (6/28/2009)

---

Lynn Pettis (6/27/2009)

---

Okay, you were between 6 and 10 when I learned that in University. Not exactly when or which school I was...

RBarryYoung (6/28/2009)

---

Jack Corbett (6/28/2009)

---

GilaMonster (6/28/2009)

---

Lynn Pettis (6/27/2009)

---

Okay, you were between 6 and 10 when I learned that in University. Not exactly when or which school I was in when...

GilaMonster (6/27/2009)

---

Didn't realise anyone else knew that mnemonic. I learnt it at university as an easy way...

GilaMonster (6/27/2009)

---

Lynn Pettis (6/27/2009)

---

Sounds like a plan to me. I couldn't, it's been so long I just barely remember...

Sounds like a plan to me. I couldn't, it's been so long I just barely remember anything beyond 3NF,...

The terms being used almost makes it sound like class work in a Modeling class.

panwar.jt (6/24/2009)

---

I am using following command

DECLARE @FileName varchar(50),

@bcpCommand varchar(2000)

SET @FileName = REPLACE('c:\authors_'+CONVERT(char(8),GETDATE(),1)+'.txt','/','-')

SET @bcpCommand = 'bcp "SELECT * FROM [demo2_rmps]..mms_menu " queryout...

Look up these roles in Books Online (BOL)

SQLAgentUserRole

SQLAgentReaderRole

SQLAgentOperatorRole

Supposedly, according to Books Online, the following should tell you:

select serverproperty('LicenseType')

Problem is when I run it on systems where I know the license mode of the servers I get DISABLED...