We have some SQL Server 2000's running on NT 4.0 and others that we have upgraded to Windows 2000. The only problem we ran into was with one of...

We have our SQL Server agents running all the time and I am sure most other servers do as well. This is a needed service for automated tasks.

I read...

Is this what you are looking for:

DECLARE @names varchar(500)

SET @names = ''

SELECT @names = @names + ',' + surname

FROM CS_STAFF

SET @names = RIGHT(@names, LEN(@names) - 1)

PRINT @names

Robert Marda

SQL Server will...

If you don't have to use ActiveX Script then the following SQL will make an entry in the NT Eventlog:

raiserror ('customer insert failed', 1,1) WITH LOG

Robert Marda

SQL Server will deliver...

What exactly is that fix and is it available on their web site? We have had issues with processes hanging after running xp_sendmail.

In the instance I sited...

You do not have to qualify the SELECT statement.

Another alternative is to place the stored procedure on Server2 in the database where the table resides and then execute...

A similar thing happened to us at least once. We had a process that had been running for a long time and so I killed it. It went...

I am constantly seeking ways to improve SPs and Queries. When not monitoring things, I read on sites like this (mostly just this site these days), or read in...

I just went to SQL Live last week. It was great. This was the first conference I went to and I learned a lot. The majority of...

I would never install any Service Pack on a production server without first testing on a development server. Until you test you won't know how the application will react...

Antares,

Perhaps I am too tired, but I can't find where to adjust the maximum rows allowed for failure. I looked on the general, globalvariables, logging, and advanced tabs...

Which example are you looking?

Robert Marda

SQL Server will deliver its data any way you want it

when you give your SQL Programmer enough developing time.

I'll have to check that. Thanks!

Robert Marda

SQL Server will deliver its data any way you want it

when you give your SQL Programmer enough developing time.

I could do that. I think the best way to do that would be to reduce the number of rows. As far as I know they should all...

I guess I needed to provide more information and yes I feel like needing a sanity check after having sleepless nights the past 3 days.

When I run this package manually...