arun.sas (4/5/2010)

---

flash.rsn (4/5/2010)

---

You dont need to add vairable, use veriable table and insert your input hour/minutes values to this table to use as a parameter and pass it to IN...

i wrote that i want to fire the 3 min proc inside the 2 min schedule sql agent job but the proc will not interfere with the 2 min sql...

the call to the proc must be run from within the 2 min job.

is this is the only way to achieve my goal?

can call this proc from the 2 min...

ok.

how can i do the service broker event to call this sp?

THX

thanks.

the OR is if one of them not exists then it will execute the if.

i want to check if both rows not exists then do the if.

i need to check...

thanks.

another approach maybe someone have?

THX.

i'll go with the try an catch.

Hi,

try an catch is the only way to allow the proc to continue to run even if he have an error?

THX

CirquedeSQLeil (2/5/2010)

---

Your regional settings determine the date format. However, that is why there are standards that many use to format the datestamp in a common format for servers they...

Max Wei (2/5/2010)

---

The command 'net statistics server' seems not so reliable to report the uptime of a server.

Out of curiousity, I ran it on on several servers, the...

can you tell me please on what it deepened in sql server to show the date format like mdy or dmy?

THX

CirquedeSQLeil (2/4/2010)

---

if you set a default on the field to accept a specific format - it should convert it for you.

Are you capturing more information than that? If you...

ok.

if i use this command EXEC...

i can't change it permanently.

but can...