Viewing 15 posts - 2,536 through 2,550 (of 6,216 total)
I typically do the optimizations after a backup. Better to have a backup and have to reindex than have something go really wrong during reindex and have no backup. I...
February 17, 2003 at 9:02 am
I know its too late, but another idea would be to buy one of those cheap 200g IDE drives, plug into server A and copy, then pull and out put...
February 17, 2003 at 8:59 am
According to BOL, you cannot. Don't see why you couldn't just do the insert into the tables manually and use a transaction there. Why do you care?
Andy
February 17, 2003 at 8:58 am
I do not - yet! Attending some training next week, hope to get some good information. As I understand the process, you'd end up with a complete point in time...
February 17, 2003 at 8:56 am
Probably faster to zip it first, mdf or bak, both usually compress pretty well.
Andy
February 17, 2003 at 5:57 am
Closest I can think of is sp_addalias, though even that adds a row to sysusers in the db.
Andy
February 17, 2003 at 5:53 am
Depending on what you're trying to achieve, changing the nulls to zeros may impact the result in a way you dont want. The other part is - why can't you...
February 14, 2003 at 7:14 pm
Anything else in either system or application log? You might look in the SQL log folder, see what is in the error log. Probably next step if nothing found there...
February 14, 2003 at 4:43 pm
I looked through the newsgroups, didnt find much. One suggest was to reinstall MDAC, the other to copy the install files to a local folder and install from there. Tried...
February 14, 2003 at 1:00 pm
I've got a similar situation, both in terms of databases=clients and a need for better change control, plus a way to control deployment. I've looked at Steve's system and I...
February 14, 2003 at 7:58 am
If you're using ADO you could declare your connection withevents - then you can monitor for the connectionbroken event. Probably just as good is to assume the connection is good,...
February 14, 2003 at 7:52 am
Dont think I have any at the moment. Recursive solutions not that common. Concerns that there might be a problem, or you really are having a problem?
Andy
February 14, 2003 at 7:49 am
Maybe permissions or a change to sp_idedebug, or whatever it is?
Andy
February 13, 2003 at 5:35 pm
Hey, thats the "reason" we used in the first place, its built in! Well, that and the price was right. We might end up keeping both, if nothing else so...
February 13, 2003 at 5:34 pm
Good write up! I think I'd add that you want to make sure you save the changed script out someplace since a service pack "might" overwrite your change - and...
February 13, 2003 at 5:33 pm
Viewing 15 posts - 2,536 through 2,550 (of 6,216 total)