Grant Fritchey (6/26/2012)

---

Assuming we're talking about a data file and not a log file, something had to have filled that space. Do you have load processes or queries that use...

Where are you getting this information from? There is no 10.2.XXX Only 10.00.XXXX (2008) and 10.50.XXXX (2008 R2).

If you only have these cases, then I would do this:

IF @var <> 'A'

BEGIN

SELECT whatever

FROM table

WHERE [field]=@var

END

ELSE

BEGIN

SELECT whatever

FROM table

WHERE [field]='A' OR [field]='B'

Of course, you could flip those if you wanted,...

There's something missing... You have to have some kind of constraint somewhere, i.e. FK, CONSTRAINT... Something is missing from the DDL you gave us. Can you check again?...

How are you resetting the settings?

Welsh Corgi (6/26/2012)

---

I'm getting an error on the Import & Export Settings.

The 'StartPageRefreshDownloadedContent' property appears to contain invalid data.

I need to Remove & Reinstall Business Intelligence Development Studio 2008...

patrickmcginnis59 (6/26/2012)

---

sambireddy chirra (6/26/2012)

---

Hi Vijayarani,

In my Requirement EmpId in Employee table have 101, same refearence table Employee_Details have 1011 (1012,1013 ) like . how it possible for the below query.

select...

Lynn Pettis (6/21/2012)

---

This is why I like SIDs, you can have a unique key that never changes that can be used for just such cases.

Does the table have any other...

JeffRush (6/21/2012)

---

You are tasked with pulling out the data across 50 tables. They all contain any number of columns. You want all of it but know for a fact you...

Dung Dinh (6/21/2012)

---

SQLKnowItAll (6/21/2012)

---

Can you elaborate on the...

JeffRush (6/21/2012)

---

Though it could be a case where you don't know the columns you do want but definitely want to exclude certain columns.

Like excluding all transaction audit columns from...

Can you elaborate on the security concerns? Also,...

Prasad.N (6/21/2012)

---

hi all ,

Regarding above issue I got a answer

declare @var1 varchar(5000)

declare @table table (ColNames varchar(5000))

insert into @table

----here i doesn't want COLUMN45,COLUMN46,COLUMN35(you need to write which columns doesn't want)

select...

after looking into this a little more, my guess is that this is in the Resource database and cannot be accessed. Best not to worry about it.

Sorry, I see you have it in the subject but not in the body of your post. Seems that it always shows up in a DBCC CHECKDB when I google...