Search results for query: *

Hi, I am having an issue trying to get an SSIS package to run as a job in sql 2005..... All the package does is import a flat file into an existing table. Manually executing the SSIS package works every time, but running the package as a job causes a failure each time. Does anyone have any...

I have a table that contains at least 4 fields that are based on a source field in another table. So, for example....Table A has fields 1,2,3,4 which are each integers based on a field in Table B. (In this case, it is staff names). Does anyone know of an uncomplicated way to query this data? In...

Hello, I included this error on an existing thread of mine regarding linked servers. Since the linking of the servers has been resolved, I was unsure if anyone took a peek at my second question? Now that I have successfully linked the remote server to my SQL server, I can run queries to view...

Can you successfully use linked servers when you are the dbo on "Server #1" and just a reader/user on "Server #2"? I need to run updates on "Server #1" based on data that is housed on "Server #2". So all I need to do is read the data from the second server. If this is possible, how do I go...

What type of quotes should I used around my where clause? I am getting an invalid column name when I use single quotes - I know it is because of hte quotes around the select statment...but I am not sure what to do. Please advise...Thanks. SELECT a.* FROM...

I would like to create stored procedures that produce results based on data contained on two completely separate SQL Servers. I am administrator of the first server, so I have full rights to it...but, I am only a reader of the data on the second server - so I have no control of it. I need to...

I would like to execute an update stored procedure directly from my vb.net application. I am not providing any input parameters or returning a value. All I need it to do is run from the app. I have looked through a bunch of the existing threads, but haven't been able to figure out what code I...

I would like to create a formula that selects any text that displays to the left of a static symbol within a string. For example: manpc01|%fakjfisufasdfsdf787fs87f In this case, I would just want to select manpc01. So, I would want to select any text left of the |% symbols. I then want to take...

I created a data grid using the GUI within VB .NET. I would like to manipulate the column widths for some of the columns in this data grid and make them wider. Will I be able to do this since I created it with the GUI and not with code? Any assistance would be appreciated. Thanks.

I am writing an update trigger that will update a value in database #2 whenever a certain column in database #1 is updated. The trigger is firing correctly and does update the field that it is supposed to. The problem is that I don't know how to join the Inserted table from database #1 into this...

Hi. I am new to Triggers and SQL, so any assistance you can offer would be much appreciated. [ponytails2] I need to write a simple trigger that fires whenever the ID field in my table is updated. This trigger would update another table that contains the same information in it, so... If...