Viewing 15 posts - 34,876 through 34,890 (of 39,723 total)
You are correct there is no default for DELETE, but I think the person was getting at what you said. The default options set for the FK.
May 25, 2004 at 6:34 am
Try changing the columns you get, I'd bet you get a different row cont. We fought this issue using Client Access going against a AS/400 and didn't get a resolution...
May 25, 2004 at 6:30 am
I would say no. You read by pages, and a page has to contain an entire row, so the order wouldn't matter. I suppose that the query processor could short...
May 25, 2004 at 6:26 am
I agree with Antares. You don't want another Windows machine to be a router since that would be asecurity risk. Another SQL Server that could see both, while inefficient, would...
May 25, 2004 at 6:22 am
I assume the logfile is full for one of the databases. You haven't really posted much informaiton. You can try "backup transaction xyz with no_log" and then run a full...
May 25, 2004 at 6:19 am
replication is for data movement, not schema, permissions, etc.
I use backup/restore.
May 24, 2004 at 9:13 am
There's a few articles on this site regarding fillfactor and how it works. Basically if you're data is static, not many inserts/updates/deletes, choose a high fillfactor, like 80-90%. If you...
May 24, 2004 at 8:55 am
That works for insert, update,delete, but not for select queries. Fro that you'd need to run Profiler and then examine the data. I'd recommend you do this for a few...
May 24, 2004 at 8:48 am
Get a local administrator to connect using NT authentication and reset the sa password.
May 24, 2004 at 8:43 am
The references above are great. I wouldn't move master, just move the databases and use sp_help_revlogin to get the logins. You might need to use sp_change_users_login to synch them up...
May 24, 2004 at 8:40 am
you should be able to connect with the ip of your home computer if its running sockets. Be aware that this is a secuirty issue and you should have a...
May 24, 2004 at 8:36 am
Why not reinstall? It's easy, detach the dbs, script out the logins (sp_help_revlogin) and uninstall. The install std, run the script, attach the dbs.
May 24, 2004 at 8:34 am
Again the question, why? v2k will run in v65 or v7 compatability mode. The W2K3 kernel is substantially different, so there may be issues. W2K was a big change from...
May 24, 2004 at 8:32 am
This is most likely unsupported and I'm reaching back to remember how well it worked, but...
v65 was more "friendly" in terms of hacking the system tables. So we did a...
May 24, 2004 at 8:28 am
I had a similar problem and didn't really ahve time to research it. And I had another option. I uninstalled, and reinstalled the server (detach, then attach dbs, script out...
May 24, 2004 at 8:24 am
Viewing 15 posts - 34,876 through 34,890 (of 39,723 total)