what permissions does the public role have in msdb?

Are the queries you are trying to capture rows affected from selects or insert/update/delete?

If they are modification you are trying to get affected rows for something like this may work...

You can try this to get results without trailing comma.

CREATE TABLE #MyClients (Client VARCHAR(20), Account VARCHAR(20));

INSERT INTO #MyClients (Client, Account) VALUES

('Client1', 'Ac1'),('Client1', 'Ac2'),('Client1', 'Ac3'),('Client1', 'Ac4'),

('Client2', 'Ac1'),('Client2', 'Ac2'),('Client2', 'Ac3'),

('Client3', 'Ac1'),('Client3',...

If the BA only needs SSMS why not install SSMS 2012 express. I don't believe there is any missing functionality.

You can download the file ENU\x64\SQLManagementStudio_x64_ENU.exe from http://www.microsoft.com/en-ca/download/details.aspx?id=29062

There is also SSDT...

I have checked a few instances that are SQL Server 2012 SP2 and the all have the same result from @@VERSION. 11.0.5058.0 is the correct version number for sp2....

This query will let you know which memory objects are taking all the space. It may help in trouble shooting the issue

SELECT a.type,(a.pages_allocated_count)*8 as mem_used_KB

FROM sys.dm_os_memory_objects a

inner join sys.dm_os_memory_clerks b

on...

It does appear to be a change in behaviour since 2012. In books online for 2008(http://msdn.microsoft.com/en-us/library/dd206993(v=sql.100).aspx) the need to restart isn't specified, but in the 2012 entry(http://msdn.microsoft.com/en-us/library/dd206993(v=sql.110).aspx) the followup states...

there are a few things I would question in this answer.

SQL Log Files and tempdb: raid 10 would be far better than raid1. while raid1 gives you redundancy for heavy...

Jonathan Kehayias wrote an add-in for ssms 2008 that will allow you to create extended event session in the GUI.

for SSMS 2008/2008R2 - http://extendedeventmanager.codeplex.com/

for SSMS 2012 - http://www.sqlskills.com/free-tools/sql-server-2012-extended-events-add-in/

here a...

without table structure, sample data, and expected results its hard to tell (see link in my signature)

I did notice that there appears to be so extra brackets in your case...

if you are only concerned with the stored proc and its statements you should only need:

Stored Procedures

RPC:Completed

SP:completed

SP:StmtCompleted

include the object name...

What I would do in a situation like this is to compare the cumulative times and IO of selects vs insert/update/delete with and without the index over a large enough...

lkennedy76 (5/28/2014)

---

SQLSACT (1/6/2014)

---

Hi all

I am installing a clustered instance of SQL Server on Windows 2008R2

On the feature selection page, I select Database Engine Services, it then automatically selects SQL Server...

for log shipping, upgrade the secondary first, then the primary. You shouldn't have to stop log shipping. if your secondary is in stand-by then you may have to change secondary...

If you plan on using distributed transactions then Yes.

In my environment, I had to configure it to enable insert-exec over linked server.