Actually it looks like your having two problems.

First of all you're trying to install the 64-bit version of SQL Server on a 32-bit Windows XP and second you can't install...

Yes, instead of triggers are implemented in SQL 2000.

I didn't realize that the link I posted was for SQL 2005 but as far as I know, everything in it...

If you want to use partioned views you need to have a partioning column which identifies to which undelying table a record belongs. You when have to define Instead of...

It would help if you would write which performance counter is causing the problem.

From my experience the error can be caused by two things.

1. The specified counter doesn't exists...

Edwin,

I'm a bit confused by youe measurements, but during some discussions with the people at MS...

Ian,

the best solution would be to always use the two-part name like dbo.tablename. Not only is it a best practice but there's also a (very) small performance gain by doing...

I can't say that I ever tried it but I'm pretty sure that it's possible. I've done a couple of upgrades from Standard to Enterprise and pretty straight forward. I...

NO it's not complicated at all.

If you have a look at the scheduling options for weekly jobs you will see the option to run a job every 2 or any...

Looking at the error message my first guess would be that you removed the Builtin\Administrators and now the local system acocunt can't login to the server.

If that's the case add...

Hmm, not sure I realyy understand your question but this is what I make of it. Your first list are all the fixeddatabase roles. In BookOnline you can find the...

The short answer would be yes it's possible from a trigger, but it's not something I would allow any of my developers to implement. The risk of failed transactions...

If your using SQL 2005 you can use DDL Triggers, Event Notification or even WMI alerts. It mainly depends if you just want to audit the event on the same...

As the error message said, the database is in use. Close all connections to this database first (any query windows, applications etc.) before restoring.

Then you need to restore the full...

Sorry but I don't see a link to the article your talking about so no comment on that part.

If I remember correctly logshipping in 7.0 was not a built in...

Not sure if it's god enough for your purpose but have a look at this article:

http://www.sqlservercentral.com/articles/Security/freeencryption/1980/

Markus