Well I apparently missed typed, I get the same columns.

I already closed my session so I'm not to sure what I typed to get something that looked different 😀

By the column names you provided I'm guessing you are working from SQL Server 2000 (not SQL 2005, which is the forum you posted in). I received different column names...

Jeffrey Williams-493691 (10/7/2010)

---

The recommended method is now:

1) Alter Database {db} Modify File (Name = logical_name, filename = 'new pathame');

2) Alter Database {db} Set Offline With rollback immediate;

3) Copy files to...

sp_dettach and sp_attach are the favorites of most people that don't like to use the GUI.

Sorry that would be sp_detach_db and sp_attach_db

Try the application event log.

The "timout expired" might be a problem with SSMS. If you are doing it from your machine (not on the physical server) you can adjust the timeout to a longer...

Is anyone else using the database (the "live" one)?

They were 4 months shy of 2 year gap between release dates:

SQL Server 2008 -- August...

Marios Philippopoulos (10/6/2010)

---

Hmm, it may not be too surprising that I cannot upgrade from SQL 2008 R2 to SQL 2008 SP2.

SQL 2008 R2 is probably on a different version stream,...

Ah..took me a minute to find where that was 😀

Just curious but how much memory do you have on the server? Is the server do something else other than SQL Server?

GilaMonster (10/6/2010)

---

Tom.Thomson (10/6/2010)

---

I...

If you give us the error you get would helpf us help you 😀

mnDBA (10/5/2010)So, I created a new SSAS databases, and ran a profiler trace of me deleting it by right clicking on the DB and choosing delete. I then filtered...

I used BING baby 😛