Need to find out the amount of free space in your transaction log file on Microsoft SQL Server? Run the following command:
DBCC SQLPERF ( LOGSPACE )
It will tell you the percentage of transaction log space used, and the size of the transaction log file, which you then use to calculate the amount of free space in the transaction log or the amount of space in use.
The Result of the
DBCC SQLPERF (LOGSPACE) query is the following columns
Database Name, Log Size (MB), Log Space Used, Status. If there is a lot of FREE space in the transaction log, and you the file is too big you can shrink the size of the transaction log by running:
DBCC SHRINKFILE ( DBFILENAME_Log )
If you are getting the following error message in Microsoft SQL Server when you try to run
DBCC SHRINKFILE (DBNAME_Log):
Cannot shrink log file 2 (DBNAME_Log) because all logical log files are in use.
Make sure that there are no running transactions, by running the command on the database in question:
It is possible to shrink the transaction log file while the SQL Server database is online, however if transactions are taking place while the operation is running you may experience this error.
Try running it in off hours the
DBCC SHRINKFILE command in off hours, or shut down access to the database from other apps.
AIS - Security company located in rome ny on griffis air force base.
I just setup my new mac pro, but was unable to connect to AOL Instant Messenger via Apple iChat. I kept getting this error message:
ichat lost connection with aim
I had no other internet connectivity problems...
The solution is to go into the iChat Preferences, click on Accounts, and then select your AIM account. Click Server Settings and change the port to 443.
That did the trick for me, AOL AIM is working great now.
Here's a list of the New Functions in ColdFusion 8 (89 in Total)
AjaxLink AjaxOnLoad ArrayIsDefined DeserializeJSON DotNetToCFType FileClose FileCopy FileDelete FileIsEOF FileMove FileOpen FileRead FileReadBinary FileReadLine FileSetAccessMode FileSetAttribute FileSetLastModified FileWrite GetComponentMetaData GetFileInfo GetPrinterInfo GetReadableImageFormats GetUserRoles GetWriteableImageFormats ImageAddBorder ImageBlur ImageClearRect ImageCopy ImageCrop ImageDrawArc ImageDrawBeveledRect ImageDrawCubicCurve ImageDrawPoint ImageDrawLine ImageDrawLines ImageDrawOval ImageDrawQuadraticCurve ImageDrawRect ImageDrawRoundRect ImageDrawText ImageFlip ImageGetBlob ImageGetBufferedImage ImageGetEXIFMetadata ImageGetExifTag ImageGetHeight ImageGetIPTCMetadata ImageGetIPTCTag ImageGetWidth ImageGrayscale ImageInfo ImageNegative ImageNew ImageOverlay ImagePaste ImageRead ImageReadBase64 ImageResize ImageRotate ImageRotateDrawingAxis ImageScaleToFit ImageSetAntialiasing ImageSetBackgroundColor ImageSetDrawingColor ImageSetDrawingStroke ImageSetDrawingTransparency ImageSharpen ImageShear ImageShearDrawingAxis ImageTranslate ImageTranslateDrawingAxis ImageWrite ImageWriteBase64 ImageXORDrawingMode IsDDX IsImage IsImageFile IsInstanceOf IsJSON IsPDFFile IsPDFObject IsUserInAnyRole QueryConvertForGrid PrecisionEvaluate ReMatch ReMatchNoCase SerializeJSON Sleep VerifyClient
Here's a list of the New Tags in ColdFusion 8
cfajaximport cfajaxproxy cfdbinfo cfdiv cfexchangecalendar cfexchangeconnection cfexchangecontact cfexchangefilter cfexchangemail cfexchangetask cffeed cfimage cfinterface cflayout cflayoutarea cfmenu cfmenuitem cfpdf cfpdfform cfpdfformparam cfpdfparam cfpdfsubform cfpod cfpresentation cfpresentationslide cfpresenter cfprint cfsprydataset cfthread cftooltip cfwindow cfzip cfzipparam
Here's a list of easy Adobe Photoshop Tutorials for Beginners:
Some tutorials on color theory, you might find this interesting, and you might be able to apply the terms they use to things you see in photoshop, especially in the color picker...
Some websites you can use to find more photoshop tutorials: