How do you go about this?

Thanks, this is what I was looking.

Fortunately we are not running out of space . Since having BOL posed a security risk on production box (SQL 2000), I wanted to...

I am trying to move logins/users from 2000 to 2005.

For SQL 2000, I found this topic on tek-tips

HTH

Gosh, I should have looked under Add/Remove Programs, thanks Mohammed.

Thank you dmberg.

Nice answer . Is there a way to run SQL Server using only Windows authentication in these kinds of situations?

Maybe I need to talk...

The problem was the user's profile got corrupted.

1. Ask the user to login on a different workstation (that has SQL QA & never logged in on that machine)

...

If I want to use this product, will the following topology work?

In our environment we have four DB servers running SQL Server 2005. Two out of four are production servers.

SQL...

Thank you guys.

What is your approach in setting up SQL environment for HA and disaster recovery scenarios?

Would DB mirroring provide HA solution, why do you have to go with WANSyncHA...

How do I find if it's kerbros or NTLM. Isn't kerbros related to analysis services?

I am positive that I got SP4 on our DB Server. We only have default instance.

Here are the results when I ran serverproperty command.

Standard EditionSP48.00.2039

Any ideas...

That's what I thought, thanks Aaron.

Declare @filename1 as an output parameter.

create PROCEDURE Test_sp @filename1 varchar(200) OUTPUT

as

set nocount on

select @filename1 = left(loginame, 30) + left(hostname,30) + left(db_name(dbid),30) + str(spid,4,0) + str(blocked,5,0) + str(physical_io,8,0) ...