Hi David,

quote:

---

Having had a quick read around the C2 auditing subject (and deciding that it is massive overkill) does this imply that...

Hi Raymond,

this is growing really big!

SELECT [ELAPSED_TIME] =

CASE

WHEN ((CHARINDEX('h',elapsedtime,0) > 0) AND (CHARINDEX('m',elapsedtime,0) > 0)) THEN

SUBSTRING(elapsedtime, CHARINDEX('h',elapsedtime)-1,1) * 3600 +

SUBSTRING(elapsedtime, CHARINDEX('m',elapsedtime)-2,2) * 60 +

SUBSTRING(elapsedtime, CHARINDEX('s',elapsedtime)-2,2)

WHEN ((CHARINDEX('h',elapsedtime,0) =...

oops,

might be a little bit early today

Returns also NULL for the second where it actually should return something. I'll keep thinking over this.

Cheers,

Frank

Hi Raymond Kim,

well here's another approach.

What about

SELECT SUBSTRING(elapsedtime, CHARINDEX('h',elapsedtime)-1,1) *3600 +

SUBSTRING(elapsedtime, CHARINDEX('m',elapsedtime)-2,2) *60 +

SUBSTRING(elapsedtime, CHARINDEX('s',elapsedtime)-2,2)

This returns

NULL

NULL

18935

in your example.

The only thing that needs to be catched is if...

Hi JMeyers32,

sp_helpprotect should do what you need

This is taken from BOL:

A. List the permissions for a table

This example lists the permissions for the titles table.

EXEC sp_helprotect 'titles'

B. List the...

Hi,

well I'n not very experienced in JAVA, but maybe you can post some code snippets. That will surely help!

Cheers,

Frank

Hi Brian,

quote:

---

Like I said, as a DBA, you're really hand-cuffed if the developer doesn't build the application securely. Hence the reason for...

I have made not so good experience setting the size of Page file to what Windows suggests. The system is slowing down. I have set it manually to 2.5x of...

Hi Brian,

a daily newsletter will be a great idea and I think a must-have. There are several sites out there offering this feature. If I can help in any way...

Hi SueStill,

the first thing that came to my mind is the security aspect. You have definitely more control on permissions by using procs.

Accessing data via view inside a proc...

Hi matt1,

quote:

---

no its not but how to you view them in EM?

---

case you've created it...

Hi matt1,

in EM expand your db, click on the Stored Procedure entry and from the list on the right choose your procedure. Double the procedure to see the content.

Cheers,

Frank

Edited by...

Hi Clive,

quote:

---

Yeah, an example would help. Franks example would work if the id field is sequential. If you delete a...

ooh, and you can use xp_cmdshell for checking and creating

DECLARE @result int

EXEC @result = xp_cmdshell 'some dos_commands'

IF (@result = 0)

--go on

ELSE

--create dir and go...

Good point,

take a look at BACKUP DATABASE in BOL.

Cheers,

Frank