As I mentioned we need to have something for all databases in case we get a request about changes were made to a table. I appreciate it if you provide...

Do I need to 1) remove node2 which I did add after I set up node 1 cluster, 2) install a failover cluster on node 2, and then add node...

What if you do not restore system databases, just attach/detach storage? I mean make the current standalone storage shared with the clustered server, and just detach/attach storage once SQL clustering...

Many thanks to both of you... After doing further research, I agree with your input as I have seen where others had issues with restoring master database.

Thanks,

Lava

Many thanks to you, I will test it and see if it works...

Lava

Thank you... Is there a way you can use cursor or foreachtable to see if that inc or inj fields are defined and if so based on the value to...

The query works when I pass it user id and password, but it does not work when I use integrated security. Any idea how to get integrated security to work?

I said I GOT CONFUSED 🙂 No one said anything 🙂

You are correct, it is security... I issued same statement this time using user id and password to see if it works, and yes it did give me results:

select *...

My mistake, I am not using openquery but opendatasource... I got confused as I was trying to see what the issue is... Anyhow, in any cases, security might not be...

When I go to linked server, I can see the system catalogs. Below is how I created the the linked server:

EXEC sp_addlinkedserver

@server=N'Webdev',...

Forgot to mention that when I run the queries on different instances same box, it works... However, it does not work when I do distributed query, from one box to...

Gail -

1) There is not a good backup before that happened, it had the error when I took over the work.

2) I do not get a record back when...

That is not the case, just checked.

There is a rebuild and reorganize jobs thar run on nightly basis, I do not think that is the cause.