Absolutely no point in a transaction there. Transactions are so that changes happen as atomic...

gmartin (6/11/2009)

---

I have one server, but it has multiple databases. The main db is where this code originally lived. Yesterday, in addition to editing it, I had to...

Have you considered full text search?

gmartin (6/11/2009)

---

So, if I understand you correctly, you are saying that I am mistaken. That the version of the sp that I'm getting when I use sp_helptext is the...

mjarsaniya (6/11/2009)

---

I cant I have also tried same with temporary table but i can not

create table #tbl(id int identity,index_value_table_name nvarchar(max),index_value_column_name nvarchar(max));

declare @var nvarchar(max);

set @var='mynk'

alter table #tbl

add column + @var +...

There is nothing to refresh. Procedures are only stored in one place in SQL, in a hidden system...

You can't 'refresh' the system tables....

Is the index really covering for SELECT *?...

Christopher Stobbs (6/11/2009)

---

Gail am I correcting in saying and I think I might have learn't or if I am wrong missunderstood, but ify ou have two columns in your where...

Not a bug, a documented restriction.

From Books online, the...

It will, because one of the columns is an inequality.

http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

p.s. Please in...

Get more disks or delete some...

Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.

Shrinking causes massive fragmentation and will just result in the...

Drop the index, create a new one. Or create the index with the DROP_EXISTING clause

Tim Walker (6/10/2009)

---

Question: (and I wouldn't have even asked it if I hadn't read this first) is what is the point in defining an index on a table variable if...