Tara-1044200 (11/5/2009)

---

I am still confused how can a user with Read/Write/ddl_admin and dbcreator role deleted a production database. How can that happen though he is not owner of that database...

Yes, the thing i negelected to mention, is that with ddl_admin and the other permissions, if uou uncheck the option to remove the backup history. you will get a permissions...

No, you should get an Execute permission denied on the object 'sp_delete_backuphistory', database 'msdb'

This has been tested on my own...

steveb. (11/5/2009)

---

It was not in the original code, I just assumed that the poster was looking to extract the string between '[' and ']'

But I guess you know what...

steveb. (11/5/2009)

---

sorry read the code wrong this shoud work;

SELECT SUBSTRing

(description,

charindex ('[', description) + 1,

charindex ( ']',description ) - charindex ('[', 'he[lff]lo') -1

)

FROM PublishItem

WHERE description like '%Doc No%' ...

the round function will do that, amongst others.

select round(4.4,0)

4.0

select round(4.6,0)

5.0

SELECT SUBSTRing

(description,charindex ('[', description),charindex (']', description)

)

FROM PublishItem

WHERE description like '%Doc No%'

select substring('12345678[abcdef]hijkl',

CHARINDEX('[','12345678[abcdef]hijkl'),CHARINDEX(']','12345678[abcdef]hijkl'))

shanila_minnu (11/5/2009)

---

i need the substring from a column in such a way that i should get the string from 9th to 16th.below qury is throwing error.pls advise

SELECT SUBSTRing

(description,

select charindex ('[',...

If i understand you correctly you want to remove the decimal point, what do you want to do to the answer

do you want to just remove the .5 or do...

You can check the sql log as first point of call.

I wish people would distinguish between a consultant and a contractor, there is a world of difference and it annoys me no end. most people I know associate a consultant...

first off, is sql server still running. if so allocate more space to the database. if not free more space on the drive.

No idea what you mean, can you give more details.

suvorav (11/5/2009)

---

Hi all.

There is heavily loaded OLTP system under Sql Server 2008 Standart Edition. Database has some big tables. My question is about hard disk configuration. Database has problems with...