Just to clarify the problem with your current code :

If you have Tablea A inner join TableB B on A.id = 1 and A.id = 2 it will always...

Start the trace and look for this sp execution :

sp_defaultdb

Public is granted access by default.

Script the foreign key, drop it, truncate, recreate foreign key... I was under the impression that it was possible to do it without dropping the relation.. but apparently it is...

It's better to have more information than less.

Here's an example of what you need using the system tables...

--find all the tables that have the columns indid, id :

Select O.Name...

Yup, then you show up at PASS with that recording... Sure would get you some freebies .

Maybe you should have said :

But I have 47 users, do I have to buy a 47 way server??

Then record the answer and playback at the Christmas party....

Me neither... I never had to deal with big databases. I'll let the other dbas take this one.

Was he selling the server too?

On a more obvious side : did you buy the software??

Please don't cross post, we check all forums at all times.

Finish the discussion here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=48&messageid=186681

If you just want to wipe out both tables, you can disable or delete the foreign key, then you'll be able to truncate both tables.

Here's out to disable / enable...

Just to fish out numbers... I've read about servers that handled 100s of dbs. I think it all comes down to how much traffic are the apps sending and...

This is just a hunch... is it possible that the db size if set to a certain fixed number?.. can't think of anything else to help you in this situation..

I'm flattered but I don't have the time to take on a contract at the moment...

Maybe you could do a post in the jobs posting of this site. ...

You'll have to delete the data in the child tables before deleting the parent table's data (even truncate can't go around this).

What's the problem you're trying to solve...

This will fail if the data is not numeric, you might want to change the column's datatype to decimal if a varchar is not its most meaningfull datatype.

SELECT top 1...