The default is.... unlimited, because this functionality is not supported in SQL 2000.. As an aside it really isn't supported in SQL 2005 directly either..

CEWII

THe only way thatI can think to do it is to convert it to an int and then reformat it.

SELECT NewValue = RIGHT('00000'+(CONVERT(nchar(5),CONVERT(int,'00021')+1),5)

CEWII

I don't know, I was commenting that the code seems to be for SQL 2000, as far as whether it will work with 2005 is a question given that 2005...

I kind of like rgoerwit method, if you don't get the response frmo these users you want then you might restrict them to the point that it is possible but...

Not sure you did anything wrong..

I noticed that the code seemed to be for SQL 2000 are you sure it works for 2005?

CEWII

You really are new to DTS...

Double click on the line between connection 1 and connection 2.. The first tab should have it.

CEWII

Might I make an alternate suggestion, if you are trying for high availability or say a reporting server you might look at log shipping.

Before I answer your question though, I'd...

I was just thinking that you could provide a SSL Proxy, this would be similar to using STunnel. I don't think you want to directly expose your SQL server...

I agree that is a LOT of SQL on a cluster. I heard a hard number of 3 instances, I think it depends on a lot of factors, such...

Grant Fritchey (8/5/2009)

---

The key, the hard part, is figuring out how to do incremental updates that could lead to data loss. Adding a nullable column or updating a stored proc...

That depends a lot on how well the existing components satisfy your needs.

For simple packages at the beginning, probably not much. As you try to accomplish things...

Testing is easier on the single row, because when you call it interactively it returns the row so you can see it. The other way requires just a bit...

If I understand the question, then why don't you execute both queries with a UNION between them?

CEWII

I'm sure we can, but what issue are you having, you haven't provided enough information, it is almost "it doesn't work, can you help?" What about it doesn't work,...

I have had some cases where stopping the SQL server when this is occuring trashes the database.. So I'd just wait for it to finish, it sucks but it...