ApexSQL Diff

The error description says that you are inserting duplicate values. Check the values being inserted in the tables.

This information is not tracked by SQL Server. You can set up auditing to

track execution of procedures so that they logged a date time value in a table every time...

SELECT dbo.[query 2 b ].Expr1, dbo.[query 2 b ].Expr1 AS Customer_No,

...

select

dateadd(ss, -1*ms_ticks/1000, getdate()) "Last server reboot time"

from

sys.dm_os_sys_info

Could you post the code?

SELECT * FROM myTable a

join select Value from Split(@myIDParam,',') b

on a.myID = b.Value

Refer:

http://www.sqlservercentral.com/memberservices/updatescript.asp?Approve=y&scriptid=850

SELECT @IMPORT_FILE_PROP = column_X + '\file.TXT'

from database.Schema.table

Where <>

Hi Paul,

Join Postions table with recommendations table and make a derived table. It should work.

Hi,

You can use sp_MSForEachTable undocumented stored proc.

exec sp_msforeachtable "sp_spaceused '?'"

Your first parameter, (* CHAR(10) *), in ur first SQL truncates the time portion where it does't in ur 2nd SQL.

You can write a trigger on base table for this type of referential integrity (FK).

here is the sample code...

use tempdb

create table junk (srno int primary key, descr varchar(30))

use sample

create table junk (srno int primary key, descr varchar(30))

create trigger tr_iu_junk on junk for insert,...

if you have previous days backup then can restore otherwise

Hope you are using SQL Server 2000. If so here is one of the way to solve ur problem....

declare @test-2 table

(

taskvarchar(30),

datedatetime

)

insert into @test-2 values ('Inspection 1', '1/1/2006 09:00')

insert into...