Thanks, but my SQL2K box uses OPENROWSET with parameters and it works.

My extracted code will not work even if I hard code the values of the parameters.

I've had to get...

I haven't read this particular book, but my comment is that a book from a different discipline can provide a useful perspective that is applicable to the SQL discipline.

For example,...

I've done it using an ADO Stream object. See Wrox Press ADO 2.6 Programmer's Reference.

Once you have done it for one sort of file then you can do it...

Yes, good ideas here.

Anything that makes old code easy to read gets my vote.

Has anyone used sp_addextendedproperty to help comment objects within your databases?

Thanks Andy,

Using the -SubscriberLogin [mylogin] -SubscriberPassword [mypassword]in the distributor agent sorted it.

I don't know why it didn't work before, but it works OK now.

I've been having similar problems with replication since changing the SA password.

I changed the password on both the Publisher/Distributor and on the Subscriber.

Both have exactly the same password.

The Distributor job...

The results are very US biased.

In the UK there are a lot of jobs advertised for DBA's and one of the questions employers ask is "Can you do stored procedures"....

Warm and Fuzzy!!!!!

That describes sales pitches and user specs.

It gives me a warm glow to remember that there is only so much to cock up in 256Kb RAM or a...

The Commodore Pet predates the VIC20 by several years.

There is an original in the London Science Museum. I saw my 1st Pet in 1980 but I think it harks...

.....and still have change from a ha'penny.

I started out my database work using a Commodore Pet, 6502 machine code and the original Commodore disk drive so I guess I pre-date...

I found that if I create a stored procedure as follows

CREATE PROC usp_SetName @sName VARCHAR(50)

AS

SET NOCOUNT ON

SET QUOTED_IDENTIFIER OFF

INSERT Tbl_Name (Name)

VALUES (@sName)

GO

Then executing the stored proc

exec usp_SetName "O'Reilly" gets...

Years ago I was told that Microsoft set up a Publisher on one side of the Atlantic and the Distributor/Subscriber at the other.

When they got their first phone bill it...

quote:

---

In our environment, we capture and process millions of transactions per day. We increased throughput on these intense inserts (15%) by...

I would regard having a compound primary key as terrible practice.

By all means have a unique key on it, but the primary key?

I have a situation where we have an...

You were the last person consulted on a database issue and got so pissed off you resigned.

6 months later you see your old job advertised at twice the salary.

Scott Adams...