perplexitous

Is your etl performed through stored procs or is it done through SSIS or something else?

As Gail said, please give us more info. Anything provided without that info us just a guess.

Good luck.

potable

winner winner chicken dinner.

:w00t:

Here is another alternative. Kraig posted his while I was typing up my solution.

DECLARE @TestClient table

(ID int,

InternalCode nvarchar(100))

DECLARE @PartTwo TABLE (ID Int, subID Int, Somevalue nvarchar(100))

Insert into @TestClient...

You would need to move each NC index individually using the same method that Gail showed.

Taking this set based query...

When doing this, make sure you know if any columns have off row data (LOB). If so, you will need to recreate the table in the new filegroup using...

Elliott Whitlow (2/7/2012)

---

Thanks Jeff. The paragraphs before it mentions not using sa specifically talks about IT department mode vs ISV mode. I don't think you can take sa...

Oh but you do. You should avoid using shorthand like that. Explicitly define your columns is the better route. If you don't then you can't add columns...

sqlfriends (2/7/2012)

---

I know how I can set up this in SSMS. But my question is when I use SQL grant execute to that user, how can I check in SSMS...

This will let you know what the perms are. And as an added bonus, I am leaving in the script portion that can help recreate the perms. I...

explicitly name your columns and avoid the use of Select *. Also, columns can be aliased to a new column name.