Might be a good palce to start

http://technet.microsoft.com/en-us/library/cc917680.aspx#XSLTsection129121120120

the only thing that happens is outside of the local scope is the file copy so you should only need file share ports opening, typically 445 would also open up...

first stop the SSRS service

then detach/move files/attach or backup/drop/restore or alter database/stop sql/move files/restart sql

then restart SSRS

with cte1 as

(

SELECT ROW_NUMBER() OVER (ORDER BY [Name]) AS RowId,[Name]

FROM #Temp

)

update #temp

set ID = rowid

from

#temp t1

inner join

cte1 c

on t1.Name = c.name

timestamp is a row versioning method so you cant explicitly give it a value it has to generate it itself, you could set a default but they each row will...

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?