You need to accommodate use dbname command in dynamic query.

Here it is

DECLARE @DB_Name varchar(20)

DECLARE @Command...

Seems to be SPACE in the file name.

try with out space in the file path or enclose it in double quotes.

Ensure Login wste199e has desired access to perform the tasks in the package.

OR

Modify the package to use windows authentication in connection manager, and at the...

Chowdary's (9/22/2014)

---

The Login is able to view the Script of the Database by using the below

Right Click --->Script Database As --->Create To ---->New Query Editor Window, here he can...

Pablo Campanini-336244 (9/18/2014)

---

Hello:

I know now that AlwaysOn feature HAS to be installed/configured on a Windows Clustering environment, BUT the secondary replicas, like the Disaster recovery replica residing in a different...

Chowdary's (9/9/2014)

---

DENY SELECT ON SYS.all_OBJECTS TO XXXXX ,But after executing this he can't able to use SELECT cmd but he can able to generate the script by selecting Tblname-->Script Table...

Did you get to look at permission granted to public role?

You could apply DENY on few sys schema objects.

Try few of the below, ensure it does not deny the users...

Create a function to execute sql query and then cross apply with TABLE1 which is the output of the result from the query modified by Bob.

create function dbo.fn_execsqlquery

...

What is the state the error message 18456 give for this issue?

Should it be state 12?.

You may refer here.

Server level permission could be found with this sql.

Look for...

SQLalchemy (6/23/2014)

---

Given the phrase "A,b,B,a,c,b" is there a way to use my REPLACE keyword a return the string:

103!3@107@2!5#3@

instead of: 2!3@3@2!5#3@ ?

SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

Place, 'a','2!'), 'b','3@'), 'c','5#'),...

You could check...

Check these:http://blogs.msdn.com/b/richin/archive/2008/08/27/ssrs-subscription-tggau-rights-authzinitializecontextfromsid-exceptions.aspx

http://support.microsoft.com/kb/842423

Check This : http://support.microsoft.com/kb/913668

and

is the permission set to create assembly same in UAT and Production?

You may refer this also for permission set http://msdn.microsoft.com/en-us/library/ms189524.aspx%5B/url%5D

<project name>.SSISDeploymentManifest will be used to deploy SSIS packages to server, would not be helpful in scheduling packages.

Read this, would help in understanding deployment.

Error 6 OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000. 0 0

Error 7 Errors in the high-level relational engine. A connection could...