Viewing 15 posts - 226 through 240 (of 433 total)
I should rather trust SQL Server backup/recovery then the tool you are using. If this is about the critical databases please have a good backup strategies.
January 21, 2008 at 11:59 pm
From my point of view it will be better if you re setup the logshipping once again including the additional server.
January 21, 2008 at 11:53 pm
This is a clear cut corruption issue, the heap table is effected.
1. check the hardware by running diagnostic tool. check the system event log and replace the effected hardware.
2....
January 21, 2008 at 11:39 pm
The error is clear from the application(client) you are not able to connect to the sql server.
>>Check if the coonection string in the application is set correctly or not....
January 21, 2008 at 11:14 pm
Not much of different 🙂
you can use all the tools and steps which you were following to tune in SQL Serevr 2000.
Database Engine Tuning Advisor is a new tool which...
January 21, 2008 at 10:51 pm
From the link :http://msdn2.microsoft.com/en-us/library/ms189799.aspx
Using a DML trigger with a reminder e-mail message
The following example sends an e-mail message to a specified person (MaryM) when the Customer table changes.
USE...
January 21, 2008 at 3:06 am
May be the requested OLE DB provider is not installed in your system. Run component checker ( MDAC) and download the required version from the site. Call up MS Support...
January 21, 2008 at 2:56 am
This is a SQL Server 2000 issue addressed in the wrong forum.
Is it the query or any other parameter that is hiting the CPU usage?
Some time by restarting the SQL...
January 21, 2008 at 12:14 am
find out if there is any job/maintenance plan running at that time to drop the procs, if yes then stop that job or maint plan.
January 20, 2008 at 10:54 pm
Add trigger to the table to log these changes or run profiler to trace.:)
January 17, 2008 at 3:39 am
The best and safest way is to reinstalling the SQL Server with required collation.
other step:( FROM MSDN)
Make sure you have all the information or scripts needed to re-create your user...
January 16, 2008 at 3:28 am
Do take care SQL logins by following the Microsoft KB 246133.
Or else you can script all the users and logins by choosing All Task --> Generate script ->...
January 16, 2008 at 2:59 am
What is the eaxact version of SQL you are using?
IF you have installed SQL2005 SP2 before march 6th, then there is a know bug on cleanup task.
This problem...
January 14, 2008 at 12:46 am
Hi,
Dbcc showcontig shows the fragmentation in the table why you are checking that for space used. ??
January 9, 2008 at 12:06 am
There is a script available in the following link about auditing a table.
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31950/
December 27, 2007 at 3:20 am
Viewing 15 posts - 226 through 240 (of 433 total)