Here you find a whole book.

http://books.google.nl/books?id=AbvKiJHQI08C&pg=PA61&lpg=PA61&dq=ssrs+reportservertempdb&source=bl&ots=S4fd1c8KQE&sig=tE_ZNPKk1LAPZbHYt23bifkWjNI&hl=nl&sa=X&oi=book_result&resnum=3&ct=result#PPA45,M1

Personally, I would use the generate script task to script the views into a file and then execute the script on the new server.

As an alternative you can use the...

Jasper Smith has written a tool to sort solution files in SSMS. I haven't tested it with SQL 2008, but I would assume it will work as well since the...

If this is a SQL Express installation done by a software package, you might be lucky that you can find the sa password in the connection string. Way too often...

The normal status for the secondary database with logshipping would be STANDBY.

Why do you use NORECOVERY at all? Do you use the maintenance plan to setup logshipping or some...

Grant Fritchey (1/15/2009)

---

I'm not sure if the resource governor can help at a granular level like this, but it would be worth looking into.

Other than that, no I don't think...

INNER Join you use if there's a one-to-one relationship between two tables. A CROSS JOIN is the toal opposite of an INNER JOIN .

The example should make help to make...

No you don't have to install 4 files. The 4 executables on the download page are meant for different versions. Just pick the file(s) you need for your version of...

When you simly copy the tables to another database, without creating the tables first, the new tables will be created with the default collation of the new database.

The error...

You're on the right way. Using Export/Import will transfer the data but not the collation.

If I understand you correctly, you have installed SQL Server on a 2 node cluster and when you failover to node 2 some jobs don't give an SSIS error.

SSIS...

Yes, both these changes will be applied to the mirror DB.

Basically every action which is logged in the transaction log will be applied to the mirror.

First I'd like to ask why your developers use the sa account ? That's very bad practice and I would never allow that.

The reason the account is locked is that...

Did you try to unregister the server in EM and make a new server registration ?

For the database it's best to change the owner using sp_change_dbowner.

Removing the login will not have any immediated impact but g.e. running sp_help will fail if the the owner...