gee thanks, i dont need to read BOL now 😉

which vendor do you plan on using?

your chosen vendor will supply any training you may need

use the following

select @@servername, serverproperty('servername')

they should return the same name, if not use sp_dropserver and then sp_addserver

you can generate the SPN's manually using

SETSPN.EXE

syntax is

setspn -A ServiceClass/Host: Port AccountName

so for sql instance is

setspn -A MSSQLSvc/mysqlserver.domain.co.uk:staticsqlportnumber domain\sqlserviceuseraccount

use setspn -L domain\sqlserviceuseraccount

to list the SPN's

😎

set up some perfmon counters and profile the developers code. Once you have the trace and permon results you can tie them together and check for problems that way

from BOL 😉

SERVERPROPERTY ( propertyname )

InstanceName

Name of the instance to which the user is connected.

Returns NULL if the instance name is the default instance, if the input is...

bodhilove (8/18/2008)

---

Hope you don't find my explanation too dry...

I am transfering a 2000 db to 2005. I haven't been given a test environment to work with. I am migrating by...

Redgate gets my vote

create a domain account and have the agent service runas that account (use sql configuration manager to change the account details). Give this account permissions to whichever remote folders it...

none of my registered servers have the green and white arrow only connected servers

Scott Duncan (8/11/2008)

---

Watch out for apps backing up their own databases. They may be useful for places that don't have a DBA to look after things properly but otherwise...

fully review all operations that occur over the weekend before the log backup happens on the monday, something is interrupting your backup chain. Does your index rebuild or maintenance plan...

are both machines on a network?

if so, put the cd into the drive of the machine where installation was successful and share the disk out. The launch setup from the...

you can also run the SQL setup from cd and that can be used to modify installed instances

i would apply some normaliastion to table 2 as suggested first as you'll find yourself ending up with some extra tables which will change the query anyway