Posted
by Manjot
on Stack Overflow
See other posts from Stack Overflow
or by Manjot
Published on 2010-05-13T23:49:32Z
Indexed on
2010/05/13
23:54 UTC
Read the original article
Hit count: 286
Hi,
Using Tsql, how can i know when DBCC checkdb was last run on SQL server (2000, 2005 or 2008)?
Regards
© Stack Overflow or respective owner
as seen on Server Fault
- Search for 'Server Fault'
Hi all,
When running stored procedures in MSSQL Server, I found it failed and the DBMS (MSSQL Server 2005 Dev Edition) notified that some indexes are corrupted.
Please advice me, here below is DBCC logs:
DBCC results for 'itopup_dev'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a SQL Server 2000 database. When I run the following command
select * from sysindexkeys
This display the appropriate records.
I then do a DBCC command for the sysindexkeys. It doesn't display anything. Strange there is no page having the sysindexkeys records. Then how the query display…
>>> More
as seen on SQL Server Central
- Search for 'SQL Server Central'
Returning author Wayne Sheffield recently had some database corruption - read about how it was fixed.
>>> More
as seen on SQL Blogcasts
- Search for 'SQL Blogcasts'
Before I post anything I just want to clarify what I mean by RAID 10 , this is sets of mirrored pairs that have been striped as against a RAID 0 which has been mirrored. I've just had a disk failure in the data array for one of my dev servers, it's an eight disk raid 8, no real worries, replace…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
First of all – if you are going to say this is very old subject, I agree this is very (very) old subject. I believe in earlier time we used to have this only option to monitor Log Space. As new version of SQL Server released we all equipped with DMV, Performance Counters, Extended Events and…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time.
My association with SQL Server Magazine has been quite long, I have written nearly…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hi,
I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager.
I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't…
>>> More
as seen on ASP-PHP.net
- Search for 'ASP-PHP.net'
Modification technique pour le site de l'article.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it.
We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error:
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections
What…
>>> More
