You can add the Service NT Login to your SQL Server Login and give appropriate permission.

Good article.

I would say VWWare can be used in the testing environment, but not in a production Environment. Especially if you have very busy DB's.

Kishore.P (12/10/2008)

---

Gauthama Kolivad (12/10/2008)

---

Using the same DB... I mean without using backup ... we cant restore a stored procedure to the previous version.

As Gail Shaw mentioned if you have...

In our env as well it is usually three stage but if I am lucky, the scripts go through 4 stages. Development, Pre-deployment (Where deployment is tested with Merging of...

There will be an impact on the proc basically because more resources are used while taking a back up. IO is higher, CPU might be higher. So there will be....

We use Surround. it has its own issues, But still it is usable. Serves our needs.

In our instance, We do not keep Physical DB. It is kind of difficult to maintain since ours is Inhouse development and every week some Changes are made. Either new...

Matt, You explained it better than me. 🙂 I always knew that I did not have the ability to explain what is in my mind properly. Now you have prooved...

Jack Corbett (12/9/2008)

---

Roy Ernest (12/9/2008)

---

That is going to be tough. Truncate table does not make any entry in the Log file if I am not mistaken. Do you have traces...

Steve, The Source Control that we have can actually Merge by itself. When you rebase the Braches, it will make sure to make the additional Changes needed (Add code or...

That is going to be tough. Truncate table does not make any entry in the Log file if I am not mistaken. Do you have traces running that you have...

You could also try SQLH2 and Performance Dashboard tools.

Hi ,

let us say that you have a Sproc 'x'. This was later on identified as a bug. The developers are actually working on another version of the software....

In Your DB you can have only one version of an Object.

You have been talking about the versioning the Physical tables. Do you mean with the Data inside you...

You should ask your Server Admins to move the PageFile from C Drive to to either D drive or E drive. C is the OS drive.

Also it does not hurt...