I'm building an automated build procedure, one of the steps is to create a database and it's structure/procedures/functions etc.<BR><BR>Clearly I can script the entire db creation job in sql and use ...

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 ...

JetBrains, producer of numerous development tools for a wide variety of coding projects, is set to release an advanced editor for SQL management. The company already has a number of plugins for its ...

In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...