Viewing 15 posts - 1,516 through 1,530 (of 2,387 total)
I am not aware of spid -2. you should kill the block process from the finding of sp_who2 and find out what command is causing the block by running dbcc...
July 14, 2003 at 9:34 am
syslockinfo contains information on all granted, converting, and waiting lock requests. How do you interpret these information into a list of orphan transactions?
Are you talking spid 2 or spid -2?
...
July 14, 2003 at 9:19 am
sp_who2 will tell you which transaction is blocking other transactions and which transactions are being blocked by who.
How do you know those transaction are prphan transactions?
July 14, 2003 at 8:42 am
You have to restore full database backup with 'norecovery' before restoring any transaction log backups. Only transaction log backups that are created after the full database backup can be restored.
...
July 13, 2003 at 1:34 am
From BOL.
"How to restore a database with a new name (Transact-SQL)
To restore a database with a new name
Optionally, execute the RESTORE FILELISTONLY statement to determine the number and names...
July 13, 2003 at 1:28 am
You can download MDAC component checker from Microsoft to verify the version of MDAC in both server. I would suggest to reinstall the MDAC to your Dev server.
July 11, 2003 at 9:34 am
quote:
Can anyone tell me the proper steps for how to shutdown both SQL servers in an active/passive cluster.
July 11, 2003 at 9:22 am
You may think the pass-through query in Access to call stored procedure in SQL Server too.
July 10, 2003 at 3:51 pm
Do they have same number of records? Create identity column in each tables and run the query above.
July 10, 2003 at 3:48 pm
Your assumption is right, they are created by query optimizer. You can drop them by using DROP STATISTICS command. Be aware dropping statistics may affect the plan chosen by the...
July 10, 2003 at 3:42 pm
See other people's discussion at http://dbforums.com/arch/70/2002/11/559754
July 10, 2003 at 3:32 pm
Assuming two table have common columns ID.
select aaa.a1 - bbb.b1 as Result
from aaa
inner join bbb
on aaa.id = bbb.id
July 10, 2003 at 3:28 pm
Can you ping to server1? Is server1 configured with mixed authentication mode?
Edited by - Allen_Cui on 07/10/2003 3:24:55 PM
July 10, 2003 at 3:24 pm
SET ROWCOUNT your_number_of_row.
causes SQL Server to stop processing the query after the specified number of rows are returned.
or
Using TOP and PERCENT to limit the number of rows returned in...
July 10, 2003 at 3:19 pm
5GB is not that large so I would back it up, zip it and FTP to your client. You may look pkzip software.
In order for your client to change the...
July 10, 2003 at 3:11 pm
Viewing 15 posts - 1,516 through 1,530 (of 2,387 total)