Hello,

Please see the topic "Security for SQL Server Agent Administration" in BOL (SQL 2005 Books on Line).

NB: If you are a member of the fixed SQL Server Role sysadmin then...

Hello,

As you don’t have a recent backup you could attempt the recovery process described in this article:-

http://www.codeproject.com/KB/reporting-services/SQL_2005_Suspect_Database.aspx

The following article gives more general advice on handling Suspect DBs;-

http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp

Regards,

John Marsh

Hello,

The first error message refers to a Primary Key Violation. (A Primary-Key is the Column(s) that uniquely identify a record in a table). This suggests that either the data you...

Hello Vijoy,

Thanks for the update. It is good to hear that the issue has been resolved.

Regards,

John Marsh

Hello Priyanka,

Just to double check that you are Setting ARITHABORT to ON inside the SP's logic, rather than in the script that creates the SP? As I understand, you get...

Hello,

There is a dependency on your Server Role membership. Which one(s) do you have?

Regards,

John Marsh

Hello,

If you have a tool such as Visual Studio then you can use the Debugger to step through the execution of the code and see the logic flow.

Without a debugger,...

Hello,

In SSMS:-

- Open up the Object Explorer

- Connect to the required Database Engine (your SQL Server)

- Expand the "SQL Server Agent" node

- Right Click on "Jobs", and select "New Job"

Regards,

John...

Hello,

Did you spot this MS KB article already?

http://support.microsoft.com/kb/834124/en-us

Regards,

John Marsh

Hello,

You would probably want to create the Computed Column from a Case statement based on column c2, with the if/else logic comparing it to column c1.

Regards,

John Marsh

Hello,

You could consider using Snapshot Replication, but may be a scheduled SSIS package is easier to Administer.

For the SSIS package, use the Export Wizard to perform the task once and...

Hello,

This is probably because of the security context that you are using to access the Linked Server. For example, are you passing through the Windows/SQL Login that is accessing the...

Hello,

I am assuming that no .Net exceptions are being thrown? If there are any, then what errors are you getting?

If .Net thinks everything is fine, than here are a couple...

Hello,

Is InsPolicyVal a Scalar or Table function? If it’s Scalar then you should be able to use it as in your example. If it is a Table function then you...

This works for me as well:-

Use tempdb

Go

/* Create Local tables */

Declare @TempTbl table

(

[Fie1d1] varchar(100),

[Fie1d2] varchar(100),

[Fie1d3] varchar(100),

[Fie1d4] varchar(100),

[Fie1d5] varchar(100),

[Fie1d6] varchar(100),

[Fie1d7] varchar(100),

[Fie1d8] varchar(100),

[Fie1d9] varchar(100),

[Fie1d10] varchar(100),

[Fie1d11] varchar(100),

[Fie1d12] varchar(100),

[Fie1d13] varchar(100)

)

Insert Into @TempTbl

Execute xp_sqlagent_enum_jobs 1,...