Gila,you got it. I forgot the where cluse, Thanks so much.

I am getting the error

Msg 536, Level 16, State 5, Line 1

Invalid length parameter passed to the SUBSTRING function.

Not sure what examples or sample data you are looking for when...

Not sure if understood you guys correctly but are you saying that i can remove last 12 charcters using LEN function?

i am just trying s simple select stmt and it...

actaully there isnt any table in real, i am just trying to use len(column)-12 which seems to be not working but it works for len(column)-8 so i was thinking how...

any character other than alph-numeric is considered as junk.

Thanks so much Lowell, that did it.

If i am doing an insert not knowing there is a differretial backup runing for the same database at the same time, does my insert query is blocked or backup...

I did read this but didnt find which would be effected, either the inserts or the backup time when they both run at the same time.

deos this apply only for 2008?

tempdb2.

all drives accessible and compresseion not enbaled on the disks.

here is how i laied out.

tempdev1D:\DATA\tempdb.mdfPRIMARY1073741824 KB1073741824 KB10%data only

templog2D:\LOG\templog.ldfNULL512 KBUnlimited10%log only

tempdb23F:\DATA\tempdb2.ndfPRIMARY3072 KBUnlimited1024 KBdata only

tempdb34E:\DATA\tempdb3.ndfPRIMARY3072 KBUnlimited1024 KBdata only

and the D drive also has 450gb od space for OS paging

yes it is timing out. also just to refresh databases by right clicking it is taking atleast 10min which should be only in seconds.

It is taking too long for connecting to the server from managment studiio andfrom the event log i see this message "Starting up database 'tempdb'." Looks like after deleting one...

is it possible to send a pop up message to the sql server users?