Here is a feature that I have been waiting for since I started working with SQL Server 6.5: the ability to script the data from a table. When you deploy a SQL Server database, you often need to ...

It's SQL Server 7.<P>It's a few development databases, and there are 3 people that may make changes throughout the day. I'm not exactly in charge, but I don't trust the other two people that are ...

So, I'm trying to update an sql script we use for dumping databases. I want to add a shrink to the script but it's not working and I don't really understand why. SQL is not a strong point for me. The ...

How do I assign permissions to users to see SQL Agent Jobs? Your email has been sent You can give your users rights to check if reports have run or jobs are complete without granting full admin rights ...

When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 R2 evaluation to the free Express version, I ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

It appears that the long wait for SQL Server 2005—the successor to Microsoft's renowned SQL Server 2000—will be well worth it. SQL 2005 promises to be a polished, powerful product with significant new ...

SQL development is evolving fast, and Microsoft.Build.Sql is leading the charge. This next-generation SDK brings flexible project structures, better source control integration, automated build-time ...