Viewing 15 posts - 2,356 through 2,370 (of 2,464 total)
It is quite easy to save a database diagram as a .pdf document.
This is done by printing the document to a virtual printer that outputs the results as a...
October 11, 2004 at 6:31 am
It sounds like what you want to do is to have a template of security permissions that will be automatically applied to an object when it is created.
This is...
October 4, 2004 at 4:27 am
Lots of things are not supported or stop working when running in Fiber mode. A KB search for "Fiber mode" shows some of the issues.
My suggestion is to turn off Fiber mode...
September 30, 2004 at 6:09 am
What justification do the Network people have for needing SA rights?
If they act as a backup to the DBAs, then SA might be justified. In our shop, there are enough...
September 27, 2004 at 2:32 am
C2 audit mode is based in the C2 definition in the US DOD 5200.28 standard. This standard is now obsolete and has been replaced be a security evaluation system called...
September 24, 2004 at 3:11 am
My experience is that there are 2 most likely possibilities:
1) The W2003 DB server is very badly tuned and is running slowly. This is unlikely, unless your site has done...
September 23, 2004 at 6:17 am
If you use SQLBackTrack backup/recovery software from BMC, this can be done. With standard SQL Server backup/recovery the answer is no.
September 22, 2004 at 4:42 am
Apart from anything else, your clause '@LearnID IN (puTOP_SECTIONID)' is the wrong way round. The IN clause works like 'needle IN haystack'. Try rewriting it as 'puTOP_SECTIONID IN...
September 22, 2004 at 4:37 am
To get PSS support, phone your local Microsoft office. If that is not the right number they will give it to you. When you get to PSS, you will either...
September 16, 2004 at 7:03 am
If you use W2003, you do not have any choice about using MDAC 2.8 - it is the version shipped with W2003.
September 16, 2004 at 3:11 am
I would echo Chris's advice. You should contact PSS regardless of anything else you do.
It may also be worth looking at your autogrow parameters. Try to work out the likely...
September 16, 2004 at 3:06 am
As with all debugging, the most likely thing is that the error message is telling you the truth. The most likely cause is that one of the file paths used...
September 10, 2004 at 3:11 am
As some people have already said, you need to do transaction log backups to save your log information. Do not use the truncate_only option unless you really want to loose...
September 10, 2004 at 2:58 am
Our standard is to use NT authentication everywhere we can. This is mainly because NT auth gives improved security over SQL auth.
All but 1 of our production instances only...
September 10, 2004 at 2:48 am
If you did not have a logging mechanism, you would not have a rollback mechanism.
If your logging mechanism was limited to the memory on your box, you would be limited...
September 10, 2004 at 2:23 am
Viewing 15 posts - 2,356 through 2,370 (of 2,464 total)