help with log file
Got a database in SQL2005 that is basically a download of a daily flat text
files and creating tables from them.
The log.ldf file is frikkin huge. It's over 146GB and I don't need this, I
have storage issues. How do I shorten down this file and keep it small
Have you read about managing the transaction log in the Books Online?
How big is your database?
What recovery model are you in?
What kinds of backups are you doing, and how frequently?
If you are not in SIMPLE recovery, and you don't back up your log, it will
continue to grow. Even...Need help in accessing a sharepoint site that I created with the AllTemplates.exe
SBS2008 with WSS 3.0
I downloaded the AllTemplates.exe from Microsoft and installed the Helpdesk
I can acess the Helpdesk site from SBS2008 and add things to it but I can't
access it from a workstation.
Can anyone help me out?
You mean you can only access the site from the Server in local , right?
maybe we need more information such as error message.
how about doing "ping" or "tracert" result.
can you access a normal web site (not sharepoint site) from the workstation ?
do you get an authentication window ?
"john doe" wr...Folders disappearing after compacting file cabinet
Twice, now, I've lost a good chunk of e-mail I've saved in different folders
because I've compacted my file cabinet. Anything with a file folder named
with E or beyond gets dumped. A through D only remains. Any ideas as to
what's going on? Thanks!
Did you compact or run ScanPST.EXE? I've never heard of a compact deleting
valid data unless, of course, the file was damaged before running the
compact. I hate to ask but do you have a backup of your PST from before this
"Karen C." <kcunningham @ iglou.com> wrote in message
news:...Outlook Express message links all dead!
Incoming mail contains blue underlined links. Pointing
to them produces the "hand" icon, but clicking does
absolutely nothing. Is there a setting I'm missing that
prevents activating links? Something else?
The article is about an error message and outlook, but maybe it could solve
your problem, too!
Gestern gings noch, ICH habe nichts gemacht! ;-)
"GregS" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Incoming mail contains blue underlined links. ...MS Excel file extension changed through e-mail
MS Excel .xlsx files sent as attachments are received without the x,
as a .xls instead. The same is true for MS Word .docx changed to .doc
Answered in the Word group. Please don't post the same question in multiple
groups. It not only causes responders to waste their time replying to
questions that have already been answered but it also makes it more
difficult for you to follow up on the replies. If it truly is an issue that
involves more than one app either post to the Office group rather than the
individual groups or use a newsreader rather than the web interface & learn
to ...Removing Links #4
I am trying to copy several worksheets from a workbooks to a new workbook
and have all links with the old severed.
I have changed all the formulas to values.
I have deleted every workbook and worksheet name.
Still when I look at Edit | Links some link to the original workbook is
present. Has anyone any ideas what this might be, and more importantly how
do I get rid of it?
Maybe this old post from Frank Kabel
try the following add-in to find/delete these links:
>I am t...Dump file corrupt
THIS DUMP FILE IS PARTIALLY CORRUPT.
KdDebuggerDataBlock is not present or unreadable.
Unable to read PsLoadedModuleList
THIS DUMP FILE IS PARTIALLY CORRUPT.
KdDebuggerDataBlock is not present or unreadable.
KdDebuggerData.KernBase < SystemRangeStart
Kernel Version 2600 ...Network File lock not detected
We have a workbook that about a dozen people get in and
out of all day. I have a problem with one user's excel
not always locking the file, or it could be a problem with
other users not detecting the file is in use and
displaying the in use message, do you want to open a read
only or wait. Is there anything I can do in execel to fix
that or is it a network issue. Running XP pro, office xp
pro, and 2k server.
From my experience, it is a network issue. They need to unlock the file because Excel cannot.
Fixed it, Windows didn't have sp1 on it. For some reason it fixed the
pr...How to update contacts in WLM via csv file?
I have nearly 2,000 email addresses in my contacts list. I managed to get
WLM to list them, although I do notice some are missing. Now, I want to
update them with new/revised contacts through a new cvs file, which I
exported from OE. However, the contacts import program just hangs and
Do I need to delete the existing list first? If so, how do I do that?
I am using WLM v.2009 Build 14.0.8 on Windows 7
Are you logging in to Live services? It will say your profile name under
the close X.
"Bumper21248" wrote in message
news...pst file might be corrupted
Hi all. I am not able to view my pst file at all via my outlook 2000. I tried
to recover it via scanpst but scanpst stopped halfway through the process and
said that an error occured without specifying which error. Is there any other
way to recover this pst file? Thks in advance.
How big is the PST file?
"inenewbl" <email@example.com> wrote in message
> Hi all. I am not able to view my pst file at all via my outlook 2000. I
> to recover it via scanpst but scanpst stopped halfway ...Users and Asset Data linked on Form
I have two tables, one a Staff list and the other an Asset list
extracted from seperate databases, the information in the tables has
absolutely no common data, I have a form with the user name and other
bits and pieces on from the staff list and also a drop down list of
all asset numbers which I can then select the appropiate asset number
from then, that asset number and other details I would like to be
associated to that user.
I have tried, I have done this in the past about 4 years ago but I
cannot remember any of it!
Any help would most appreciated
T...VBA to call file based on date
I wonder if anyone can help me with a VBA routine to check for the presence
of a specific file.
The file is saved on a dialy basis in the format "userfile_run_YYYYMMDD.xls"
i am seeking help with a vb code that will check if today or any specified
days report is generated. i guess excel can use the date format to read the
specified location for the file.
Thank you in advance for your help.
.....Coming from Where I'm from.
Dim sFile As String
sFile = Dir("C:myPath\userfile_run_" & Format(Date,"yyyymmdd") & ".xls")
If s..."The image file ___ is valid but ...."
"The image file ________ is valid but is for a machine type other than the
What does this message dialog mean on Win XP x64?
It means that the program you're trying to run is 16-bit. There is NO 16-bit
support in any 64-bit version of Windows. You'll need to run the application
in a virtual machine running some earlier version of Windows.
<firstname.lastname@example.org> wrote in message
> "The image file ________ is valid but is...Discount using two different items?
Hello, I have two different items one sellf for $11.99 and the other for
$3.99 is there any way to set it up so that if a customer buys the item for
$11.99 that they can get the $3.99 item for $2.99
Did you try to setup Mix and Match discount?
> Hello, I have two different items one sellf for $11.99 and the other for
> $3.99 is there any way to set it up so that if a customer buys the item for
> $11.99 that they can get the $3.99 item for $2.99
> Thank You,;
...MS Access and SharePoint
Is MS SharePoint a substitute for creating rational databases MS Access.
Absolutely not. I assume "rational" means "relational". In fact, there is
not much "relational" about SharePoint anyway, please refer to http://www.lcbridge.nl/vision/2008/transactions.htm
for more info about that. However, Access 2007 allows you, under restrictions,
to publish databases to SharePoint 2007, and SharePoint 2010 includes Access
Services, which allows you to create web applications in Access 2010 and
publish them to a SharePoint 2010 site.
Kind reg...print mass Powerpoint certificates from Excel file
I get Excel lists of students that require training certificates. I have a
PowerPoint certificate. Is it possible to do something simular to a mail
In article <BFBA41AC-26D1-4B30-8C54-425C2E8A50F0@microsoft.com>, Go to Girl
> I get Excel lists of students that require training certificates. I have a
> PowerPoint certificate. Is it possible to do something simular to a mail
Not out of the box, but we have a commercial PowerPoint add-in that does
exactly this. You can try out a fully functional demo to see if it meets your
needs. Mo...Can Import Email Data Filed from Office XP to Office 2003
My HD failed but I had a backup of my Office XP Pro personal file folder
with a lot of emails I needed. The file is about 128MB in size. I put a new
HD in and installed Office 2003 Pro. When I go to open the old file Outlook
2003 says that the file "is not a personal folders file". (It was backed up
to a CD ROM prior to the crash so the source file should be good.) I really
don't want to uninstall Office 2003 and put back Office XP. Any idea why
2003 won't open the file and how to work around that? Many thanks in advance
to anyone who knows the solution. Alan.
The only pro...sharepoint kerberos authentication
I got little knowledge in Kerberos authentication could Please answer below
questions would be very helpful for me...
1. WHAT ARE THE SPN'S REQUIRED ON THE DOMAIN FOR THE FOLLOWING SHAREPOINT
2. BRIEFLY DESCRIBE THE PROCESS OF ENABLING KERBEROS AND APPLYING THESE SPN'S
3. HOW WOULD YOU TEST TO ENSURE ALL THE ABOVE SERVICES ARE WORKING
Please find answers to your questions inline.
...How to open saved .DBX files?
I saved a folder of e-mails to CD from Outlook Express
shortly before my last computer died. I desperately need
to open the folder (saved as a .dbx file) by tomorrow, to
get my husband (in Portugal watching the footie) the
details of his hotel!!I am now running Xp and have both
outlook and outlook express(office 2003)
I tried open with, but selecting OE takes you into the OE
files rather than selecting it as a prog.If I try open
with outlook, it just appears as a folder attachment in
Can anybody help me open this wretched thing???
Ask in an Outlook Express forum. This is an...Size mismatch between stm/edb files and mailboxes
I am puzzled!
Am running out of diskspace on our exchange drive and badly need to
reduce the size of the exchange database.
The total size of the priv1.edb and stm files is approx 6Gb.
If I add up the total size of all the mailboxes as shown in ESM it comes
to approx 1.5 Gb.
Running eseutil /ms and calculating the free space for both files gives
me approx 1.2Gb, which is what I believe I will regain by defragging the
So where is my remaining 3.3Gb gone!!!!
The online maintanence is completing fine each night.
Deleted item retention is set to 0, and we haven't deleted any ...Sync Money Files
I have a laptop and desktop, both running Money 07.
I have been away from home for three months and have been keeping my
expenses in Money on my laptop. My wife has been keeping our records on the
desktop. My problem is how to combine the two files so that I have one set
of money files. When I cease travelling, the notebook will not be used for
Money work; but the desktop will. So I need to combine the two files.
Are there any solutions?
There is no easy way to do this. There aren't even many hard ones. Have you
already done this or are you only pondering a re..."Get-ClusterResource" cmdlet throws "not recognized as a cmdlet, function, operable program, or script file" error.
Hi, I am trying to use "Get-ClusterResource" cmdlet to fetch "File
Share Witness" property of CCR cluster. But when I run this command no
"Exchange Management Shell" I am getting "The term 'Get-
ClusterResource' is not recognized as a cmdlet, function, operable
program, or script file. Verify the term and try again." error.
Any idea why I am getting this error? Do I need to add any "PSSnapin"
via Add-PSSnapin cmdlet ? If so which one it is? Basically I am not
able to run any of the cluster related GET cmdlets on Exchange
Managem...Default Workgroup Information File
What's the difference between the two following choices using Security Wizard?
"I want to make this my default workgroup information file."
"I want to create a shortcut to open my security-enhanced database."
Does one of these apply this security to all databases? I noticed that it
applies the security to my backup database that I keep on my desktop. The
security is originally applied to a database that I keep in a shared network
> What's the difference between the two following choices using Secu...How to tell if folder item is file or folder?
Hi all. Now I am processing data in folders. I get a listing of folder
contents and have to test to determine whether item is folder or
file. I have this routine:
strPath is previously set with valid data, strType is previously defined.
Dim objDI As New System.IO.DirectoryInfo(strPath)
For Each objFSI As System.IO.FileSystemInfo In
If objFSI.Attributes() And IO.FileAttributes.Directory Then
strType = "Folder"
strType = "File"
My question is whether this is the...Data vanished, Large file seems empty
I opened Outlook this AM and it was as if I had never used
it. My created folders were gone, only the default folders
were there and they all were empty. I tried to open the
proper .pst file and found one with 91,360kb, but whether
I try to open it through Outlook/File/Open or simply
double-click the file from Windows Explorer I get the same
results: ghost-town Outlook, empty folders, etc., like I'd
never been there before.
Try running the Inbox Repair Tool against your .PST file to see if it finds
any errors. Search your drive for a file called scanpst.exe and run it.