SQL Server 2005's Management Studio offers lots of new functionality, but you can't always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install ...

Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

The built in "script data" tooling in SQL Management Studio 2008 R2 is broken for me because of spurious "cyclical foreign keys" errors. Plus the "generate scripts" itself has gone from clunky but ...

Yes, I'm currently working with Access. And boy thats fun. Is there a way to generate the SQL create script for a group of tables in Access and then run that against another Access database? The ...

In November, Microsoft released version 18.4 for the SQL Server Management Studio (SSMS), introducing some key features such as support for materialized view scripts in SQL Data Warehouse. It also ...