Hi, I run a store procedure to update 3 tables, one of the table have trigger setting, when table C hit the trigger, why only Table C will rollback...
Hi, Recently, always get an error message 'Fetch type out of range' when call a function to return a string, i have check the function, there is no...
Hi, I get an error message as below when run my program thru the ADO which is connect to SQL 2008 database, but when I copy the script and run that...
Dear Sir, I have a Log Shipping database in StandBy mode which the database will Copy Trn file from production database and Restore to this Log...
Hi, Anyone can help on below : 1) Why The Activity Monitor still listed out a lot of ProcessID which run few days ago ? 2) is it still holding any...
Hi, I found my Log File growing to large file size, i try to add the Shrink Database Task (set to shrink when grows beyond 50mb) on my daily...
hi, I am using MS SQL 2005, recently i found that my ldf file grow bigger, but the database is not access by the users for a few months ago. How...
Hi, I am using SQL 2005. Recently i found some of the data missing after few days entered. Some of the Master Table records missing but detail table...
Hi, I get the above error message when running a script, how to Enable the MSDTC ? I have set the link server success at my MSSQL server...
Hi, I am using MSSQL 2005 and apply SP3. There is no problem found when manual backup When execute Schedule Backup Job, error message below...
Separate names with a comma.
