Best thing to do is Create table(s), Insert Data, then create the indexes.
May be you can check how much ram is assigned to the operating system. You should leave a good amount of ram to the operating system (depends on the...
Hello, If there is no connection to the databases, I dont think they using SQL server resources. I will take full backup of these DBs and remove them...
Hi I had this issue recently (3 years after Zirco post) and I installed SP4 on client machine. I am Now able to connect to 2008 from SSMS 2005....
Hi, What are you trying to accomblish by importing this data to SQL table? SQL server provides functionality to acheive this; however, You still can...
Could it be the concurrent user connection has reached limits if it is set to a number other than 0.
I Wish I can have a chance to re-install everything, it would be awesome. I will update you if get them convinced. Thanks Satya
Thanks Satya. Actually when I came here, the first thing they asked me to do is removing the cluster. It was already missed up because it was not...
So, Is there a special procedure to follow for breaking cluster, and use boxes as stand alone SQL servers.
No, it Must be broken
There are too many problems, I guess who ever setup the cluster did not install it the right way. Management decided to break the cluster since it...
hmmmmmmmmmm, management decided to turn off the cluster and use machines as regular SQL server. Is this possible? I think there will be alots of...
Thanks Satya, there is exactly SSPI handshale error 17806. how could DNS affect the cluster? ** Update: when I isolated nodeB from the cluster,...
Satya, I will check that. Thanks everyone for your help.
Hi Satya, here is the error message 'login failed for user 'test' the user is not associated with a trusted SQL server connection (microsoft error...
Run a trace using SQL profiler and make it record data into a table. set the trace to run in all databases on the server. hope that helps
I will get the error message and post here, this messge and a suggestion from a member of server team pushed me to disable VIA.
btw the SQL instance is configured for mixed mode authentication. Its 2 nodes cluster.
virtual machine that we monitor the cluster from. some admins say what ever I wanna do on the cluster, we should do it thru this virtual machine and...
Hi All, I am new to cluster environment. we have 2 nodes cluster active/passive, we have an SSIS package in the virtual node. the package should run...
Separate names with a comma.
