It's looking for the objects in master. Specify a database name in the query:

SELECT @lCommand = 'bcp "SELECT text FROM YourDatabaseName.dbo.syscomments WHERE Id = ' + CAST(@lObjectId AS NVARCHAR(100))...

This script should do the trick for you:

http://thomaslarock.com/2012/10/how-to-find-currently-running-long-sql-agent-jobs/

Switching from full to bulk logged or simple during ETL is totally possible and sometimes the best strategy.

Please note that if some big transaction grows the log file during your...

I suggest that you take a look at Ola Hallengren's index maintenance procedure.

It takes care of rebuilding/defragmenting indexes based on fragmentation level and skips the indexes with low fragmentation...

I'm afraid you'll have to monitor that when it's happening.

There's no DMV that records what you want.

I wouldn't say that.

I'm...

You should record the activity in your server to a table you can query afterwards to investigate what was running at the time.

If this was a SQL Server 2008 ,...

Duplicate post.

Replies here please:

http://www.sqlservercentral.com/Forums/FindPost1631386.aspx

The Quey Processor parses the statement (which is DDL, not DML) and then executes it.

Storing index data into pages is not a "decision": all b-tree indexes are stored in pages.

The...

However, seeing just one scheduler in Enterprise Edition is weird, even if it is an evalutation edition.

As far as I know, if you have the FULL media, it should contain all editions and the product key decides which edition you are installing.

See this question on dba.stackexchange...

Looks like you installed using the wrong license or wrong binaries.

During setup it asks whether you want to enter a product key or use a free edition, such as Enterprise...

It's pretty clear: the evaluation period has expired.

It's an Enterprise Evalution Edition. Buy or uninstall.

This is a SQL Server forum, you won't get much help on Oracle issues.

Lots of information missing from your post. See the first article linked in my signature line for posting guidelines.

One of your predicates is not SARGable:

left(itemcode,4) in ('1000','2000') or itemcode in...