Search results for query: *

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

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

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

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

I can't seem to find out how to iterate through all the forms in a VB project. Why does this seem so difficult to do? I'm aware of the OpenForms property but I cant really open ALL the forms in my project just to iterate through them. I can even find out how to reference a form if i have the...

I'm bringing up our first SQL Server 2005 production server. Does anybody have any advice as to what to watch out for, what not to do, what to do, etc... I'm just nervous and want to make sure all my bases are covered... its 10 times harder to make changes once we release this server into...

I'm surprised that it's not easier to calculate or manipulate dates in VB .NET. For instance there is no easy way to get the first day of the previous month or the last day of next month for that matter. So what I did was create a class that houses these funky calculations so instead of...

I'm just curious how labor intensive it is to view PDFs in VB .NET, whether by purchasing a component or writing code. Thanks

Does anyone know of a way to browse through multiple PDF documents easily? I realize that when you open multiple documents it lists them in the Windows menu, but I was looking for something like navigation buttons. I'm open to third party viewers as well as just a tip in Adobe Reader. Thanks

We're upgrading to SQL Server 2005 and when the Network Administrator asked us if we wanted 64bit editions of windows and SQL Server 2005 versus the 32bit versions, and there was no price difference we said sure. However, I stumbled across an article that makes me wonder if that was a smart...

Lets say I have a text file full of names of stored procedures and I'd like to do a 'Find In Files' type search using this text file. How would I do this? Is there any software out there that would do this? Searching this way would save me from entering each stored procedure name one at a time...

How would I catch a specific exception? For instance I have a table with a compound primary key... the primary key is not an auto increment but I dont want to allow duplicates to be inserted. When I try to insert a duplicate it throws an exception, naturally. I am able to trap the SQLException...

I have two listviews and both of them are associated with the same contextmenu. When the user clicks the 'select all' menu item in the contextmenu the click event of the menu item calls me.activecontrol so I know which listview was clicked on. This worked fine until I put the listviews into the...