MonsterRocks (11/14/2010)

---

declare @x1 varchar(10)

declare @x2 decimal(38,7)

set @x2 =22225655.95163

set @x1=convert(nvarchar,@x2)

set @x2=convert(decimal(38,7),@x2)

print @x1

its output is 22225655.9

wht shud i pit in scale if i want to display 7 digits...

Use the following to pre size the primary data file

alter database MYDB modify file (name = MDFLogicalFileName, size = SizeInMBorGB)

e.g. size = 100MB or size = 100GB

to check the last\current id column value used execute the following query

dbcc checkident('tablename', noreseed)

casting binary or varbinary can be unreliable depending on the collation, you would probably want to use sys.fn_varbintohexstr

The best method is detailed at this link and converts to all bases

switch to bulk logged rather than simple recovery, alter index rebuild is minimally logged in this mode too!

download my guide at this link and check section 4.2 "add a cluster node".

If you look closely at the installer you'll see 2 options, one for create a new SQL server failover cluster and one for add a node to a SQL server...

with all that's mentioned here, this is why you test before migrating Live. Check with internal devs\vendors whether they support the RDBMS platform or not!

One thing that can issues between...

not problematic, but does require downtime of the other nodes in order to patch the new passive...

Launch the sql server 2008 installer on node b and select add node to a sql server failover cluster.

Step through the wizard and when prompted select the default instance...

So why have you posted in the SQL Server 2005 forum then???

No, the install...

To add node b to the default clustered instance go into add\remove programs on the active node and under the currently installed programs click the SQL Server 2005 entry and...

you have to launch the installer on the passive node and select the option "add node to a SQL Server failover cluster".

by who?

I would recommend you change this

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003,

Standard" /noexecute=optout /fastdetect /execute /nopae /3GB /Userva=2650

To this

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows...

It's to allow the removal of updates and service packs.