Well, you can't create an index that contains columns from different tables, so that's not an option.

Try something like this:

t1 (col1)

t2 (col1, col2)

t3 (col2, col3)

t4 (col3)

Include columns would vary depending...

That's not a complete statement.

Is that part of a SELECT? Part of a SET? Part of an UPDATE?

With assertion failures and stack dumps, you should probably be calling CSS (customer support) as they are likely the only ones who will be able to help you.

Can you run...

Depends what you're trying to achieve with encryption. Remember that SQL's encryption cannot protect the data against the DBA.

As for what to encrypt, you need to identify what's sensitive data....

😀

All you do by backing up to 4 files is stripe the backup over 4 devices. It speeds up backups, nothing more.

As Alzdba said

You cannot alter db file separation using...

Nandy (11/20/2008)

---

I have done some analysis on the issue and found that if there is a one row in the table,then it will insert double the rows in the table...

Please don't cross post. It just wastes people's time and fragments replies.

No more replies here please. Replies to:

http://www.sqlservercentral.com/Forums/Topic605967-146-1.aspx

The error's coming from the line after the exec, because there's a variable with no assignment that's sitting there. That said, there are some other more minor issues with the...

What error?

Nandy (11/20/2008)

---

Hi,

Let me explain the issue, I have written the stored procedure to delete the data from the table based on some certain conditions. To check each row with the...

The system resource database must be in the same place as master. Where did you place the new master database?

Not enough information. If you want help, please give us enough info to help you....

Garadin (11/20/2008)

---

Indeed. The problem at the moment is that I don't really understand how to read execution plans / see the specifics of which might be better for what...

Something like this.

SELECT col1, col2, col3 from

t1 inner join (select col1, col2, col3 from t2) t2 on t1.col1 = t2.col1

I'm not sure I understand what you're doing. Please can you...