If you make the change in SQL Server Configuration Manager, all the permissions will be assigned automagically.

John

If your database is 500MB, then the ideal memory grant should be about 582776856 bytes, not KB. I don't know what's going on there. How much memory do...

Start here: RESOURCE_SEMAPHORE[/url].

John

Do you have a third-party monitoring product such as Solarwinds or SQLMonitor? If so, you should be able to get the information from there? If you don't, do...

(1) Yes

(2) No, except as in (4) below

(3) No, unless that account runs any other services on the same computer or another computer

(4) Yes. I'm not sure whether it...

Go to a command prompt on the server (or use xp_ cmdshell) and type [font="Courier New"]net share[/font].

John

Take a look at this[/url]. Looks like you haven't got your LDAP details all present and in the correct format.

John

Sam

You can't filter on that, as far as I can tell. Why not filter out the rows you don't need from the destination table instead?

John

You can install it on its own - it's a separate product from SSMS these days. If you're installing on a PC, it needs to be Windows 10 (or...

james.h291183 (1/6/2017)

---

Dot is fine....I'm in the UK 🙂

At the moment it is just connecting, I reckon I could do the restore once I am beyond that.

I'm a bit confused as...

You'll need SQL Server Management Studio (SSMS). Point it at the local version of SQL Server 2016 that you mentioned earlier. When you've connected to that, you'll be...

RESTORE. Or use the GUI in SSMS. I recommend the former, since you can tweak it more easily...

You don't need to loop. I've shown you how to do it without looping. Loops perform badly because rows are inserted one at a time instead of all...

You can't run without error in SSMS. No way. First, you're missing a chunk of lines in your SELECT INTO statement. Second, your INSERT statements are trying...

You could create a server-level trigger to fire on the CREATE_DATABASE event. Or you could periodically query sys.databases to see whether any database has a create_date less than a...