Viewing 15 posts - 121 through 135 (of 142 total)
I don't see any such problem. There may be something more you are trying to do with the plan.
I have version Microsoft SQL Server 2005 - 9.00.3152.00 (Intel X86) ...
December 16, 2008 at 4:24 am
I never heard this. Simply copying the file does not shrink the data file for sure. If you can share the script used for copying the file then we can...
December 16, 2008 at 3:44 am
True as it was removed from SQL Server 7.0 onwards. The query to syslog was changed with DBCC command. Sorry about my previous post on this subject.
December 15, 2008 at 10:04 am
Hi,
You can get transaction id and operation type only (no data) through a select * from syslogs.
Use the following code to make it a bit more readable.
SELECT
xactid AS TRAN_ID,
CASE...
December 11, 2008 at 4:37 am
It may be like a learning when dealing with Full Text Index databases. Still little confusing as it should show error when the Full Text catelog is lost/broken. The search...
December 10, 2008 at 11:30 am
Reindexing every four hour is not a good idea in anyway. It will create the object locking problem with the increase in the table size. This may be due to...
December 10, 2008 at 11:18 am
Good question with perfect answer. Thanks
December 10, 2008 at 8:03 am
Good brain eaching session.. 😀
December 10, 2008 at 7:33 am
Hi,
When you restore the database backup files, it restores the database and data files in the same manner and size when it was backed up. So if your mdf file...
December 10, 2008 at 7:11 am
Hi Reubenfoo,
After looking your information it is hard to say if all the Excel file will have the same kind of data or same column structure. If it is same,...
December 4, 2008 at 4:42 am
During the restoration process, shrinking the database file is not possible. It always retains the values of its original status.
I prefer to shrink the database files before we take the...
December 3, 2008 at 9:12 am
I am not very comfirtable with your requirement. There has to be some proper logic behind.
Anyway, you need to know the features and properties of Excel.Application object in VB for...
December 3, 2008 at 8:43 am
The first time excution of any stored procedure will take more time than subsequent runs. It has to compile the script, decide on execution plan, pull the data pages,etc.
Once all...
December 3, 2008 at 8:18 am
I have not see such error in past. May be your Full Text engine installation is not proper. Can you try to uninstall the Full Text engine and reboot the...
December 3, 2008 at 8:12 am
Hi,
This is known bug with SQL Server 2005 SP2 Maintenance plan. They work very funny at times.
You can try to install the hot fix from below:
Hope this will...
December 3, 2008 at 6:43 am
Viewing 15 posts - 121 through 135 (of 142 total)