Viewing 15 posts - 946 through 960 (of 2,387 total)
Try user CREAT INDEX command with index option FILLFACTOR = fillfactor to recreate your index.
October 21, 2003 at 7:18 am
http://support.microsoft.com/default.aspx?scid=kb;en-us;327552&Product=sql
Which service pack and hotfixes do you run?
October 20, 2003 at 9:24 am
Schedule a job at OS level with "Schedule Tasks" from control panel to monitor whether SQL Server service MSSQLSERVER running regularly with tools such scm.exe from SQL Server, sc.exe from...
October 20, 2003 at 7:49 am
I had experience this long before (2-3years ago). We installed SQL Server 7.0 with CD provided by SAP and try to upgrade it to SQL Server 2000 with CD from...
October 17, 2003 at 9:26 am
It has to go as large as it needs, right? Make sure it does not run out of disk spaces and meanwhile, try to find out what are happening to...
October 16, 2003 at 2:43 pm
From BOL.
"How to back up the transaction log when the database is damaged (Transact-SQL)
To create a backup of the currently active transaction log
Execute the BACKUP LOG statement to back...
October 16, 2003 at 2:32 pm
You can switch between full and bulk-logged recovery models easily. It is not necessary to perform a full database backup after bulk copy operations complete under the Bulk-Logged Recovery model....
October 16, 2003 at 2:30 pm
He may have large number columns defined with nullable.
Load result of sp_columns 'yourtable' into cursor, loop the cursor, find the columns with nullable defined, create dynamic select statement as showed...
October 16, 2003 at 2:19 pm
Check whether there are blocking during the deletion of those records.
October 16, 2003 at 2:14 pm
http://support.microsoft.com/default.aspx?scid=kb;en-us;253817&Product=sql
Suggest you backup transaction log more frequently if possible.
October 16, 2003 at 2:12 pm
I have test server setup to run both SQL Server 7.0 and SQL Server 2000 (SP3a with hotfix). XP_SENDMAIL works well in SQL Server 7.0 but received similar (Not exact)...
October 16, 2003 at 2:05 pm
Any error messages? Foreign key constraint?
October 16, 2003 at 1:22 pm
You should check your table schema to find out which columns are allowed to be 'nullable'. There is a chance these columns have 'NULL' value.
October 16, 2003 at 12:54 pm
I would check machine application/system logs to try to find out what happened exactly to your machine.
Beacuse your MDF was not available, SQL Server was unable to start your database....
October 16, 2003 at 12:39 pm
Viewing 15 posts - 946 through 960 (of 2,387 total)