You could write a stored proc to do it and make it a startup proc.

Steve Jones

steve@dkranch.net

I wasn't aware they could be hidden? The default instance will respond on port 1433. Named instances use other ports, but I can't remember off the top of my head...

Not sur why that wouldn't work. Smalldatetime is just a little smaller (in size) than datetime.

Glad its mostly working.

Steve Jones

steve@dkranch.net

I also use David's technique.

Steve Jones

steve@dkranch.net

transactional isn't that much overhead, especially if you move teh distribvutor to another server. What's a lot of transactions? I've had this work in a few solutions as the overhead...

I've seent his before. We had to uninstall nad reinstall the client.

Steve Jones

steve@dkranch.net

Actually Andy, I found the skeleton for such a project on msdn. When i get back to work, I'll post the link.

btw, how do you get to presecute the offenders?...

no second case needed.

declare @cmd varchar( 100), @x int

select @x = 1

select @cmd = 'this' +

case when @x = 1

then ' or...

Its

select @cmd = 'update ' + @targettable + ' set ' + @variable + ' = ' +

case when @datatype = 'int'

...

character and date types need quotes.

Steve Jones

steve@dkranch.net

You are welcome. We try and hope we can help.

Steve Jones

steve@dkranch.net

I think VB.NET is a good step forward, but personally I'll lean more towards C#. Always loved C.

Steve Jones

steve@dkranch.net

caveat DBA. If you have no pwd, then MS doesn't want to hear it and I agree in this case.

Steve Jones

steve@dkranch.net

I used it with a couple small lookup tables. On our server, it didn't really provide any noticable difference.

Steve Jones

steve@dkranch.net

I spoke with a few DBAs that had an array and they loved it. It performed beautifully and notified them when disks failed. It was the most painless array and...