Your problem is you use

NestedSel.*

This part already contains a mkt_rate column.

You generate a new mkt_rate column right next using

mkt_rate =...

Nice ... the N-th datetime solutions payback time :hehe:

Just for correctness ...

can you elaborate and split your bigint into the date part and the timepart ?

1196100822809

1196 = NoDays

10= HH

08 =...

how about this:

Declare @mybigint bigint

set @mybigint =

convert(bigint,replace(replace(replace(replace(convert(char(23), getdate(), 121),'-',''),':',''),'.',''),' ',''))

print @mybigint

declare @mychar char(23)

Select @mychar = convert(char(23), @mybigint)

Select @mychar = substring(@mychar,1,4) + '-' + substring(@mychar,5,2) + '-' +...

You could add new filegroups and move your data to the appropriate filegroup by moving the clustering indexes.

Also keep in mind you may also have to move non clustering...

I haven't performed it on a replicated database.

Keep in mind, you can only shrink a log file up to the 'last' active chunk it uses.

Maybe you'll have redo the shrink...

- Did you also rebuild all indexes after your migration process ?

- replace the ltrim with a like statement if you can.

- as Gail already pointed to : don't use...

No.

Restore performs its action to the same number of files as was the case for the original database. (the one you backed up)

It even needs the same space requirements to...

Out of the box...No.

- you could search SSC for some scripts to help you out 😉

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61340/

http://www.sqlservercentral.com/scripts/Miscellaneous/31893/

- You could build your own SQLSMO application, generating dependent objects and then using the...

JanM (9/29/2008)

---

Hi

I try to get the server version by the followin command:

osql.exe -Sserver\instance -Usa -P*** -Q"USE master SELECT @@version" -p

This works for the Instance installation. But how do we get...

Strange having your reg pointers messed up :crazy:

I haven't seen that issue ...

I'm glad you managed to fix it and got to do the thing you intended to.

HTH

Adam Bean (9/26/2008)

---

When I first went from EM to SSMS a few years ago, I absolutely HATED SSMS ... couldn't stand it. Yet after about 6 months or so, I...

I think my little article regarding sqlserver and SOx can help out.

I think you should use :

start /wait setup.exe /qB VS=PRESQL17 INSTANCENAME=PRESQL17 REMOVE=ALL ADMINPASSWORD=XXXXXXX GROUP="SQL" IP="XXXXXXXX

Be carefull with remove all !

If this is the only instance on the box, it's ok,...

Thank you for the feedback.

We still haven't found the cause of this incident.

We do have a number of servers with sql2000 on it, this is the only cluster that...