Matt, I am not sure how you would state that the result depends on where it is being run from.

As per BOL:

ComputerNamePhysicalNetBIOS

NetBIOS name of the local computer on...

SQL Server will "see" the new processor upon restart.

You will though, have to make sure you are in compliance with the SQL Licensing in place. If it is...

Matt-1034261 (12/30/2009)

---

GilaMonster (12/29/2009)

---

Looks like you're trying to restore over the existing database. Don't. Drop the corrupt database and restore the new one from scratch.

Post the restore command that you're using.

Do...

That's indeed a solution, as you now have the alias pointing to the named instance, but originally, localhost would only work if you have a default instance and no named...

because you have a named instance.

'localhost' by itself will connect you to the default instance, not a named instance.

If the output of the PRINT is just a blank line, then one or more of the variables contains a NULL, as Mike stated above.

You probably would have to use...

The indexes have to be "big" enough to be actually rebuilt. I can't recall now what the threshold is, but I believe it was something about 8 pages or so...

Piotr... I guess with TRUSTWORTHY ON it now works as expected between databases... 🙂

Thanks...

On to getting this work across servers.....

Piotr.Rodak (11/9/2009)

---

@piotr: yes, but with the EXECUTE as you enter the realm of the permissions and how they are chained. Imagine any user was able to use execute as a...

Lowell,

thank you for the example.

i don't think we have tried with 'dbo' as the execute as user, but then again, in your example the table that...

@ben: would you mind sharing the exact steps setting it up, users and access? As explained in my original post, that's what we did successfully on the test machine but...

The DB trigger is actually using xml, the issue I have though is making this work for "any" user....

Ronnie, you are correct... forgot about @@servername....

For it to take effect, you have to set it with

sp_addserver 'YourServername', 'LOCAL'

and then restart the SQL Services

(note: for some reason last time I had to do it, it only...

It depends on your server specs as well. Disk, although a major factor, is not all.

We have a 1TB DB that restores in about 2.5 hours and then another 10-20...