autoshrink is a bad idea for any database because it can lead to fragmentation

have you tried to use servername\instancename and no port number?

i have a publisher that is a named instance and that is how i connect to it even though it's on...

don't think you can do that

RS needs the database engine because it creates two databases

why do you want to backup tempdb?

be careful of schemas, they are always looking to scheme you out of something

some transactions like index rebuilds are fully logged regardless of what your DB is set to

no, i only run index rebuilds so i don't have to worry about updating statistics

reorganize doesn't update stats, only rebuild does

i run a modified version of this and my reorganize command is set to <1

what about using db_mail? just put the external smtp server into the config

maybe it's me, but i like to only do rebuilds. i mostly support EE so online rebuilds aren't a big deal.

rebuilds also rebuild the statistics and with reorganize i have...

i don't do much ETL except for moving some data between servers, but i've started to use SSIS less and less for it and back to the old way of...

you first have to change the IP on the old server and then set up the cluster

for the cluster you will need 4-5 IP's

1 IP for each of the physical...

there is no SQL OU by default. i called mine SQL Access

we create groups and then map sql logins to those groups. then either give db_reader role on replicated copies...

when you install SQL on the cluster it will ask you for the IP. by default when you create the cluster it only creates the default cluster group. when you...

if it's an overflow my guess is that the input is too large for the output data type you are specifying. like taking a bigint and trying to put it...