Search results for query: *

I finally found a solution and I wanted to share it with the tek-tips community. For viewing a PDF in VB.NET you can use the Adobe Acrobat Control for ActiveX. Hope this helps someone else! ;-)

When I logged into SQL Server 2005 using windows authentication to execute a stored procedure it worked fine. HOWEVER when I logged into SQL Server 2005 using SQL Server Authentication (the sa account) and executed the SAME stored procedure I got no results. I have no idea why that would make...

Notice the screen shot I included... does anybody know how to access the "Enforce Foreign Key Constraint" property from the INFORMATION_SCHEMA? I would like to be able to write a piece of T-SQL that will show me all the relationships where "Enforce Foreign Key Constraint" is set to "No". Thanks

Thanks! Just to clarify... you want me to put a SQL command in my DESTINATION rather than my SOURCE?

I want to use SSIS to import a table from access to SQL Server. The table already exists in SQL Server so it wont need to be created on the import. However, at this point I dont want to import the whole table over... how would I filter the source table so that I only import records based on a...

Does anybody know if there is a PDF viewer that has a filmstrip like functionality for viewing multiple documents?

I'm not sure how to categorize my question so please forgive me... does anybody know of a service that will provide you with a list of cities, states, and zip codes for the whole united states and you only pay them like a yearly fee or something... I'm asking because i'm not sure how to google...

After I cut and paste a source component, a data conversion and a destination component... the data conversion component gives me an error. "The package contains two objects with the duplicate name of output column "xxx(123)". for the life of me I can't find out how to fix this so I end up...

By Jove I think I've got it. You were half right MDXer, I had other columns that didnt allow nulls AND i had the keep identity box checked. once i unchecked that and addressed the other columns the problem went away. THANKS AGAIN! STAR!

Thank you Paul for your advice. However the problem is that the column is an Identity column, so i don't want a default value. I just assumed that when a new record gets added that it would just keep incrementing itself. Should I just create an identical identity field in the source table and...

I dont understand why my data flow has nulls. The column in my destination table doesnt exist in my source table. I would think that the data flow would just ignore the field in the destination table.

I'm creating an SSIS package in the BID and I keep getting this error: [Destination 9 - STILabels [1060]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been...

Here is a screen shot of my data flow task... How do I set the order of execution for each of these? Let's say I wanted the group labeled Source 2 to go first and then the group labeled Source 1 to go second, etc?

I was just wondering if anyone has come across this annoying behavior in VS 2005 code editor window. It happens to me when switching between the code editor and designer and back. Say I switch to code view and begin typing. The editor will replace every other character with a ( or a ). When I...

So you're saying that shrinking the log is not something that I need to do all the time if i am backing up the logs regularly? But as far a me finding an item in the toolbox in the maintenance plan designer i'm not going to find one... is that correct? Thanks for your help to this point... my...

i can't find the truncate log option in the maintenance plan wizard or designer... once I backup the transaction log how do I truncate it?

Does anybody have any advice/links for information on how to setup a maintenance plan for database(s) in SQL Server 2005? Specifically, in the maintenance plan wizard.. Do I need to run the task labeled 'Check database integrity'? If and when do I need to run the shrink database task? etc...

I'm not sure what you mean. What is dmv? And how am I supposed to use sys.sql-dependencies to solve my problem? Sorry, would you mind spelling it out for me a little bit more. :-)

I'm trying to delete a table in sql server and it tells me that there are stored procedures and views that depend on this table and therefore i cannot delete it. I've looked into a few of these stored procedures and its not using the table. So why does it keep telling me there is a dependency...

Thanks chrissie1. I FINALLY was able to iterate through all the forms... WHY IS THAT SO DIFFICULT? ;-) Everything is an object you would think there would be a collection somewhere that would allow for an easy for each loop. WHEW!