i usually use "alter database set single_user with rollback immediate"

add this to the end of your create login statement:

, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

if there is a windows user that has SA role, just have them login and change the SA password to what it is supposed to be. By default, local admins...

I would suggest using BCP for this. The syntax is in BOL

yes, you can either create another backup device pointing to a different file for the differentials, or you can do backup to disk = 'full path' and it will write...

I guess it depends. Do you have any other apps planned to be installed on the OS partition? do you have multiple instances going to the box? are you going...

the binaries will go on the C drive of both nodes, then you put the data and logs on a shared drive. It will ask you for the shared drive...

since we have plenty of free space, we do not do any shrinks. dbcc shrinkfile is run in a query window. you will need to know the name of your...

use sp_who2

either you have a long running transaction, or you simply can shrink the log to reclaim the unused space. use dbcc shrinkfile to shrink the log

I have used red-gate sql compare and Visual Studio 2005 for database professionals (datadude)

they both do a good job. I know red-gate gives a free trial for 15 days or...

we looked at both lumigent and idera. We ended up getting Idera's compliance manager, but I guess it's a matter of opinion. Idera was cheaper and did everything we needed...

CREATE Function Foo (params...)

Returns bit as

begin

declare @count

select @count = count(*) from ............

if @count >= 1

begin

return 1

end

else

begin

return 0

end

end

your having clause just needs move after the group by statement and needs to be before the order by statement

users and roles are both in sysusers table

you can use sp_helprole to get just the roles, or look in BOL to see what the other columns mean and you can...