if you right click the server, then go to processors and select the 20 cpu's you want it to use via the gui, then instead of hitting ok, use the...

easy mistake to make.

i just did a google for "sql 2008 r2 sp1 cu3" and the first result is for the RTM CU3 not SP1 CU3

damn you google

mohammed moinudheen (2/23/2012)

---

I had faced a similar issue and it was because of the VSS service which was set to manual and was failing continously after a server restart. But...

so you only want the trigger to insert into table 2 where a row has been inserted into table 1 where the Tenant_ID is 1

and State_ID = 1 or State_ID...

If you go to the KB article it details the build number

Note This build of this cumulative update package is also known as build 10.50.1734.0.

Your on a higher version...

Engr Shafiq (2/23/2012)

---

@anthony-2:

if you do not mind i want to elaborate a little bit more.....explain me

what are isolation levels and how they will be treated?

give me a complete example so...

it depends what isolation level you have set on the connection, by default its read committed.

if we take this as an example

i open two SSMS query windows, so this acts...

duplicate post, all replys here please http://www.sqlservercentral.com/Forums/Topic1256431-338-1.aspx

what do you mean waste?

corrupted? no longer needed? been dropped?

you cant avoid restoring an object, if the backup contains 50 objects it needs to restore 50 objects

how do you mean edit?

change the schema, update data etc?

if you do

select * from msdb.dbo.sysmail_account

do you see the email address in either the email_address or replyto_address columns?

Got a little but further with this today.

Ran a trace against one instance and noticed the the nodes where trying to login with SQLCMD, so I took a look at...

it would help if we had sample tables, data and what you have tried so far along with what you want the expected result set to be.

if you could provide...

with cte1 as

(

SELECT

ROW_NUMBER() over(partition by peter order by peter) as row_num,

Peter, max(mike) AS mike, steve

FROM ATable

group by peter, steve

)

select * from cte1 where row_num = 1

might be worth...

sejal p gudhka (2/22/2012)

---

Thanks Andrew.......

I got that a.size from sys.database_files stores file size in terms of 8-KB Pages and multiplying that by 8192 is to convert it into KB. So...