I would wonder if it was adding a column or changing the Not Null to allow nulls that caused the issue?

For some reason I cannot see the image you have embedded. Could you try attaching it?

Are the 4 inputs all columns in a table or are will they be...

I usually say Sequel, fewer syllables, thus more effiient and we all know performance is important:P

If you are using a sub query you want to use IN like this:

Update TableA

Set ColumnA = 'Test'

Where

ColumnB In (Select...

Glad to help.

I have SP2 installed and did not have any issue creating a job in SSMS. Have you tried creating a job using the job creation SP's directly?

Are you having...

That has been my typical approach as well Grant. I am looking for the hard core performance guru's approach as well.

This question assumes that the update is being done...

Make sure you lookup SQL Injection before releasing any web page that allows this.

Do you want to provide "drag and drop" type functionality to select tables and fields or just...

YOu executing the insert on the remote server not the local server so there is not an identity value being created in the scope of the local server. If...

You need to create Linked Servers between the Servers. Then you they can reference each other.

For instance on ServerA you create a Linked Server to ServerB. On ServerA...

I don't know of any off the shelf components that would do this as I have never given users that kind of permission.

The first thing I would do...

Anthony K. Valley (4/4/2008)

---

Hmmm.... I assumed the question was specifically about pages, extents, and allocations in SQL Server. I had no idea that it was about general computer storage....

I have to agree with Gail. If there are indexes that will help regularly run queries it is a "best" practice to add them.

I'm not sure if this is designed behavior, but this section:

IF @LOCKSTATUS=0

BEGIN

SELECT

@LOCKSTATUS=COUNT(*)

FROM

LOCK (NOLOCK)

WHERE

TABLENAME=@TABLENAME AND

ROWID=@ROWID

IF @LOCKSTATUS=0

BEGIN

INSERT INTO LOCK

(

TABLENAME,

ROWID,

USERID

)

VALUES

(

@TABLENAME,

@ROWID,...

Any value you want to be aware of is going to vary based on your baseline and setup. As I said, this...