script out the role in QA and change the existing rolename with the new name,

run the script,

verify if everything is in order

HTH

as part of the security measures that a DBA needs to take is to remove the builtin/administrator account

in installing the service pack, you need to provide the logon account with SA...

1. CREATE command wrong

2. check for available disk space on the drives mentioned

3. are you creating the database remotely? like over a SAN?

4. the path is a default one, ask...

There is a workaround but it requires you to create an exe for them. Make use of approle (with appropriate privileges) and query through sysprocesses to filter out the processes...

You should plan for this type of disaster, I've implemented something simple but serves its purpose

1. change recovery model of the database to full

2. create jobs that will do a...

In a nutshell,

treat an instance like a separate sql server system, in one box, you can have more than 1 instance depending on the version you have

you can actually have...

Hi Ken,

I'm interested on the formula you used (wanted to learn how)

why did you use the factor 8 to get total GB and 1.2 to get raw bandwidth rate?

thanks in...

yep, check for sysjobs union with sysjobhistory for run_status

concurrently check sysprocesses so that you'll have a baseline when to stop trying

but as i mentioned, an error for failed distribution agent...

maximum is 9999

replication contributes to a part of your server performance, so if you keep asking the server to retry the connection for n-minutes and infinitely, you might have some...

if you have no log files to work with, you could probably charge this to experience, otherwise verify if you have full recovery set for the database and then you...

here's a checklist:

sqlserveragent running on a domain account with local admin privilege

outlook client installed on server

mapi profile created for the service account

opened outlook client while service account logged on, atleast...

you might not  be able to connect

you can explore named instances, failover clustering, logshipping instead

the change will happen on the apps level via an ini file most probably

HTH

anything is possible

but it is always better to test on a test server prior to implementation, different environments may result differently (especially when it involves network restrictions)

HTH

IMHO, this will not be an efficient setup for you, if the distribution agent fails then something must be really wrong (reasons for network failure are diverse) and should remain...

if you have a server + backup setup and up to doing the log shipping yourself, this will be the better approach compared to replication (since you do not need...