Viewing 15 posts - 481 through 495 (of 2,387 total)
Do you run a distributed transaction against a linked server ? Any more information in errorlog?
February 13, 2004 at 8:48 am
nonclustered, unique, primary key.
February 13, 2004 at 8:40 am
Is availableamount = totalavailable - salesamount?
if yes, then
select customer, salesamount, totalavailable - salesamount as availableamount, totalavailable from temptable
February 12, 2004 at 5:52 pm
Try to configure the security settings on the SQL Server to permit Mixed mode (NT and SQL Server) authentication.
If it doesn't work, try to install MDAC 2.7 SP2.
February 12, 2004 at 5:47 pm
February 12, 2004 at 5:40 pm
Do you backup log regularly? If you are, restore last full database without recovery, restore the log backups after last full backp one by one in sequence up to point of...
February 12, 2004 at 5:30 pm
You have to backup the log separately. If you never backup the log, backup it now before your start the restoration.
When you restore the database, restore the full database with...
February 12, 2004 at 2:52 pm
In clustered SQL Server environment, The IsAlive thread runs under the context of the cluster service account which have to be able to log into SQL Server for the IsAlive...
February 12, 2004 at 2:48 pm
You may use "NOLOCK" hint in select statement. The hint has same effect as the SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED.
February 12, 2004 at 1:25 pm
From BOL.
"
Process ID %d attempting to unlock unowned resource %.*ls.
This error occurs when Microsoft® SQL Server™ is engaged in some activity other than normal post-processing...
February 12, 2004 at 1:20 pm
Try SQL Server authentication.
Is Access database a secured database?
February 12, 2004 at 1:18 pm
We have exactly issues after installed SQL Server service pack 3a and hot fix 844 recommednded by SAP note. Database server performance decreased largely and we have seen waittype on...
February 12, 2004 at 12:56 pm
create table #mac (address varchar(255))
insert into #mac exec xp_cmdshell 'ipconfig.exe /all'
select substring(address, 38, 17) from #mac where address like '%Physical Address%'
drop table #mac
February 12, 2004 at 11:12 am
Use sp_procoption to set stored procedure to autoexection runs every time SQL Server is started. In the stored procedure, run alter database command to set database in full recovery mode.
February 12, 2004 at 10:05 am
Viewing 15 posts - 481 through 495 (of 2,387 total)