i stil dont believe this , if the mail...

It means "number of compiles where the index was found missing" see here http://www.freepatentsonline.com/y2007/0130107.html

patelmohamad (10/17/2012)

---

I have created a Stored Procedure, i want to use the sp as like UDF Means a UDF can be use as like "Table" we can create Joins...

kk.86manu (10/25/2012)

---

Iam just looking to restrict a login only to read from the tables but while executing the stored prcodure it must allow the user to do the above operations.Is...

can you post the complete changed database mail SP call you are using.

It wil grow as it is nature of LOG file. the operation will get performed more...

because we set the "commandtimeout setting in application" which tends to do the time out of any SP when SP...

another solution though they are not approprate , See the link http://www.mssqltips.com/sqlservertip/2711/different-ways-to-make-a-table-read-only-in-a-sql-server-database/

yeshupandit_2002 (10/25/2012)

---

Hi,

I havnt got your question fully but i assume that you want to find tables that "can have relation

base on the column name"

Like Parent table having USERID as...

Balance (10/22/2012)

---

What an idiot - I was getting the date's on files mixed up - looks like backup each night is writing to the wrong file name (so Saturday wrote...

your requirement is basically De-normalization approach. First remove duplicate coluimn some time you need to merge the coluimn (concatenation of data like name = first name + last name )

for...

also it might be because of short of resoures .

try this

open the SQL job that runs the package, went to the job step that runs the package, went to Advanced and set "Retry attempts" to 4 ( could...

raghuveer126 (10/22/2012)

---

I did inner join put a where clause and deleted one table there were x rows affected but when i try to put one more table from the inner...

i didnt see any comment from OP that he wants to delete data with every...