Edwin (8/19/2008)

---

Perry,

I ‘m a newbie on Storage Area Networks. I need to pick it up a lot and I only read some SAN articles on this forum.

We are planning...

do the sql services start as local system or a user account.

we had this recently on one of our clients, i re registered all the SPN's for the 8 sql...

Thayal Muhunthan (8/20/2008)

---

We purchased a super server to consolidate our sql versions. The spec as follows :

HP Proliant BL480c x5460 4G (2P) - BIG Blade

2 x Quad Core Intel X5460...

dunno, contact them and find out

how much do you think you need?

what do you...

update tablename set colname = '00' + colname

Edit:

oops you beat me too it

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