CHECKDB loop SQL 2008
Wed, 03 Mar 2010 15:27:49 +0200
On my SQL 2008 SP1 server it seems there is a loop of events for 3 of
the databases existing on this server.
On the Windows Application event log there are intermitently logged events
17137 Starting up database 'db'
and then
17573 CHECKDB for database 'db' finished without errors on yyyy-mm-dd
07:13:53 ...
|
SQL - Relational DBs Overview Resources
Wed, 3 Mar 2010 01:31:02 -0800
Hello there,
Are there good resource documents on the web somewhere providing a
very good rundown of what relational DB's are, how they are used,
tables/constraints/relations/etc, all the usual conceptual suspects, in
roughly 100 pages or less?
A friend sort of inherited a small s ...
|
Dump Database instantly
Tue, 2 Mar 2010 21:38:01 -0800
Hello,
I would like to capture the contents of a database (complete) at a
particular instant. This could be triggered for different reasons. At any one
of these trigger events (trigger: not to be interpreted as SQL trigger) the
entire database should be dumped in whatever state it was. This will be used
f ...
|
copy entire database over to linked server
Tue, 2 Mar 2010 16:47:08 -0800
I just setup a linked server that is provided through our ISP. Our database
is setup as merge replication that is pushed to four remote locations all
running sql server.
I want to setup the linked server with the same database. What is the best
way to do this? Can I configure merge replication with the link ...
|
orphaned transactions
Tue, 2 Mar 2010 16:22:08 -0800
Hi
I have located some orphaned transaction in "sys.syslockinfo WHERE req_spid=
-2", but I cant see them using sp_who or sp_who2. I can still kill these
using UOW.
Any idea why these are not listed in sp_who with spid=-2?
thanks in advance
--
Regards
priw ...
|
DBCC SHOWCONTIG
Tue, 2 Mar 2010 13:10:01 -0800
What does it mean when this report shows blank under index name?
Thanks in advance ...
|
SQL Server 2005: Management Studio missing after setup
Tue, 2 Mar 2010 12:35:02 -0800
hi everyone
i already posted this in the setup group but couldn't get a reply up until
now.
yesterday i was experiencing some issues trying to install SQL Server
2005 on my Windows Server 2008 R2 box (64-bit).
after i completed the installation i can't seem to find the SQL
Management Studio. i have s ...
|
|
|
Query Database Properties
Tue, 2 Mar 2010 12:34:01 -0800
I am hoping this is a relatively easy one...
I need to create a document that includes several key items from a specific
SQL Instance:
* Server Name
* Database Name
* Owner
* Date Created
* Size
* Table Name
* Schema
* Data Space
* Row Count
I can see this informatio ...
|
Reinstall necessary to rollback SQL 2005 SP3?
Tue, 2 Mar 2010 15:30:52 -0500
I'm very confident that SP3 will be installed without a mishap, but the
boss is insisting on a fallback plan. So, I started investigating what
it would take to roll back to SP2, and was alarmed to find that an
uninstall/reinstall of SQL Server (along with a couple other hoops to
jump through) was necessary to ro ...
|
Users with "VIEW SERVER STATE" only see current session
Tue, 2 Mar 2010 10:11:02 -0800
If I login as sa or a user with "VIEW SERVER STATE" permission, and query
sys.dm_exec_requests, I see only sessions < 50 and the session for the user
doing the query.
As I understand it, I should be able to see all sessions for all users on
the server. If my understanding is not correct, let me know. If m ...
|
