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...

BTW, a simple thanx will do.

It still won't work. It'll sort by the numerical value 1,2,3... not the colid. Which if I remember corectly won't even be supported starting with Yukon.

You either...

You don't need to put anything in it, but you must declare it. I set it to something to show you that its value was changed in the proc.

Also...