This is correct and I have already pointed this out to you. You may also be able to identify the data row using the RID.

You should also be able to...

What are you seeing when you try to make the update? Is the step name greyed out and read-only or do you get an error? The first is probably permissions...

First of all, I saw that we have Amazon RDS for SQL Server.

Regarding script for index maintenance (https://ola.hallengren.com/) it looks like the same as what I want...

There are two parts to this conundrum:

• identify when a row has changed
• extract the data into a format that Oracle can process

There are many ways to identify when a...

You may be able to overwrite or repair the data providing you have a backup, including TLog backups, that does not have this issue when restored and a DBCC CHECKDB...

Hi Tom.

You are free to implement a solution that best fits your circumstances but one account for all instances is not one that I would recommend.

Microsoft's recommendation for standalone Instances...

MarkThornton (9/25/2013)

---

The answer seems to be as follows:

1) In Login Properties, click on Securables

2) Choose the relevant Server as a Securable

3) grant my colleague the Permission to "view any definition"

This...

schleep (10/15/2013)

---

Hi 360,

I'd originally hoped to use nested AD, but my domain admin tells me "that ain't gonna happen" due to trust issues.

At no point is any of this being...

Jerry.

Check out Gail's link.

I recently had to deal with a subscriber database, in simple recovery, that thought it was a publisher. It was not allowing the transaction log...

Hi Philip.

One of the big uses of instances to to isolate SQL server installs for administrative, versioning or patching considerations. It can be a big headache to administer but there...

Many thanks for the feedback.

The user is indeed an SQL one, this was created as a test user after the database had been restored. This was an attempt to remove...

You can always run this as an SQL job. You can then vary the batch size (in the script) and frequency (how often the jobs runs). This is also restartable...

The link below has a comprehensive looking script which may give you the answer you are looking for.

Can I suggest that you do not assign permissions to a user but...

You could run DBCC CHECKDB against the database after you have performed one of your routine test restores.

Mine's the coat with the Kevlar back protector in it ... :Whistling:

Paul White NZ (8/13/2010)

---

The shrink routine is pretty simple - essentially, it just moves whole pages from the end of the file toward the beginning, to free up space at...