Hi Guru could you please advise how to apply MS hotfix http://support.microsoft.com/?kbid=936232 in SQL 2K cluster enviroment? it's win 2K3 EE, SQL...
thank you very much for this usefull infomation. by the way, could you please let me know if i can set this property in SQL 2000 clustered? we have...
Hi All does the SQL cluster has this function: SQL server can automatically failover to second node when it hangs up (App can't access it) but the...
Hi All we encountered this issue on our node 2 of SQL cluster. the environment is : windows 2k3 EE, SQL 2k EE + SP4. the SQL cluster runs fine on...
thank you All i picked up the one which creates a function and call it from SQL query. have a good day.
Hi All i'm nt good at coding. could anyone help me how to get the max date from several datetime columns? we have a provider table: Provider...
but i want to see the status in right panel when i highlight the "job" item.
we use SQL 2k5 +SP2 as the production servers. but i couldn't see the red icon beside the job name when the job fails (like SQL 2K has X in red)....
Hi All i just upgraded one of our SQL 2000 to SQL 2005 SE+SP2. i modified one of the DTS packages after migrated them. i tried to save it as...
i fixed it. we had two set of .net framework on the box. thanks.
from summary.txt, i got this "SQL Server Setup was interrupted. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL...
could you please direct me which file i have to check? i checked some of them. hard to find one related to BIDS. thanks.
selected SQL server database services, integration services, and workstation conpoments, books online and developement tools. it's on windows 2003...
Hi All i installed to SQL 2005 EE on the box. there was no any error message during installation. but i couldn't find the BIDS installed. there is...
how come i couldn't find the devenv.exe etc file in C:Program FilesMicrosoft Visual Studio 8Common7IDE folder. please advise.
Hi All i just upgraded SQL 2K5 Standard Edition +SP2 on the old box (SQL 2K). i checked the service configuration and turned all on. the problem we...
Hi All how to preallocate space for tempdb in sql server 2000? i searched the internet for a while. i only got the method by increase the data/log...
i know. we'll upgrade to SQL SE soon. but i need to know there is any datbase size limit on it before we move more DBs into it -- more DBs is our...
Hi All one of our production server is SQL 2000 developer edition. the previous DBA installed developer edition --wrong edition on Windows 2003...
thanks a lot. i got and it works good.
Separate names with a comma.
