Monthly Archives: September 2013

SQL SERVER BACKUP Database Permission

When speaking about Permission term in SQL SERVER , It has two parts: Server Permissions Database Permissions And from another point of view, the SQL SERVER ROLE also has two parts: Server-Level Roles Database-Level Roles In fact the Security Model of SQL SERVER is a hierarchical … Continue reading

Posted in Best Practices, Database Administration, SQL General Information, T-SQL Tips & Tricks

BULK INSERT multiple Files in SQL SERVER Express

This post comes from this MSDN Forum question. Because of use SQL SERVER Express, we cannot use Integration Services(SSIS). Therefore, we  have two choices: BULK INSERT OPENROWSET(BULK…) In each statement you can insert only one column with above choices. Erland Sommarskog was … Continue reading

Posted in Database Administration, SQL General Information, T-SQL Tips & Tricks