Recent content by Guggly

Check DB Integrity is part of my maintenance plan which runs nightly, but it returns no errors and the logs say it runs very quickly (around 15 seconds to go through all my DBs). I know that one of my DBs has errors, because when I run "DBCC CHECKDB WITH NO_INFOMSGS" on that database, it takes...

Thanks, that's helpful! Yes, I do plan on learning CSS and more about web programming in general.

I’m just learning basic HTML while working on a project, so forgive my ignorance. I have two text areas on a page, which need to be side to side, looking something like this: Text, here -------- Something else | | -------------- | | | | | | |...

I'm not exactly sure what all I will need to do, but for sure I will need to give the user the option to select which mail folder to use, then pull out and save any attachments in the emails, as well as log details (not sure of which, but probably all the basics: To, From, Subject, Body, Time...

Christiaan, how would I do that, what do I search for to get on the right path? I'm not looking to send mail from my app, but rather to actually access the contents of the Outlook PST and work with the mail in that way. Thanks for your reply! -- Mike

Hi! I'm working on a project which will require accessing mail in Outlook. The way to get around Outlook's security prompts which I'm most familiar with is by using Outlook Redemption. However, in researching a bit today, I found another option, which is "Advanced Security for Outlook" made by...

I think I've got it now. Thanks for your help, Alex

I got what I needed using the SQL Server Import and Export Wizard. Now the only thing I need to figure out is where the saved SSIS package is stored. I can't seem to locate it anywhere in SSMS. Any help?

Okay, but BCP doesn't include column names in the output, as far as I can tell. Is there any way to get around that? Thanks!

I want to export a resultset into CSV from MSSQL, is there something that can be used to do this simply? MySQL has the SELECT INTO OUTFILE functionality, but that is causing me errors when I try to run it in MSSQL. Thanks! -- Mike

I'm facing a weird error with Reporting Services (2005). The message given says to "See the report server log files for more information", after much searching on trying to get accurate error log info, I found this page: http://msdn2.microsoft.com/en-us/library/ms155836.aspx Problem is that I...

Yes you're right, I don't need to make object changes via Access, that's just the way I've been used to working up till now since I prefered the Access front-end for design work compared to Enterprise Manager or older versions of Visual Studio. The VS 2005/SQL Server Management Studio design...

Hi Catadmin. We use Access 2003. Thus far, the only issues we've encountered have been with design changes. Already existing views seem to work fine, as do forms and VBA code. Presumably Stored Procedures will execute fine as well, though I am yet to test this. According to this page, there are...

Seeing as Microsoft Access doesn't fully support SQL Server 2005 in ADP mode (you can't make any database design changes with Access). I'm looking for another front end to use. Management Studio works fine for designing queries and tables, but doesn't do good when it comes to displaying data, I...

Thanks macropod, that could be an interesting solution. I'm hoping not to have to write each of the RTF records to a file, since there are several thousand of these. I guess I'll see what my options are!