Webinar: Whatever your source control system - seamlessly link it to SQL Server

In this webinar consisting of 30 minutes of software demonstrations followed by Q&A, you will learn how to link your database to your existing source control system within SQL Server Management Studio using Red Gate’s SQL Source Control.

We will also give you an exclusive preview of forthcoming custom scripts features in the next version of SQL Source Control and SQL Compare.

SQL Source Control Webinar 11 - Whatever Your Source Control System - Seamlessly Link it to SQL Server

In this free webinar you will learn how to effortlessly source control your database using SVN, TFS, Vault, Vault Pro, Perforce, Mercurial, GIT, and Bazaar to name just a few, in fact any source control system with a command line. See how to download, install and share changes in under 5 minutes.

The One True Script

Phil Factor less-than-fond memories of the days of the One True Source Script. However, despite recent advances, he wonders just how much smoother team-based database development really is.

Database Source Control- The Crib Sheet

As part of our long-running Cribsheet series, we asked William to come up with a brief summary of what was involved in bringing database development work under source control. What are the advantages it brings, and are there disadvantages?

Automate the Publishing of Data Changes into DML Scripts

For those of you still using SQL Server 2000, learn how to use SQL-DMO to create DML scripts to deploy new records or data changes to other servers. From Oscar Garcia.

Deploying Databases From Visual Studio Team System Database Edition

With the GDR release, a whole new set of deployment functionality has become available to VSTS: DB.

Lightweight source control

Versioning for Stored Procs and view

Table rowcount

Does any one have a script handy that gives you the rowcount of all user tables on a database. I have one but it gets the result from sysindexes which sometimes is notuptodate. Also I wont prefer anything witha  cursor as that might slow down the server. any scripts other than these two.Thanks

RE: what log does what?

Have you got the -m startup switch set on the sql server in question? (Right click on the server name in EM and choose properties. Then startup parameters)

RE: Error-Database connect using dynamic SQL

If it needs to be dynamic sql, put everything in one string and execute this. Something along these lines:DECLARE @stmt NCHAR(1000) SET @stmt = 'USE Frank_3 '  + CHAR(13) +  'DECLARE @stmt NCHAR(1000)'  + CHAR(13) +  'SET @stmt = ''CREATE TABLE First (col_a int)'''  + CHAR (13) +  'PRINT (@stmt)' EXEC sp_executesql @stmt SET @stmt […]