I personally think that it is less efficient to use the numeric order by when you are maintaining code.  You are less likely to have to go look up which...

Steve,

Would there be a way to put a link to the choices on a multiple choice question?  That would cover when the explanation is brief. 

I would like to say...

The question was:

You want to configure heterogeneous replication between an Oracle Publisher and a SQL Server Subscriber. You want to configure a snapshot replication for this purpose. Unlike SQL Server,...

Actually, in SS2000 there are the audit level options of None, Failure, Success and All.  I use the Failure option myself but I would assume if you choose All that...

This is the classic reason for not letting apps use sa.

So who wrote the application that uses the sa password?  If it is in house, you need to change the...

It all depends upon how disasterous your disaster is.  If sql server is still running then it may not matter which database you restore first but I would probably start...

You might check out the post "The Steps Before Migration"

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=359&messageid=378376

Steve

We have a word association game we like to play in the car when traveling.  Somebody chooses a word and the next person says the first word that comes to...

There is a seperate sp_help_revlogin for moving 2000 to 2000 from moving 2000 to 2005.  Are you using the one for 2005?

http://support.microsoft.com/kb/246133/

Steve

How do you know when to run the import from the flat file?  Is there a certain time that it will be there so you can schedule the processing or...

Is the Sql Agent service running?

When are the backups scheduled to run?

If you look at the jobs created by the Maintenance Plan, what does it show for last run status?

Steve

neotokyo,

Did you get the ODBC set up and working?

Steve

The .cab file is the file generated by a snap shot for replication that uses http://ftp.  You will need to set up a subscription on your sql-server to put this...

I have always had to grant permissions in the base database that was needed by the view database.  May look into creating a role and grant permissions by column for...

Sugesh,

Did you realize you were calling Brian "Brain"? Not a bad moniker to have.

Steve