Firstly, use the catalog...

Are you wanting to remove the server level login or the server login and the database user?

Always On in 2012 works the same, one full backup and restore followed by at least one t-log backup and restore. More importantly bear in mind this scenario

full backup at...

Greg.Jackson (4/12/2012)

---

Thank you, guys. I changed the frequency to every 15 minutes and now my log_reuse_wait_desc is finally set to NOTHING. So it looks like the Log will finally get...

a quick through the DMVs would have been helpful but to late now

Thinky Night (4/12/2012)

---

Thanks again, I am still reading Kalen's book, and tring to understand concepts.

New question:

Can i see all pages in a database with a command like DBCC IND?

OR

How...

tt-615680 (4/12/2012)

---

Thank you for your reply!

This is part of the stored procedure:

........................

...................

CREATE TABLE Data

(

Total_TY decimal(10,2), --this is where is gives the error

Total_LY decimal(10,2),

variance decimal(10,2)

)

INSERT INTO #Data

SELECT

CASE WHEN ISNULL(ISNULL(Total_TY,0)/ISNULL(Total_LY,1), 0)...

Greg.Jackson (4/12/2012)

---

I would appreciate some input on this one.

I have an Enterprise Class database (SQL Server 2008 R2) that I perform Index Maintenance on nightly (non peak hours using...

Glad you're sorted

can you post the table definition and the exact command you used to move the table?

jitendra.padhiyar (4/11/2012)

---

I did that... I restored backup with NORECOVERY option and than restore transaction log backup with NoRecovery option.

I setup mirroring and can see "Principal, Synchronized" status of Primary...

When you rename the Windows computer it should change this for you and update the account in AD.

An...

beejug1983 (4/11/2012)

---

When I logged on with ABC and executed below script I could not find any result.

SELECT * FROM fn_my_permissions('sp_start_job', 'domain\ABC')

Even if I log on with other user who has...

sure, you just need to enable the database option

You have to enable them at the database level to use them in the query.

For...