The main change is that schemas are no longer bound to users, users are assigned a default schema though.

To my knowledge a schema does not inherit any persmissions when a...

The AND operator does what you want. By doing doc = doc AND rev = rev you are saying give me only records where BOTH doc and rev match....

The best way to find a job is based on who you know. Find a SQL Server users group near you, go, and be involved. A .NET users...

1. Please post in a n appropriate forum.

2. What are you trying to restore from? Is it from another SQL Server version?

3. The command is Restore...

I agree with Matt. I'd use SSIS to fix the data, that's part of what it is designed to do. I am doing that when loading data from...

Can you directly login to SQL_B using Domain\Acct_A and query DB_B? Are you sure you have granted rights to Domain\Acct_A to SQL_B.DB_B?

I typically move that header row to a second line on the group and, I believe, you could toggle it the same way you toggle the detail rows.

I think you could\should do it using a script component. After you query your data using an ole db source your next step can be a script component. ...

As Gail explained, in the current version(s)...

Awesome. That's why I write so it's...

upperbognor (10/14/2008)

---

Jeff I have a question about the need to check for existance when nothing is being done on the else statement.

Does this not create added overhead because...

Robert (10/14/2008)

---

Good article. I have a small correction. If the after trigger fails (or raises an exception), it does not fail the transaction. The client must handle it.

A well behaved...

Tobar (10/14/2008)

---

Jack,

Thanks for the article. I don't know if it is your cheeky picture or your writing style, but you have become one of my favorites on this forum.

I am...

The snapin is in Computer Management. You can run it from your PC. Connect to another computer then System Tools -> Shared Folders -> Open Files. It...

Garadin has the right idea. Simplifies the solution and, if you movie it again, you only change the view.