lakshminarasimhanv (6/20/2009)

---

hi Thanks for your repl

Can you please tell me how to modify the script to delete records from master and check if any dependent child will be afftected....

that would be the easy part; since the temp table #Hierarchy has the tables in the right order, change the last SELECT statement to this:

SELECT

CASE WHEN FKLevel=0...

you must explicitly identify the column names, especial when identity_insert is on:

SET IDENTITY_INSERT MyTable ON

insert into MyTable(ColumnId,ColumnDate) values(3508,'06/07/2009')

zubamark (6/19/2009)

---

Hi,

I tried to execute in SQL Server 2005 Query Analyzer the following...

something like this should get you started:

SELECT

@Category As TheSelectedCategory,

CASE

WHEN ILCategory IN (3,4) AND SCCategory =1

THEN...

here's a script that creates the delete/truncate commands for all tables in the correct foreign key hierarchy order....

the issue I've always found is that often you have lookup tables, like...

Ok - but the problem is, sometimes the parent_id could change from another system. That's where I'm getting lost here. I'm trying to avoid using the parent_id as an identity....

you wouldn't open a trace file directly with notepad.

here's what i do:

i create a view for any trace i create, so I can easily access it.

here's a code example:

--review all...

Dugi's got you on the right track. use ISNULL to put in a default value, or raise an error before it gets to the trigger in the first place.

as...

ps (6/19/2009)

---

you can write a query to delete all tables in a schema.

Also wouldn't it be good to drop the database if you do not want tables to be there?

Question...

your'e trying to use an identity() column in the wrong way; an identity should simply identify one row as unique, and should never repeat...what you want is basically a ranking...

it can be done yes...but it's going to involve a bit of work. search for "FTP" on this site, and look at "Scripts" ; there s quite a few contributions...

GilaMonster (6/19/2009)

---

You wanna maybe tell me why you want to remove an entry from an error log? The main use I could see for that is to hide evidence of...

'ftp://username:password@xx.xx.xxx.xxx/domainname/www/textdocument.txt' is not a static filepath..., you have do download the file from your ftp site to a location on the server(or maybe in anetwork share if your account...

it might be that you need identify the columns to insert into:

INSERT INTO DatabaseReport.dbo.Database_File_Info(col1,col2...)

did i misread the question? i thought he wants audit triggers to write to a separate database,and didn't see where anything about a separate server.

I thought it would be a...