Viewing 15 posts - 34,951 through 34,965 (of 39,793 total)
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
Beta is due out anytime. May/June for B2 was the last we heard.
As far as the help, it's built around the Codewise community. Both Whidbey (new Visual Studio) and SQL...
May 24, 2004 at 8:11 am
We are as well!
,
The new help system in the product includes searches on various communities, including this one. Check it out!
May 21, 2004 at 11:09 am
Personally I think Yukon will require more DBA work. Adding all that into the RDBMS will create more and new issues, require more control of changes, and require the DBA...
May 21, 2004 at 11:04 am
From some searches, it appears nobody knows. In fact, you seem to have more information than most. Care to write an article on your experiences?
May 21, 2004 at 7:52 am
I haven't seen this, but the general network error means the server didn't repond to a request. From what you have listed, it's possible you have some structural problem that...
May 21, 2004 at 7:45 am
Viewing 15 posts - 34,951 through 34,965 (of 39,793 total)