the trigger i wrote will prevent all inserts/updates on TableB even if the insert/update is coming directly from the application or as a result of trigger on TableA, if it...

Use tablediff utility.

http://msdn.microsoft.com/en-us/library/ms162843(SQL.90).aspx

http://www.mssqltips.com/tip.asp?tip=1073

markos (6/15/2009)

---

Hello.

Now my question is: if I restore the DB at (for example) wednesday 3pm, do I need to make a new manual full backup after the restore or would...

If your application is using a distinct user id, the u can write an INSTEAD OF trigger on table b and check if the user_id is same as application's. if...

This contains how u update data to a column with text data type

http://msdn.microsoft.com/en-us/library/ms177523.aspx

Look at examples 'G' & 'H' there.

use msdb

select user_name, * from msdb..backupset where database_name='Your_DB_name'

order by backup_set_id desc

I ran the code after making changes and it ran perfectly without any error!!

---===============================

EXECUTE master.dbo.xp_create_subdir N'c:\test\test'

GO

BACKUP DATABASE test TO DISK = N'c:\test\test\test_backup_2009_06_15_184702_5511435.bak' WITH NOFORMAT, NOINIT, NAME = N'ITAM_backup_2009_06_15_184702_5511435', SKIP, REWIND,...

Open the backup maintainance plan, Click on the button View T-SQL, and fire the statements one by one... U shud be able to locate exact syntax error.

You can also post...

Thanks for pointing that out Gail. It was a typo error :w00t:

I checked it's not captured by the default trace.

This URL provides list of all security audits that can be performed.

http://msdn.microsoft.com/en-us/library/ms191148(SQL.90).aspx

msdb- whenever u add/delete/modify a job/maintanance plan, any thing that relates to sql server agent, you shud backup this database up.

model - this is the template for new databases,...

msdb- whenever u add/delete/modify a job/maintanance plan, any thing that relates to sql server agent, you shud backup this database up.

model - this is the template for new databases,...

am glad u got it work!!

but still few things not clear...

@val2 is used to store Item_code in the cursor but u faced problem with quantity column??

i removed all the constraints from the definitions u posted.

---=====================

CREATE TABLE [dbo].[article](

[oarticlenr] [int] NOT NULL,

[odescr] [varchar](500) COLLATE Latin1_General_CI_AS NULL,

[odate] [datetime] NULL...

mathewspsimon (6/15/2009)

---

sir,that was a dummy table for this cae.I dont know what is the reason,is it becuase there are 1000 rows?the output of the cursor shows as I mentioned as...