What a nice tutorial, just what I was looking for, but.  Can someone please explain this example to me? I understand what the code is trying to do, but when...

From and Oracle DBA perspective (I've been with Oracle since late 1980's - Oracle and UNIX will always be my first love) I think SQL Server is doing a pretty...

Ah, found it, THANK YOU 🙂

Sorry, I found the answer to my question, ignore this.

Hello,

Thank you all for responding. After a bit of digging and raising a call with Microsoft it turned out there are other things involved, as this is...

Hello,
I appreciate all the help I am getting  here,  my new test server sys.servers show the new server with test details.
Columns values are:
Name = SpacemanTest

Thank you all for your answers, I'll have to dig into the subject thoroughly. Infortunately due to the fact that the power user who is creating tables creates them so...

Hmmm, I created a new test database (being an admin). I create a new user, let me call him XXX. The only thing I see in the properies is the...

Hello,

Thank you for your answers , you are all most helpful.  I'll look into giving just CREATE TABLE permissions and a more granular approach.

Kind Regards,

How about using "bcp" which is an export/import tool?
You still have to disable triggers, truncate tables before you do the import.
You can however pick and choose which tables...