Viewing 15 posts - 35,356 through 35,370 (of 39,769 total)
I'd go with what I see in sp_configure. It's possible that the EM is pulling some information from somewhere else, but I'd bet that the sp_configure is what the server...
January 26, 2004 at 5:31 pm
Not in master. too easy to forget on restore, rebuild of new server, DR, etc.
Store it in each db, build a script to redeploy to multiple databases if you have...
January 26, 2004 at 5:30 pm
Sorry about the single line, forum flips out randomly.
I tend to store in a .asp include file, depending on what the data is. In a financial company, we did use...
January 26, 2004 at 11:48 am
sp_changeobjectowner or
create table personal.tableA instead of create table tableA
January 26, 2004 at 10:30 am
The old system grouped by forum, then listed threads by reverse datetime of the last post. We'll get there since I keep bugging Andy as well. I depend on this...
January 26, 2004 at 9:56 am
I found it annoying as well, but changing it in my profile solved that issue. It isn't checked anymore for me.
January 26, 2004 at 9:54 am
That's a good one. I'll pass that along though usually authors approach us with topics. However we do have a monthly newsletter for authors only, so we could add in...
January 26, 2004 at 9:50 am
Good suggestions. I'll take them into account and produce an updated list in a few weeks.
One thing I want to point out is that I wanted this to be a...
January 26, 2004 at 9:49 am
Not sure about the backup and restore ?, but you can use dbcc showcontig to get a feel for the fragmentation in tables.
January 23, 2004 at 5:20 pm
Check the script library, but this would not be hard. Select from sysindexes, build a command line to rebuild the index, add the clause to move to filegroups and exec()...
January 23, 2004 at 10:37 am
I understand, but there is no good way if people want to cross post. I try to delete them if I see them.
January 23, 2004 at 10:32 am
You have to have a disk subsystem that is shared between the servers. Each server must connect to it. IF you can do it with IDE, let ME KNOW!!!!!
January 23, 2004 at 10:28 am
January 23, 2004 at 10:25 am
Try reinstalling your tools. Works fine here, XP SP1.
January 23, 2004 at 10:22 am
Not completely sure what you mean, but you can create a view
create view myview as select * from servera.ownerb.tablec
and then select from this view.
January 23, 2004 at 10:20 am
Viewing 15 posts - 35,356 through 35,370 (of 39,769 total)