I had written couple of SP's but such requirement never occurred.

Thank you Hugo and Jeff.

Andrew Ryan (7/9/2009)

---

Sorry if this has been covered but as you might imagine searching for this has been problematic.

I want to use vaariables with my USE commands.

USE @DBName

GO

if I use...

In above examples you have used Set @dbname= 'database name'.

I am taking this input from Stored procedure input. How can you help?

Dynamic Script means , In only one stored procedure I can grant access to required object. It may be Table, schema,view or stored procedure.

Steps

1. It will verify if...

Hi Bhavesh, Looks like you are connecting to machine via citrix where SQL server is installed .

You can simple take copy only backup in case if it is PROD,...

http://www.sqlservercentral.com/Forums/Topic1089382-147-1.aspx

You can simply Put 10 Steps in single job. (Assign steps 1 to 10 as per sequence needed).

In case any step failes in this scenario rest steps will not execute...

You can create Stored procedure for restoring, with parameters , dbname and path. Best way, you need to pass paramaters and execute SP.

using powershell script you can get that data.

What is the exact requirement? Number of error logs is important or error log content. I think you can search using keywords like 'error' and 'fail'

Thank you Very Much. It worked.

Thanks I got what was missing. Thank you so much.

Andreas.Wolter (9/18/2013)

---

With high lock wait times, you MIGHT have a chance by checking the system_health Extended Events session - if you are on SQL Server 2012. Because in 2012 onwards...

Hi Gail.... this is just context.... I mentioned about one session here .....apologies...

I mean if...

No one have any ideas 🙁