Viewing 15 posts - 37,501 through 37,515 (of 39,717 total)
June 27, 2002 at 10:48 am
Or if you want a single output file, check out my Version Control Series.
http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp
Steve Jones
June 27, 2002 at 10:43 am
Can you use multiple packages? One that determines what to do and calls another? Or multiple steps in a job?
Steve Jones
June 27, 2002 at 10:42 am
Restore from backup or recreate. The DTS pacakges are somewhat fragile and when they break, they be BROKEN!
A good reason to keep a .dts backup of your packages.
Steve Jones
June 27, 2002 at 10:40 am
The suggestion above does a script. If you need more of a document, then ErWin (from ca), ER/Studio (Embarkadero) and others will reverse engineer and develop some documentation. Total SQL...
June 27, 2002 at 10:37 am
June 27, 2002 at 10:35 am
sp_helpdb has some of these.
I'm guessing these are properties of the database, maybe an extended properties seting.
Is this SQL 7 or 2000?
Steve Jones
June 27, 2002 at 10:33 am
1. Setup a role first. Then give a user for this role to the developer, it should be an easy item they enter once and reference. You should be able...
June 27, 2002 at 10:28 am
Checkpoints are used to mark items in the log that are flushed out. It will consume some CPU and IO, but most of the time it will sleep. It's a...
June 27, 2002 at 10:22 am
The plan has the "all databases" checked or another option?
If it's doing this, I would recreate the plan. It's simple and would likely solve the issue.
Steve Jones
June 27, 2002 at 10:20 am
sp_configure gives server settings
sp_helpdb gives a bunch of db specifics. What are you looking for that is not covered?
Steve Jones
June 27, 2002 at 10:18 am
I think it's a question of scale. If business rules dictate a small number that is unlikely to substantially grow, I like having storage in a few columns. However, if...
June 27, 2002 at 10:16 am
Profile tested using Outlook. Works fine interactively (when logged in using the MSSQLServer service account). Sends mail without an issue.
Both MAPI32.DLLs are beyond the versions given in the Q article,...
June 27, 2002 at 10:12 am
Hey, one more note. I just started with a new company and we use an Optika solution for something. We have an older version scheduled for upgrade this year, but...
June 26, 2002 at 5:00 pm
You are welcome.
I have used the FileNet products, but it's been 5 years. They worked well. Not so great for versions, but great for images.
Steve Jones
June 26, 2002 at 4:54 pm
Viewing 15 posts - 37,501 through 37,515 (of 39,717 total)