delete [Schema1].[Table2] from [Schema1].[Table2]

Inner Join Table2 P on Table2.Table2Id = P.ParentTable2Id

INNER JOIN #DeleteTable1 On [Schema1].[Table2].[Table2Id] = #DeleteTable1.Table1Id;

Something to this effect should do it...

Hi,

So I have one question first. Did you grant the permissions directly to a user or role?

If you granted them to a user - try creating a database role...

Yes on MSDB sorry I forgot to mention that

Grant permissions based on the info below:

sp_add_jobDeny Execute

sp_add_jobscheduleDeny Execute

sp_add_jobserverDeny Execute

sp_add_jobstepDeny ...

You are on SP3.

SQL Server 2000 RTM 8.00.194 RTM

Database Components SP1 8.00.384 SP1

Database Components SP2 8.00.534 SP2

Database Components SP3 8.00.760 SP3

As far as what...

If your not doing anything with the old server. Stop the services and grab master mdf and ldf and then stop sql on the new server and swap out master....

Why don't you just run this

sp_MStablespace tablename

Yes I would hope so. I am in the process of evaluating Precise's Indepth for sql server, Net Iq's App Manager and also using Oracle Enterprise Manager pointed to sql...

I do this using a tool called typeperf. However typeperf can be a headache because you have to send a keystroke to the console to exit. So what I have...

Yes you can use a profiler trace to get the information desired. When you create a new trace click on the filters tab and scroll down to objectname or objectid...