Recent content by JulesDBQ

Did you ever figure out how to acomplish this with SQL Server 2007? I am trying to do the same thing....determine the password expiration dates for my SQL based passwords. Any assistance would be much appreciate! Thanks!

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

Thanks to all for the quick response! I really appreciate your help. I had success!!

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

Thanks to everyone....I will check to see if DTS is running on both of the servers involved. [smile]

This may sound like a stupid question....but... How do I know if DTC is running? What if it is running on my server, but not on the remote server that I am linking to? Thanks!

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

Thank you for the replies. I was finally able to successfully link to the external SQL Server. [smile] I can run queries on the data, but am unable to save the SQL code for views, stored procedures, etc. I am getting the "OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction"...

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

Thank you so much!! That did exactly what I wanted. [smile]

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 should have thought of that. [smile] Thanks for the hint. Now for the details of what I need to do to resize the column widths of the grid. Where in the code is that referenced? Do you have any sample snipets of code that would give me a good start. Thanks again.