Viewing 15 posts - 17,476 through 17,490 (of 18,926 total)
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...
June 1, 2005 at 11:41 am
Start the trace and look for this sp execution :
sp_defaultdb
Public is granted access by default.
June 1, 2005 at 11:38 am
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...
June 1, 2005 at 11:32 am
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...
June 1, 2005 at 11:31 am
Yup, then you show up at PASS with that recording... Sure would get you some freebies
.
June 1, 2005 at 11:18 am
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....
June 1, 2005 at 11:13 am
Me neither... I never had to deal with big databases. I'll let the other dbas take this one.
June 1, 2005 at 11:10 am
Was he selling the server too?
On a more obvious side : did you buy the software??
June 1, 2005 at 11:07 am
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
June 1, 2005 at 11:03 am
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...
June 1, 2005 at 10:53 am
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...
June 1, 2005 at 10:48 am
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..
June 1, 2005 at 10:47 am
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. ...
June 1, 2005 at 10:45 am
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...
June 1, 2005 at 10:25 am
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...
June 1, 2005 at 10:23 am
Viewing 15 posts - 17,476 through 17,490 (of 18,926 total)