Warren Peace (8/7/2009)

---

In SQL 2005 SP3, if you installed it, it unchecks the "Enable OPENROWSET and OPENDATASOURCE support".

You will need to put a check in the box. Open the "SQL...

starunit (8/6/2009)

---

bitbucket (8/5/2009)

---

Starunit

When you do get it figured out, and make it work, think about posting your code here so as to help others with similiar problems.

I'll try the...

bitbucket (8/5/2009)

---

Starunit

When you do get it figured out, and make it work, think about posting your code here so as to help others with similiar problems.

If you are still...

Thanks for the link, bitbucket, I'll check it out, soon.

Up until recently I had no problems using OPENROWSET to work with EXCEL (as recently as 2 months ago was using...

The dialog shows sheets...

Thanks A.J. that did it...

Jack's solution would have worked, but I didn't...

Lamprey13 said:

Using a bit mask is a nice and easy solution and since you are talking about so few rows performace should be fine. But, you do realize that:

1. You...

RBarryYoung (5/15/2009)

---

Messing around with extended properties is not going to be as fast as any of the other methods here, and certainly not as fast as the constant scan method...

RBarryYoung (5/14/2009)

---

If you have a *very* small number of constants and their speed is *really* important, then you could make a constant scan in a View or an inline Table-Valued...

Glenn Dorling (5/14/2009)

---

One way to do this would be to use the db_name() function. You don't need elevated privileges to run it either.

I've only done very limited testing with...

Bruce W Cassidy (5/14/2009)

---

[font="Verdana"]If a value can change... it's not a constant.

Stick it in a table. Cache the table. You can use tricks like local caches stored...

Matija Lah (5/13/2009)

---

If you're worried about performance then you can still reduce resource usage by maintaining a central database containing all configuration options, and propagate a specific subset of these...

Matija Lah (5/13/2009)

---

In a SQL Server database you basically store data in tables, so using a table for this kind of storage seems like the most logical solution.

A couple of...

You are welcome Hope it worked out for you,

Mark

arup_kc (4/9/2009)

---

Why are we using GO statement? Generally SQL statements are executed sequentially, then why r we using GO?

Here is a situatrion where without GO, its throwing an error.

ALTER TABLE...