Hi jking

The first thing that comes to my mind is that you must commit the changes in your stored procedure before you can select from the data you have updated....

Hi,

We have had similar requests from our developers. We worked on creating where clauses using the case statement in the where clause based on a parameter code passed into...

Hi Emma,

We have a mixture here of power users that use an mdb with linked tables. It works well for them and in some cases, as the repetitive tasks...

Just tried the proc and table on a server here. It worked great and was quick. SChase, you might post that in the scripts section of this community....

Is it possible you have Embarcadero tools on your system? One of the option settings references SQL.LOG.

I ran into it recently in a dts scenario. I was attempting to use a sql2000 function against a sql 7 database. Once I checked the sql7 box...

We actually had an optimization project for an application here that dealt with a similar situation. We maintain most of our 'code' tables in a separate database. The...

As far as sql starting up, I would change the services to run as local service before the domain is changed. Once the domain is changed, reset the sql...

Hello,

Depending on the version of Access you are using, you walk through Create New - select Project (Existing Database). This type of connection will present a close facsimile of...

You are most welcome, Pat and an Amen to that too!

Jody

On each sql server I run the Server Network Utility to establish the listening port and IP of the Server. On the opposing sql server I run the Client...

I am not sure of all the background for IP designations, but within our organization we have an intranet and and internet with a firewall in between. I have...

I would revise the sql like :

DECLARE FF_LU_WTN_STAGE_LU_ADDRESS_DIFF_CURSOR CURSOR LOCAL FAST_FORWARD

FOR

SELECT

wire_cntr_name,

living_unit_id,

wtn,

id

FROM

...

If you will create the index by adding in all the columns used in this query you will get some performance by using only the index versus then also having...

A discovery I have made about the service account's permissions is that as long as the folder/share is beneath the sql server tree all is well. When I place...