I have the same exact problem except that I am using Sybase as ole db data source. Columns are not appearing. I am calling a SP with the last statement...

You are right. The password last change date is in some crazy format. Everything i get out of the ADODsObject thru sp_OAMethod is a big integer value. Although when you...

Annadurai - I believe you are right. Although i am using Sysadmin account to login/create job etc.. So, that is what is confusing me.

Even i would like to know the answer for this question. Can someone reply to this?

In Sql Server 2000, when you are using trusted connection for replication (EM --> Replication...

I did not mean deadlocks. I meant blocking locks. BTW, not all locks are blocking locks. A lock becomes blocking lock only when another process is looking for the same...

Folks, any replies... Thanks.

Thanks. That helped.

I enabled the replication and then did a sp_repldone and then disabled the replication. Then I was able to truncate the log and shrink the file. Thanks...

I am having the same problem but only the database is not replicated. (This is a database that was copied from a different server which was replicated).

On the new...

Try this:

ALTER SCHEMA NewOwner TRANSFER ;

Thanks Adam. I will definitely tell him you gave the link.

BTW, this is a great product. I have been using this product for about 4 to 5 years. There...

Copyright violation

Please check out

http://sqljunkies.com/Article/F5783CE9-BA74-4657-BF9D-1139BCC3096B.scuk

Srinivas Sampath originally posted this UDF in the above link. Please either remove this post or give proper credit.

I had the same issue before too.

UDF works but very slow. So, I believe just got to live with it. Thanks everybody.

XML Path works great in SQL 2005. But right now, I need it in SQL 2000. Thanks.

Sorry, I fat fingered the question. I edited the post. Can you see the question now? Thanks.