hi Alamir,

For financial reasons, I would like to use the Standard rather than the Enterprise.  Currently I have an instance of SQL enterprise edition, and all the databases I need reside...

hello robbac,

Thanks for the effort to help and for your tips; i'm getting there but am still annoyed that something that is seemingly simple is so hard to accomplish! ...

hello ianyates,

thank you for your prompt reply.  I understood the idea behind your helpful suggestion, but I'm pretty mixed up when it comes to implementing the modification of accounts.  I...

hi to all,

Once again, thank you all.  For the time being I managed to use the backup file to restore the database to a different server(which is what i wanted...

hi,

i'm a great believer of the saying that one person can make a difference, and i appreciate people like you who by their knowledge and willingness to help make a...

hi,

I can not paste the image, so I'll copy word for word the error message.   it says the following:

title bar: microsoft sql-DMO(ODBC SQL State 42000)

the message itself is:

device activation error.  The...

Hi,

Thank you all for your input. When I read your replies I am comforted and...

Once again, mkeast, many thanks for the important input that I will certainly take account of once going about migrating from the expensive Enterprise Edition to the less expensive Standfard...

hi again,

Something happened with respect to my last reply--- not all the contents of that reply went through. So to continue from where I was cut off....

Thank you for your input...

hello mkeast,

Thank you for your input -- it's always good to know as many details as possible before embarking on a new road of migrating from one system to another.

From...

thank you again for the prompt reply.  From your last reply I understand that it is possible to use the restore functionality of the sql server with respect to a...

thanks for the prompt reply and the BOL tables you have attached -- it really puts me in a better position.  From looking at those tables, I think that the...

Once again , big thank you for following up on my burning issues, for being a kind person and for the time you took to write back to me and...

Thus I can make a general observation saying that the shared lock on the select statement with respect to the above example is released as soon as SQL finishes to...

thanks for your propmt response.

what if I have something like this:

BEGIN TRAN

declare (@arbitraydate smalldatetime)

select * from TableOfNAmes where [ss#]='076-54-8734'

set @arbitraydate =getdate()

update TableOfNAmes

set lastname='myMarriageLastName'

END TRAN

I know that the select statement get...