So you've tried DENY DELETE instead of DENY DROP?

john

OK, then you need to provide more information. Was this a one-off failure, or does it happen regularly? Does it always happen at the same time of day?...

Looks like Database Mail isn't correctly configured. There's plenty of information out there on how to set it up - here[/url]'s an example.

John

Is this a one-off, or are you going to have to do it regularly? If you're only doing it once, I don't think I'd bother with SSIS. Here's...

Not DENY ALTER SCHEMA. Something like DENY ALTER ON SCHEMA::SchemaName. You'd have to check out the exact syntax yourself if that isn't quite correct.

John

Yes - try DENYing DELETE or ALTER on the schema that the tables are in.

Deny permission...

A couple of things to try:

(1) Use DELETE instead of DROP

(2) Add an ON clause (although I don't know why that would be needed for DENY DELETE/ALTER but not for...

It's not possible in a single operation. You could restore the database then create new files in the restored database. Can I ask why you need to do...

Mr.DiGi (10/10/2012)

---

I like "less magic" - you can update table alias:

UPDATE

P

SET

ProductName = N.ProductName,

Price = N.Price

FROM

dbo.Product P

INNER JOIN

dbo.New_Prices N ON...

Use a Foreach Loop Container in SSIS. Your requirements are quite vague, so please try that and post again if there's anything in particular that you don't understand.

John

John

Vijay

Please post your full INSERT statement and the DDL for your table.

Thanks

John

It might help you to understand what's going on if you run the following just before selecting from the view:

SELECT SUSER_NAME()

SELECT USER_NAME()

It doesn't matter whether you're a sysadmin, a database...

OK, understood. Does the definition contain "user_name", "user_id", "sys.database_principals", "current_user" or anything else that suggests it's returning data according to the user running the query?

John

I can't say whether it's correct or not because I can't see your data. But since one user gets one result set and another user gets a different one,...