Quick thought, with the negative top directive the estimated execution plan is the same as the input plan (only translation) without any optimization. Change the top directive to n>0 and...

Joshua D Gang (9/10/2015)

---

I have a single 2008R2 windows server with 9 SQL 2008R2 standard instances install. This server is also setup as a three node failover cluster. Two SQL...

drew.allen (9/10/2015)

---

Eirikur Eiriksson (9/10/2015)

---

Quick suggestion (you are almost there)

😎

IF NOT EXISTS (

SELECT SP.Name, SPM.permission_name from sys.server_principals SP

INNER JOIN sys.server_permissions SPM ON SP.principal_id = SPM.grantee_principal_id

WHERE

(SP.name = 'SomeRole' AND SPM.permission_name = 'VIEW...

Quick suggestion (you are almost there)

😎

IF NOT EXISTS (

SELECT SP.Name, SPM.permission_name from sys.server_principals SP

INNER JOIN sys.server_permissions SPM ON SP.principal_id = SPM.grantee_principal_id

WHERE

(SP.name = 'SomeRole' AND SPM.permission_name = 'VIEW ANY DEFINITION')

AND --OR

(SP.name...

Warranty

Quick suggestion, use the Parameters (OleDbParameterCollection) collection which is a member of the OleDbCommand Class.

😎

Barkstuff (9/9/2015)

---

Hi, please only answer if you actually know the answer.

Is it possible to export the environment variables for an SSIS 2012 project? And if so how is it achieved?

Thanks...

SQL-DBA-01 (9/9/2015)

---

Hello Experts,

Many a times see the below error in SQL Error log.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check...

I think my take on it would be similar to many of the questions on the forums, outline one or more problems, construct a table structure relevant to the problem(s),...

Janrith (9/9/2015)

---

Greetings,

I've recently inherited a slew of databases and many of the table population stored procedures seem to have a common methodology:

Truncate Table TableA

Set @count = (select count(*) from TableA)

While...

Sweetbee870 (9/9/2015)

---

Okay this is what I'm running:

Select FirstName, LastName, Title

from Employees

See attached the Results. I need know how to only retrieve records for "Sales Representatives"

Hope this is...

Quick thought, the first hard limit is the maximum number of user connection is (2^15)-1 or 32,767, configurable, use SELECT @@MAX_CONNECTIONS to view the current. Memory consumption of the connection:...

Glossy

GilaMonster (9/9/2015)

---

Because doing so would prevent him from logging in entirely, whereas the trigger prevents him from...

Phil, not going into the begininator/terminator debate 😀 as this is a habit for the convenience of...