Thx Brian.  I frankly haven't tried encryption on SQL 2005 version even I have installed and previewed other new features in SQL 2005.  Will look at it later. 

Thx.  At one time we decided not to encrypt then it popped up last week when we had an security guy visited.

I just had this problem this morning.  Backup of a DB when restored on a standby server (manual logshipping) is invalid.  Article from MS KB isn't applicable since I can't find...

I was able to do this with a temp table, just wanted to see if there is other way.  Thx.

I still got stucked here.  If I replace the select ... with a stored procedure.  How do I make it works:

declare @total int

set @total = 100

create proc sps_test

as

select count...

don't know why it didn't work at first time for me.  Must be Friday.  Thanks guys.

if I am interviewee what do you think when I say 'Honestly I never done this but I am surely able to find out and have it done ASAP for you' ? ...

Sorry, I understood 'job jumping' different. I thought of a person who has, for example, done car washing, served as a waiter and now is doing DBA

In the past I've...

we just interviewed a potential DBA who had just passed his mcp for w2k server ( 2 weeks ) he didn't know how to configure w2k to allow sql...

thanks everyone. This is an app with sql as backend, both are supported by a vendor. However during the day it intermitenly happens to be slow during search....

do you know what objects you have access denied to? anything in the SQL log?

I think you can't backup/restore since you don't have access to the physical files on...

even this is a shared box, at least you must have SA rights to your "SQL". It's enough for you to DTS from the shared box to your new...

my friends used Measureup to prepare to 229. They said its cheaper and closer to the real exam than Transcender.

i used Shavlik .:-)

all are SQL2K with SP3 plus MS03-031.