The first screen you see after double clicking the setup file has a link on the left called "installation "

on this page the last link is meant to perform an...

How did you perform the FO using the wizard in SSMS or the cluster manager ?

Recovery pending is not the same as bringing the databases to sync.

How long did...

Imagine killing a SPI for an insert statement that was inserting a million rows the time to rollback would be huge. The only time it would be safe to kill...

OR you could have the EXECUTE AS SYNTAX within the procedure, the main thing is all procedures are not created alike, so each procedures and its execute permission needs to...

if your trying to stop the default trace you need to use sp_configure > default trace enabled (0)

also the first query doesnt show a trace id 2 so ar you...

Do u get the same error when using Report manager?

Do u get the error instantly or does the report try to render first?

Does the same issue happen with fewer...

assuming there is a correaltion between the weeknumber and the date and the days in question are weekdays you can also use datepart and then group by week.

select log_reuse_wait_desc, name

from sys.databases

If you have the option you can add an additional log file , before that please make sure you go thru the link Gail provided. it will...

For the most part it looks like the application is the root cause for the issue. try running the below query to identify expensive queries and the then decide if...

http://msdn.microsoft.com/en-IN/library/ms177413%28v=sql.105%29.aspx

details can be found here

The question is not very clear of what the end result should look like , it will be better if you provide some data and the expected final output.

Short of...

the fully qualified version of specifying obejcts is

servername . database name . schema name . object name

by doesnt work do you mean it returns an error or...

have you configured a listener for the group , thats the way you will connect to the Always on AG

Please look here for details on how Transactional replcaition works

http://msdn.microsoft.com/en-in/library/ms151706%28v=sql.105%29.aspx

I think you ahv confused it with snapshot replcaition which needs to occur they first time in order to have...

sqlfriends (1/20/2013)

---

The thing I found on a dev server, the database developer has all the rights on the box

and when he runs the build script sometimes, it accidently goes to...