I find that I don't use Ask SSC. I've answered a few questions there, but the discussions are like the ones you get on SSC at all.

There is definitely...

Only issue I have run into with SSMS 2008 is that it won't connect to Integration Services. If I need to do anything with deployed packages I need to...

Steve Jones - Editor (6/25/2010)

---

PASS. No interest in flying 64 hours to ski for a couple days.

Send me pix, I'm happy to wait for Oct here. I went Oct 25...

Paul does bring up an interesting point, how many records are you keeping in the table?

Tara-1044200 (6/25/2010)

---

I am running hte following query to delete since 7 days its not yet finished, any thoughts ? and the number of records involved are 56734591

set nocount on

SET...

Make sure you take a full backup of the database prior to dropping it, just in case someone comes back and needs it.

I had to create a login for the service account running SQL Server and grant it CONNECT priveledges to the mirroring endpoint.

There was another step I needed to do, had to grant connect privs, but not exactly sure what that step was off the top of my head. I will...

Using the GUI, work from the Principal Server. I didn't use the GUI when establishing my mirror databases, did it all using T-SQL, and yes, I initiated the mirror...

SanjayAttray (6/24/2010)

---

Even though I got it right and know its possible but when executed in SSMS 2005 it returned error.

Msg 139, Level 15, State 1, Line 0

Cannot assign a default...

Not sure I'd do this the way you are, but have you tried this:

CREATE TABLE tbParticionada

( id int identity(1,1) ,

[date] DATETIME NOT NULL

)

ON PS_MonthRange (MONTH(date)) -- does...

Don't think that is the problem at all. You need to restore the database and transaction log using NORECOVERY, then establish the mirror connection, starting with establishing the partner...

Can you show us what you are talking about? Difficult to know what you are asking as we can't see what you see from where we are.

Edit -- duplicate post, issue with my BlackBerry.

The quick answer is "It depends."

Is this database a DW or OLTP?

Is the recovery model Full, Bulk_logged, or Simple?

If not Simple, are you running periodic transaction log backups.

Are you running...