Have you looked at sp_whoisactive?

John

You can't build a table name from variables. You'd need to use dynamic SQL, which I don't think you can use in a function, so you'd need to change...

One alternative is to use a calendar table, with a row for each date and an IsWorkingDay column that you can use to count three working days forward. If...

Steve

DDL, code and execution plans would indeed be helpful, please.

When you do a UNION, the result sets all have to be sorted together to eliminate duplicates, so it does seem...

Do you get the same problem if you choose a matrix style other than Forest?

John

What command are you using to do the restore, or are you using the GUI? If you're using the GUI, please use the Script button on the Restore Database...

Damian

Just right-click on the job in SSMS, choose Script Job As and use one of the options to generate the script.

John

From what we know, we can't assume that Product is a table and not a view. What does this query return?SELECT

SCHEMA_NAME(schema_id) + '.' + name AS ObjectName

,'View' AS ObjectType

FROM...

Anandkumar-SQL_Developer (12/15/2016)

---

Dear Shekhu ,

Thank you very much for your valuable time . your code is working well. it showing clustered & nonclustered index only...

So you want the CREATE INDEX statement for the given index? You could right-click on the index in SSMS and choose Script Index As. If you want it...

Have you tried sp_helpindex?

John

You could run the job on a server that does have SQL Server Agent, I suppose. (Your job, that is, not Ola's.)

John

I recommend that you use Ola Hallengren's backup solution. No sense in wasting time writing it yourself when he's already done so for you!

John

This will give you an idea of how to do it. I'm sure you'll be able to make it a lot simpler than I have!CREATE TABLE #Names (Col1 varchar(4000),...

Vikram

If Col1 is always in the format shown, then you can indeed use SUBSTRING, something like this:

SUBSTRING(Col1,Col2*2-1,1)

John