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...
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...
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...
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...
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...
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...
Hi All one of our production server is SQL 2000 developer edition. the previous DBA installed developer edition --wrong edition on Windows 2003...
Hi All could anyone help me out with this issue? i need to assign exec permission on all stored procedures (a lot) to new created SQL login ID by...
could anyone tell me how i can know what the fillfactor is in a table/index? i need to rebuild the index in the table bu i don't know where i can...
Hi All one of our production servers experienced a lot of "The log file for database 'tempdb' is full. Back up the transaction log for the database...
Hi Guru i'm learning SQL 2005 @home. i'm wondering how to deply SSIS in the enterprise enviroment. i know the SSIS delpoyment flow is: create...
Hi All does anyone see this message in your cluster SQL server 2000? we got a lot of " svchost (836) The database engine 5.02.3790.3959 started." or...
Hi All we have a 260 GB database A. one of our disk is 500 GB on H, the other one is 300 GB on K. the database is in simple recovery mode. so that...
Separate names with a comma.
