It's a limitation of the GUI. Personally I would stick to a front end app for data entry or use QA if you have to do an adhoc insert.

Wes

install ignore errors apply sp3 after install. I do belive that was the answer given.

Wes

I've got a used emc 3700 with 128 disk in it. It's slow that aside it is a trooper. No disk failures or hardware failures in any way.

Wes

Well, I personally go the SAN route much more growth and setting up the cluster is much much easier. There are very few people that support scsi attached clusters anymore....

Well I figured it out. the time isn't zero filled to a 24 hour clock. Say the time was midnight and 56 min 23 sec it would only read 5623...

you need double quotes due to the $ in the share name

exec xp_cmdshell '"\\testserver\c$\test.bat"'

give that a try.

Wes

you also get single digit numbers which isn't possible if it is doing the count from 1/1/1746 or whatever the year is. hrum.. I'll keep diging.

Wes

If you fire up profiler you will see that the query is passed through to the other server to execute a rowset object is created on the server with the...

if it works it works. I would have never thought to do that.

Wes

I'll start digging I don't even have my books on 6.5 any more.

Wes

I'm not sure what the computer managment screen is but in general EM is slow. it issues several queries and uses DMO objects to pull back everything it needs and...

the cluster admin saw it as online but did it appear to be running in ether enterprise manager or the service manager?

Wes

That would be my first place to look check all your cluster dependencies and make sure they are all tied to the right groups.

Wes

it can take as little as a few seconds and as much as minutes normally I see about a 30 second lag for failover between nodes and sql starting up....

I would look at permissions ususally the only time a cluster install will fail is if you don't have enough permissions to install something on one of the nodes.

Wes