Thanks much!

The deprecated sys.sysprocesses, along...

To clarify a bit, let's visit the documentation (always great fun! :-))

From https://msdn.microsoft.com/en-us/library/ms182792.aspx, on DBCC OPENTRAN:

Results are displayed only if there is an active transaction that exists in the log...

As I understand it, the one difference it could make is when the rows are extremely wide and the non-clustered index would be covering for a query that uses a...

To give you the best help we'll need sample data from the underlying tables and the expected results from the query. It looks like what you've posted here is the...

To clarify that a bit, I believe what Steve was referring to is the missing index information displayed when viewing a query plan. That is certainly applicable to the query...

It is probably somewhat more of an...

Yes, I usually use this script from Jason Brimhall.[/url] You can probably adapt it for your purposes.

Cheers!

Well, we probably have two separate things going on here then.

First, on the original subject of the session with all the locks, the fact that the log used for that...

Ah, well, in that case it's probably going to be a sticky issue if the query is actually causing any issues.

If it's still an active transaction and has been running...

With restoring from a backup it's different, and depends on whether you specify a MOVE clause.

If you don't specify a MOVE clause, then the restore will attempt to create the...

To get the answer information associated with the test id you pass to the procedure, you will need to join the tblAnswer to tblQuestion on the question ID, and use...

Thanks for the information!

What does running the following query show?

SELECT

last_request_end_time,

host_name,

login_name,

program_name,

open_transaction_count,

is_active=ISNULL((SELECT 1 FROM sys.dm_exec_requests req WHERE req.session_id=ses.session_id),0),

transaction_isolation_level,

text.text

FROM sys.dm_exec_sessions ses

INNER JOIN sys.dm_exec_connections con

ON ses.session_id=con.session_id

CROSS APPLY sys.dm_exec_sql_text(con.most_recent_sql_handle) text

WHERE ses.session_id=<put...

Ah, I understand your thought now.

Attaching the database files does not move them to the default data directory. They will remain in the location from which they were attached.

Cheers!

Thanks! I think I have a better idea what you're trying to do now.

First, there's a bit of a logic problem. The SELECT used in the NOT EXISTS is comparing...

First you would need to figure out what the SQL Server service account is.

For that, just open either Services or SQL Server Configuration Manager, and look at the value listed...