FIrst, you really need to read the first article I reference below in my signature block regarding asking for help. You may have provided your code (and I am...

KumarSQLDBA (12/27/2012)

---

How can i start the next job step of job in the same job?

I have tried like '--EXEC msdb.DBO.sp_start_job @job_name ='dhhjdhjj', @server_name = N'Sdhjhjfhjfhj',@step_name ='step1'

But getting...

dedicatedtosql (12/26/2012)

---

Thank you very much for the advice.

Actualy We have both CDC as well as Auditing in place for the prod database. But this was a local environment. Where we...

If it is important to know who did something, you should look at setting up auditing so that you can capture this in the future. You may also want...

Please, do not encourage him! We want him to go haunt an Oracle site for a while.

Jeff Moden (12/26/2012)

---

Like Gail said... Yes.

Would these...

Something like this:

WITH CTE AS

(

SELECT

name as TableName,

object_id

FROM sys.tables WHERE schema_id = schema_id('dbo')

)

SELECT...

ScottPletcher (12/25/2012)

---

Lynn Pettis (12/25/2012)

---

ScottPletcher (12/25/2012)

---

Lynn Pettis (12/24/2012)

---

ScottPletcher (12/24/2012)

---

You also need to verify that the log LUNs are RAID10 and the data LUNs are RAID5 (typically that is the best performance).

If...

ScottPletcher (12/25/2012)

---

Lynn Pettis (12/24/2012)

---

ScottPletcher (12/24/2012)

---

You also need to verify that the log LUNs are RAID10 and the data LUNs are RAID5 (typically that is the best performance).

If you're going to...

imaceo58 8163 (12/25/2012)

---

Lynn, thank you....

Now after inserting rows into GwenF_department , and executing the function .....

drop function dbo.udfSalaryRaise;

CREATE FUNCTION udfSalaryRaise()

RETURNS @Results TABLE (

departmentname ...

Merry Christam everyone.

We are having a White Christmas here. It has been snowing since 6:00 PM and is still snowing now.

imaceo58 8163 (12/24/2012)

---

I am getting this same error message ...Column name or number of supplied values does not match table definition.

My table definition is...

I am assuming users insert/update/delete records using an application, not by directly writing SQL statements. If so, this is something that should be handled in the application.

Nidhi G (12/24/2012)

---

Hi,

I have a table with syn_trans with below cols:

(

Id integer(10),

Name varchar2(100),

seq_no integer(10),

seq_name varchar2(100),

gp_name varchar2(100)

)

There is no unique/primary key on the table.

A row exists in table with below...

Without being able to see what you have to deal with, or at least a reasonable facsimile of the data, it is hard to provide you much guidance. This...