Indianrock (8/28/2009)

---

Thanks. I found a place to download the 6 month trial. Now to find out if it will install without uninstalling the sql 2005 tools. If so I...

Thanks Gail - that was what I remember from another article, but couldn't remember the steps to be done.

If this was a copy of a database that was setup with replication - I would bet anything that it still thinks replication is set up.

I believe the process to...

Google parameter sniffing - sounds like that might be what you are running into.

As everyone else has said - you need to check with your vendor. Also, check with your management and find out if you have purchased software assurance - and...

What's the result from DBCC LOGINFO? Are the active virtual log files (status = 2) at the end of the files?

I think the first thing you need to do...

CirquedeSQLeil (8/25/2009)

---

This is a decision to be made by the db and server groups within your company.

I prefer to separate SSIS off onto it's own server - we call them...

I am in the process of implementing a four-node PolyServe cluster. What I have found is that the installation in PolyServe is not the same as MSCS clustering installation....

Jeff Moden (8/25/2009)

---

My recent stance is if someone wants to be stupid, I'll let them... there are too many good people who want or need our help. If we...

Not 'create a new database', but 'create a new blank database'. That is, a database with nothing in it at all.

When you perform the comparison between your existing database...

Get a comparison tool (Redgate SQL Compare, ApexSQL, etc...).

Create a new blank database and perform a schema comparison between your existing database and the new blank database. Save the...

Lynn Pettis (8/25/2009)

---

No problem, it's why we are here, to help clear...

The only way to remove those files is to move the objects in those filegroups to the other filegroup. Drop and recreating the indexes on those filegroups should take...

No - you cannot restore a database with multiple files and reduce the number of files. What you have to do is restore the database with all of the...

Not sure why this would be a maintenance nightmare, you have to add those users somewhere so they can be managed. Normally, that would be done through AD and...