I don't think this is a switch. Raymond says it pingable all the time without interruptions. But is is good to test. Why don't Raymond plugs in his computer to...

Nicholas is right. It is

dsget user command with memberof parameter. See

http://www.microsoft.com/windowsxp/home/using/productdoc/en/default.asp?url=/windowsxp/home/using/productdoc/en/dsget_user.asp

This is not SQL but OS command and the executables may exist on the servers, I am not...

Sure I did. Some people are resoursful.

To deal with it:

1. run sp_changedbowner 'sa'

This way you at least will have a valid database owner. Or change the owner to some other...

Brian,

Thanks!!!.

Now we have to work on the exit strategy. I do have one system procedure modified to comply with the business process. I will have to work with the application vendor...

To bkelley:

Brian, one of your advises is to modify sp_password. I already posted topics in 2005 section, I can NOT get to the text of system stored procedures in 2005....

Hi,

Was it a standard login or a Local Windows user and you are restoring to another server? In this case SID (security ID) of the user will be different.

Please, ask...

I did not have issues yet when creating and using the databases for development by restoring backups of production database on the same developmet server several times under different names....

PBirch,

Thanks. I did not read those 2 books marked by you as advanced, I read "Inside Microsoft SQL Server...", BOL and MSDN articls. I will take a look at those books...

dgrover,

This is a good function. I will save it for the conversion from string to date, very helpful.

I probably have just to create a user-defined function for stripping time out...

Dave,

This procedure was used as an example. I can not see text of ANY stored procedure

Dave,

I can not see text of ANY stored procedure. sp_adduser was just an example.

Yelena

Hi,

Talking about the ANSI /Unicode conversion

Is there an easy and automated way to convert an ANSI text file to Unicode text file? We are taking over some app where the...

Brian,

Don't forget to turn on your pager after that.

People who install SQL server with a blank password tend to use it in the applications for connection strings. Those applications will not...

Dgrover,

I do sometimes use your #3 Getdate() - 3

what about #2? the ConvDate function? it is not SQL function. I think it is Unix or something unless you have written...

Hi all,

I always do sp_changedbowner 'my_login_who_will be_mapped_to_dbo'

It always says that all existing references are re-mapped. Since I usually make dbo  mapped to the login SA, the first parameter is...