Viewing 15 posts - 6,166 through 6,180 (of 6,215 total)
Keep in mind that object ownership is not a simple topic. There are plenty of valid reasons for letting users own their own objects..I think anyway!
My preferred technique is to...
July 17, 2001 at 7:44 pm
Could you tell us why you need to do this? Im a firm believer in integer keys, faster and simpler. If you're concerned about key conflicts from multiple locations, uniqueidentifers...
July 17, 2001 at 9:23 am
Unless you made them part of dbo (dbowner), the objects will get named like this:
Barbie.table
Ken.table
Rather than
dbo.table
I avoid ownership chains - rarely worth the hassle. You can fix them after the...
July 17, 2001 at 9:20 am
You sure it's not a server based virus scan running? Or someone accessing something via the network? How about logging in locally to the machine to try the install? Might...
July 17, 2001 at 9:16 am
Let us know how it turns out.
Andy
July 17, 2001 at 9:14 am
Not in SQL2K. Im most of the way through writing a script that writes it to a file, then when I run the script again stops the trace, imports it...
July 17, 2001 at 9:05 am
Nope, no way I know of to prevent that. Encrypting the data seems best. I guess an alternative would be:
1) Stop the service
2) Save the first couple hundred bytes from...
July 17, 2001 at 9:03 am
I think you'd have to try it and see. I doubt any index is going to make a difference, unless the 17 million rows are a fairly small subset of...
July 16, 2001 at 7:00 pm
Matt,
Not aware of any server setting related to this - you might want to compare all the properties on the linked server on your test box to the one in...
July 16, 2001 at 6:58 pm
I havent had any problems with installing. Is it a clean install or upgrade? Your best bet is to just stop every service you can and unload apps until you...
July 16, 2001 at 6:54 pm
Take a look at this article, shows how to use the undocumented sp_msforeachdb - basically hides the work of opening a cursor and running through the list from sysdatabases.
July 16, 2001 at 6:51 pm
Well, you're back to encryption again. Depends on just how sensitive the data is, how much effort to put into it. Might be enough to do some very simple encrypting...
July 16, 2001 at 10:13 am
If you're going to require apps to access other DB's via a COM object only, I dont see any advantage to consolidating them just to get fkeys working. Having one...
July 15, 2001 at 1:35 pm
Leads me to think about what is the max # of columns you can use in a group by and have it be usable...I rarely group by on more then...
July 13, 2001 at 11:35 pm
Viewing 15 posts - 6,166 through 6,180 (of 6,215 total)