From Microsoft: This Property is Read-only, so nothing is wrong.

If you not don´t want receive that notification simply disable that feature from Job.

Regards

I suggest this

If @ID = 0

BEGIN

...INNER JOIN dbo.Table_2 T2 (nolock)

ON T1.column = T2.column

end

else

begin

INNER JOIN dbo.Table_2 T2 (nolock)

ON T1.column = T2.column

AND ( T2.ID = @ID)

END

That is the simple way to...

Hi, the solution in this link it's really good but isn't simple:

http://www.spaceprogram.com/knowledge/sqlserver_recover_from_deleted_log.html

Please, you must follow instructions step by step, reading carefully. It's work... Trust me.

but, the 10 step may be don't...

 Hi,  only if you working with sql 2000:

1 First of all, you  need create a function:

Create function dbo.staffnames (@taskid int)

RETURNS nvarchar(255) AS 

BEGIN

 declare @txt nvarchar(255)

 set @txt =...

but... what happens if the location column type is text? and the order of insert is c, a, d, g, f, e? the results of query must be 'e' no...

I agree whith fhanlon, i couldn't see the reasons for implement this in vb or c# even with ado.net. May be you need to know how to show this data on a web page.

try with this...

1.- add a new column in an access table

    Name : RowID

    Type : Autonumeric

2.- Load the data in your SQLServer Table, with the same new structure

3.-...

here another tips...

--T-SQL

declare @retval int

exec @retval = master.dbo.xp_cmdshell 'c:\program files\myapp\myapp.exe'

print @retval

if @retval = 0 then the execution was succefully

-- JOB

You may use Operating System Command (CmdExec) option from 'Edit...

Ok, Try with this...

select 'UPDATE ' + object_name(c1.id)

     + ' SET [' + c1.name + '] = '

     + case  when c2.xtype in (58,61,111)

                  then '''1900-01-01'''

             when c2.xtype in...

Hi , if I understand, may be this code help you!

select 'update ' + object_name(id)

     + ' set [' + c.name + '] = '

     + case c.xtype when 61 then...