Silverfox

Forum Replies Created

Viewing 15 posts - 61 through 75 (of 1,136 total)

RE: Drop

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...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 9:26 am

#1075446
RE: Drop

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...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 8:28 am

#1075392
RE: Drop

Tara-1044200 (11/5/2009)
Can a user with Read/Write/ddl_admin previalges drop the database ?
No, you should get an Execute permission denied on the object 'sp_delete_backuphistory', database 'msdb'
This has been tested on my own...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 8:13 am

#1075370
RE: query please help

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...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 5:47 am

#1075277
RE: query please help

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%' ...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 5:39 am

#1075273
RE: How to Convert the Decimal

the round function will do that, amongst others.
select round(4.4,0)
4.0
select round(4.6,0)
5.0
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 5:33 am

#1075270
RE: query please help

SELECT SUBSTRing
(description,charindex ('[', description),charindex (']', description)
)
FROM PublishItem
WHERE description like '%Doc No%'
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 5:25 am

#1075263
RE: query please help

select substring('12345678[abcdef]hijkl',
CHARINDEX('[','12345678[abcdef]hijkl'),CHARINDEX(']','12345678[abcdef]hijkl'))
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 5:20 am

#1075260
RE: query please help

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 ('[',...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 5:16 am

#1075257
RE: How to Convert the Decimal

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...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 5:10 am

#1075252
RE: Backup

y.koteswarrao-652921 (11/5/2009)
Hi,
how to determine the backup is successfully completed?
Thanks
koteswar Rao
You can check the sql log as first point of call.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 5:03 am

#1075251
RE: Afraid of Help

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...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 4:09 am

#1075235
RE: database goes down

first off, is sql server still running. if so allocate more space to the database. if not free more space on the drive.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 2:34 am

#1075218
RE: Milestones

No idea what you mean, can you give more details.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 2:33 am

#1075216
RE: Database on different disks

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...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

November 5, 2009 at 2:32 am

#1075214

Viewing 15 posts - 61 through 75 (of 1,136 total)