xp_cmdshell does not generate any text file in itself, but you run something from xp_cmdshell that generates a text file.

You could just as well as run the same thing from...

It seems like you want to create a user that should only see the databases on the server it has access to. This is unfortunately not possible. You can make...

So what does this team need to do, which is not covered by db_securityadmin and db_accessadmin? Without this information, your question is somewhat difficult to answer.

I note in Books Online...

They are all coming on the port on which SQL Server is listening on. You can see this in the SQL Server Configuration Manager or in the beginning of the...

Erikur?

If SQL Server is only serving the web server, it's simple: make sure that only ports 80 and 443 are open in the firewall. And particularly, make sure that the...

You should be concerned, and you should not expose you SQL Server instance on the internet. As long as it is, you should keep the sa account disabled. Renaming it,...

So there is something you are not telling us. Here is a script that you can play with, that shows how it works with DB_CHAINING. (Note that you don't need...

For DB_CHAINING to work the two databases must have the same owner.

For TRUSTWORTHY to work, the databases must either have the same owner, or the owner of the database where...

Andrew Kernodle (8/5/2014)Unfortunately, I'm not quite sure how to prohibit him from doing this. I've revoked the sysadmin role on his login (he doesn't need that much access anyhow),...

Add the user to db_datareader, and grant the user VIEW DEFINITION on database level:

GRANT VIEW DEFINITION TO nisse

Note that this gives the user right to see any definition in the...

No, sequences and IDENTITY behave the same in this regard:

CREATE SEQUENCE MySeq...

Jeff Moden (8/2/2014)

---

I agree that SEQUENCE has the advantage of being able to cover multiple tables and that IDENTITY requires SET IDENTITY INSERT if you want to update the identity...

Jeff Moden (8/2/2014)

---

The best thing to do is to NOT try to write your own NextID sequencer. Use IDENTITY or SEQUENCE They won't let you down except for...

Beware that sequence can give you gaps....