Viewing 15 posts - 286 through 300 (of 301 total)
So the Max size remains the same as sql 2005 which is 524258 TB. May be a documentation error in MS143432. Thanks Krishnaraj!
August 16, 2013 at 11:02 am
They are related to system SPIDs. See the SPID column, all are less or equal to 50
July 9, 2013 at 2:46 pm
I agree with all the steps SueTons, except after a role switch, jobs that ran on the former principal database must be disabled and recreated on the new principal server(DR)...
July 8, 2013 at 2:27 pm
Sounds like one of the accounts you are trying to connect to the
publisher/distributor/or subscriber is not defined. You will need to use an
account which is in the pal...
June 29, 2013 at 7:04 pm
See if there is any open transactions (uncommitted transactions) using dbcc opentran which will show any blocked spids. Look for any locks on your table using sp_lock or (dm_tran_locks) ...
June 24, 2013 at 10:20 am
Any one can explain the difference please
SID authentication VS group authentication
In terms of cluster in Windows 2003 server and 2008 server.
June 15, 2013 at 9:19 pm
1. connect to the MASTER database of the server with the offending database
2. run the query below to find what transactions are open
3. kill any transaction that is blocking the...
February 7, 2013 at 8:13 am
Thanks Gail...
November 28, 2012 at 9:14 pm
Could you please say in general
November 28, 2012 at 1:40 pm
"A fatal error occurred while reading the input stream from the network. The session will be terminated" - This is a network adapter error, most probably a driver issue.
To determine...
November 20, 2012 at 8:20 pm
This ticket was system generated. I also checked if it's clustered or not and it is not.
Someone from app team called one of the dba and it was found that...
October 12, 2012 at 4:09 pm
TY, I will look into it and update you soon.
October 12, 2012 at 11:45 am
When I test the connection, giving me these errors
Login timeout expired
An error has occurred while establishing connection to the server
The error may be caused due to the fault that under...
October 11, 2012 at 11:24 am
1) Connect to SQL Server instance.
2) Select Server Objects folder and expand.
3) Select Linked Servers folder and expand.
4) Right click on linked server which you want to change the password...
October 2, 2012 at 2:29 pm
Please see if this link helps
Good luck
August 16, 2012 at 11:34 am
Viewing 15 posts - 286 through 300 (of 301 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy