DO you have sp2 Applied??

I ran to this problem>But just as mentioned by saying ok i see that the database is restored.

I have a question can u see the master Database Once u restart...

As you have mentioned one canot keep track of the selects using the triggers,I think you can get this information by running the trace several times with intervals(for performance) and...

try sp_depends 'CallingProcedure'.

It should give all the called procedure names.Once you get these names I think you can generate a script for all the stored procedurs which are called.

Hope this is what you are looking for.

Insert INTO Header(BillID)

SELECT Column1 FROM Table1 WHERE ID = @ID

INSERT INTO Detail(Columns)

SELECT Columns FROM Table1 INNER JOIN Table2

ON Table1.ID = Table2.ID......

I don't think you can script the stored procedures which are encripted.They should be scripted and saved at the time they are created.

SELECT @@Version

on the client machine.

Washingtonpost jobs.

http://www.washingtonpost.com/wl/jobs/home

Hope this will help

SELECT *

FROM tasks

WHERE (CONVERT(CHAR(10),runtime,101) > '11/1/2002') AND (CONVERT(CHAR(10),runtime,101) < '11/2/2002')

Hi,

Since you have the Column already defined the Sql should be

alter table classcodes

add constraint pk_class primary key

Clusterd/Nonclusterd

(class )

I agree with Simon Sabin.

Check if that record exists in the table into which you are trying to insert.

IF EXISTS(SELECT Column FROM Table WHERE COlumn = @Column)

I have found this URL on sp_mergecleanupmetadata Optimized for Speed and Less Disk Space Usage

http://support.microsoft.com/default.aspx?scid=kb;en-us;274376

Hope this might help you.

Does it have any other kind of permissions like serveradmin or dbo??

Hi ,

You were able to backup the tables only in SQl server 6.5 version.But after 6.5 version you cann't backup only the tables.If you want to do that as meantioned...