Thanks that is helpful information to me, I will probably need to change the code in stored procedure then in the database collation, for the latter takes time, and the...

Yes, I did see issues before that happened on servers with different collations. Like you said

"to run into some issues in cross database queries , and maybe some queries that...

Thanks, lowell

Yes, if we need to convert the collation, I need recreate the database, recreate the tables on the new server, then import data.

I have 3 databases with a lot...

Thanks Arron, I do need the detailed explanation that helps me to clarify.

I knew earlier there was an option for directing errors not to fail the package, but not clear...

I found a solution using

AND name =ISNULL(@dbname, name)

that seems working fine.

Thanks, we check in all the files in subversion. so we have old copies, I do make another copy of the entire project.

good and clear answer, that is exactly the answer I am looking for.

Thanks,

Sorry, check the requirement with the user again, she modified the requirment, it is actually the user entered middle name with a double quote around it, the case is...

I have immediate notification of my post.

Probably blocked, I will check with out network admin

Because it is daily truncate and import the data, I actually don't want to reindex /reorg if possible. It takes long time.

I do use maintenance solution of http://ola.hallengren.com/

for other...

I rewrite the script as this:

USE master

GRANT VIEW SERVER STATE TO [mydomain\sys$swind]

GRANT VIEW ANY DEFINITION TO [mydomain\sys$swind]

GRANT EXECUTE ON xp_readerrorlog TO [mydomain\sys$swind]

EXECUTE sp_MSforeachdb 'USE [?]; ...

Thanks, tried the way you test, it looks like if the user is added to the database without any other permissions, and it has server role view server definition, it...

george sibbald (1/21/2014)

---

it will have whatever rights are granted to public, we can only surmise that is all the app requires.

as Erland says you a likely going to have...

Erland Sommarskog (1/21/2014)

---

The user still has VIEW DEFINITION in the database, as it was granted VIEW ANY DEFINITION on server level.

That is, the user can see the definition of all...

Erland Sommarskog (1/21/2014)

---

As George says, the script adds the user to model and master as well. And it will probably will produce an error when it attempts to add the...