Viewing 15 posts - 1,501 through 1,515 (of 2,387 total)
David, Thanks for the sample. It works great.
July 16, 2003 at 8:01 am
quote:
Does SQL server rollback one of the transactions if there is a dead lock ? ( Oracle does )
July 15, 2003 at 6:46 pm
Any update and insert statements will be logged even though database is set as simple recovery mode.
In order to minimize transaction being logged in BULK Insert, all following considitions...
July 15, 2003 at 1:18 pm
dbcc inputbuffer(spidhere) or run profiler.
July 15, 2003 at 11:57 am
This example forces the current identity value in the jobs table to a value of 0.
USE pubs
GO
DBCC CHECKIDENT (jobs, RESEED, 0)
GO
July 15, 2003 at 6:45 am
Run sp_who2 to check whether this batch job is blocked during its execution. Do you have same error all the time or it just happens occationally when you execute it?
...
July 14, 2003 at 7:16 pm
Unlike many of the other counters available for monitoring SQL Server, this counter averages the Buffer Cache Hit Ratio from the time the last instance of SQL Server was restarted....
July 14, 2003 at 7:00 pm
Try to reinstall MDAC 2.7 sp1. You can download it from http://www.microsoft.com/data.
July 14, 2003 at 6:21 pm
Try to use server network library (svrnetcn.exe) to enable TCP/IP protocol.
July 14, 2003 at 6:17 pm
Log backup failure doesn't break the log backup chain. In your situation, 2:00am log backup will capture all transaction log entries since 11:00pm. You can restore full database backup from...
July 14, 2003 at 1:49 pm
quote:
What I want to do, however, is get the second result set from executing sp_helpdb and specifying a specific database.
July 14, 2003 at 1:26 pm
To use AWE memory, you must run the SQL Server 2000 database engine under a Windows 2000 account that has been assigned the Windows 2000 lock pages in memory privilege....
July 14, 2003 at 1:21 pm
Which edition of SQL Server you are running? How much addtional memory did you add? Can you post the result of sp_configure here? How large is your database?
July 14, 2003 at 12:22 pm
Can you connect it with ip address? Check SQL Server errorlog for error message.
July 14, 2003 at 9:47 am
Viewing 15 posts - 1,501 through 1,515 (of 2,387 total)