(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...

Not working as in what - returns the wrong results, or gives an error? If the results are wrong, please provide in tabular form the results that you would...

I could ask you the same question. To verify the data that's going to be deleted, use the SELECT statement. To delete the data, use the DELETE statement....

Where are you connecting from? Are both nodes in the same subnet? It sounds like you need to ask your network people to sort your access.

John

When you attempt to connect, are you supplying the node name (or IP address) or the virtual SQL Server name? If you look in SQL Server Configuration Manager, what...