Search results for query: *

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...

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 | | -------------- | | | | | | |...

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 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...

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...

Hi! I'm not sure which is the best forum to post this kind of question, so if you have any suggestions as to a different forum, do tell :). I have a table which contains several thousand individual blocks of RTF text (some of which contain graphics, and if you've ever attempted to store a...

Hi! I'm not sure which is the best forum to post this kind of question, so if you have any suggestions as to a different forum, do tell :). I have a table which contains several thousand individual blocks of RTF text (some of which contain graphics, and if you've ever attempted to store a...

Hi! I'm not sure which is the best forum to post this kind of question, so if you have any suggestions as to a different forum, do tell :). I have a table which contains several thousand individual blocks of RTF text (some of which contain graphics, and if you've ever attempted to store a...

Hi All! Any thoughts on what's better to use, an In-Line Function or a View? I have an SP that processes data from this to generate another set of data, but not sure which one is more suited for this, if there is a difference. Thanks! -- Mike

This is probably a real dumb question, but I can't seem to figure out how to actually write data to an Access database I'm using. I can read the data fine using the following code, where QuerySQL is an SQL Select Statement. If objConn.State.Equals(ConnectionState.Closed) Then OpenDatabase()...

I'm not sure if I'm explaining this question correctly, but basically I'm working on a database project in VB .Net and using a Microsoft Access backend for the database (might eventually upgrade it to SQL Server, not sure). How can I query the contents of a query (which is returned in form of a...

Hi! I'm not sure if this is the right forum to ask a question regarding Reporting Services. If not, please redirect me. I have a dataset that I'm basing a report on, which contains numeric data. In another dataset there are text descriptions for these values (i.e. 1=apple, 2=orange, etc.) Is...

Hi All! I'm looking for something to use internally on a work network for mail. I know that there are LOTS of POP3 or IMAP options available, but for various reasons I'm hoping not to have to go that route. What I'm looking for is something that offers the same functionality that Microsoft Mail...

For some reason MS Word doesn't seem to support merging data from Access if the Access field type is binary. Anyone know of a workaround? Access doesn't give binary as a field type when you create a table, but if you run a Make-Table query with one of the values containing Null, the data type...

Hi! Can someone tell me if there's any way to create a symbolic link on a table between two databases? I can do this with MySQL and Microsoft Access, but the only way I've figured out to do it with SQL Server is via a SELECT statement. Is there some other way to do it, so that it acts like a...

Hi! I have a few SELECT StoredProcedures, but it seems I can't use the values they return from another SP. When I refer to it in code I get an "Invalid object name" error. Can I only access a View to be run by another StoredProcedure, or am I doing something wrong? Sorry if this is a real basic...

Hi! How can I link a table from one SQL Server database into another? I know that I can get a read-only view doing something like this: SELECT * FROM OTHERDATABASE.dbo.TABLE But, I'm hoping for something that shows up as a table and with write access. Is there any way to do this...

Hi! I'm new to SQL Server, though I've been using Microsoft Access for years. I'm trying to update a table based on the value of another table. In Access I can create a join between the two tables and update the value but without a problem, but this doesn't seem to work with SQL Server. When...

Hi! I'm hoping this is some dumb newbie question, but I can't seem to find the old VB equivalent of the Immediate Window in VB .Net. I am aware that the "Command Window - Immediate" can be used for variable watching and the likes, while code is running, but it seems to be missing a bunch of the...