Developer Product Briefs Tricks for Processing SQL Scripts Discover how SQL Server 2005's SQLCMD tool can enhance your scripting processes. By Josef Finsel 05/01/2006 Tricks for Processing SQL Scripts ...

Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.

To generate SQL scripts from a data model, you need to select the data model or subset of it, specify the target DBMS that matches your database environment, configure the options and preferences ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...