lsalih (6/3/2014)

---

The way I would go about it is by generating create script of the linked server in a new window, modify the script to include the modification you need,...

HanShi (6/4/2014)

---

The file extention MPMP is not a default SQL extention, so probably it is generated by some other process. Can you see who created (is owner of) these files?

Perhaps...

I assume this is related to your other post in SQL Server 2014 Administration? Please don't cross-post. It would have been useful if you had mentioned that you are running...

imranalaskar (6/3/2014)

---

Thanks..but I have all my registered server in my SSMS and I want to directly execute the query which will change the page_verify option of all the servers in...

You could also used Policy-Based Management to check on a scheduled basis (or an ad-hoc basis) for databases that do not have the desired setting for 'Page Verify'.

Regards

Lempster

Sorry, I misread your post, but don't the backups get created with .bak extension anyway?

With regard to shrinking databases, I don't know why your boss has that as a requirement,...

Kevin,

Microsoft always used to state that one should only apply a particular CU if one or more issues addressed by that CU were being experienced...pretty much in line with the...

That's what 'deprecated' means!! I didn't say that mirroring is not...

One thing to be aware of is that Database Mirroring is now deprecated. I'm not saying don't use it, but that Microsoft intend to remove it in a future version...

What are you using as a column delimiter and text qualifier?

Regards

Lempster

I don't know the reason for steps not being executed, but I do question why you are doing some of those steps anyway.

1. Shrink databases. Not a good idea...

I'm stating the obvious, but does the account under which SSIS is running have permission to access that file? Do you (or someone else) have the file open in Excel...

Yes, sorry I wasn't very clear. I know that moving from Profiler to Extended Events is quite a jump so I wanted to point out a GUI add-in is available...

ihpk74 (5/21/2014)

---

so you are saying i CANNOT use EXEC [DATABASEname](which is a variable in my case).[schema].storedprocname

it. it supposed to be two different execute sql tasks separately it won't be dynamic,...

Hi Grant,

Plug-in might be the wrong term then, but I'm sure there is something available that brings the Extended Events GUI into SSMS. Maybe it's just the Extended Events node...