Viewing 15 posts - 37,411 through 37,425 (of 39,456 total)
Haven't tested, but I assume you could use Deleted and reset the value(s) you want. Not sure I'd recommend this. Why?
Steve Jones
June 3, 2002 at 4:49 pm
Painful. usually in this case, you will need another outage window to do a backup/restore to the primary site.
Steve Jones
June 3, 2002 at 8:52 am
Speaking for myself, keep the money and keep coming back. Also tell your friends.
Steve Jones
June 2, 2002 at 2:59 pm
check out my article on Charindex. I'm sure that will help you. Search for the ascii of the carriage return.
Steve Jones
June 2, 2002 at 1:34 pm
SQL Server can make it's own backups to disk, which any tape system can back up. This is the recommended method.
I'd avoid using 3rd party backup.
Steve Jones
June 2, 2002 at 1:17 pm
Find a way to justify the 20k machine. Better to be over the top than under.
15GB isn't that big, BTW.
Steve Jones
May 31, 2002 at 6:19 pm
In SQL 2000, there is an execute package task that does this.
In SQL 7, you can do it with ActiveX
Steve Jones
May 31, 2002 at 6:17 pm
May 31, 2002 at 6:12 pm
I would look to put the common information (name, auth code, etc.) in the main table. For other info, you have three choices.
1. Use a single table and a "type"...
May 31, 2002 at 6:08 pm
If you do it in EM, it will generate a script for you. You have to drop the table and rebuild, but you can rename the table as a temp...
May 31, 2002 at 9:17 am
Not that I know of. We have started something here (in alpha) that will allow people to post models and others to comment on them. We hope to build up...
May 31, 2002 at 9:15 am
DTS will not export an XML query. You can use isqlw and pipe to a file or query with ADO (ActiveX Task) and then save as XML if you are...
May 31, 2002 at 9:12 am
Interesting choice of words. Hopefully EM doesn't have any habits it can learn or unlearn. 🙂
I would suspect this is a bug, however it should work based on the precendence...
May 31, 2002 at 9:09 am
Sounds like an unreliable network connection. Can you make a larger file transfer (>1MB) and see what happens?
Steve Jones
May 31, 2002 at 8:52 am
I can't see the attachment, but I thought the red line was "disconnected".
Can you run sp_who2 with this login?
Steve Jones
May 30, 2002 at 10:12 am
Viewing 15 posts - 37,411 through 37,425 (of 39,456 total)