I am having this issue as well with the "SQL 2012 - General" forum (RSS). It does not seem to matter whether I am logged into SSC or not.

When not...

Do you mean you checked the Unicode box in the SSIS File Connector?

That checkbox is a shortcut to use UCS-2 encoding. You...

The commands are synchronous so they will not return until...

I had some of this scenario too with inheriting DBs created in 2000 but now on 2005, and I enabled CHECKSUM. It's a DB engine feature that has no logical...

SKYBVI (3/28/2012)

---

opc.three (3/28/2012)

---

Oh no, it does not work that way. The executable will always run in the context of the operating from which you call it, not on which you...

Now that, you...

I understand, that is why I asked if you were...

Eugene Elutin (3/28/2012)

---

Where I've said that?

Even, with...

jokesbox_mail (3/28/2012)

---

Thanks for your replay, the whole idea is to refresh all the databases from the production server but locally, so any developer can run the script and refresh their...

Oh no, it does not work that way. The executable will always run in the context of the operating from which you call it, not on which you call it....

The public Role, by default, does not have permission to insert or update tables or views. Did someone change the default permissions, granting things specifically to public?

Try this:

DBCC SHRINKDATABASE(database_name, NOTRUNCATE);

Then try shrinking it again.

What command exactly are you using to shrink it. Any error message?

You're welcome.

Have you looked at upgrading? Compressed backups may help you.

More work, but you could also try spreading you index rebuilds out over time so your log backups do...

Eugene Elutin (3/27/2012)

---

...

Why would you want to cache ranges of keys when using Guids? Makes no sense at all. The main reason for using guids if allocating keys in the...