What are the implications of setting "READ_COMMITTED_SNAPSHOT" to ON rather than OFF (the default)?

I seem to recall looking into this before (ages ago) because it sounded attractive but I...

Hmm, I'd best go and have a look at that then. Thanks for the heads up there, at the moment I just changed the account it's using via Services and...

I've changed the service to from network service to a local admin account, I've then added this local admin account into SQL Logins and given it the sysadmin role, this...

Unless there's a more detailed SQL log somewhere the one from Windows Logs -- System isn't that interesting:

In the Application Log at 10:25:08

In the System Log at...

Hopefully, just trying to suss out how I can automate a database restore to a test database, looks like RESTORE DATABASE xxx FROM C:\.... would do it, wrapped into a...

Basically going to go down the dev route here, SQL Source Control from Redgate is what they use, think I'll give the same thing a whirl.

GSquared (1/18/2012)

---

There are a lot of books on SQL Server that would give you some insight into what you're asking for.

One great author on the subject is Itzik Ben-Gan. ...

SQL Kiwi (1/18/2012)

---

Rob-350472 (1/18/2012)

---

Thanks for the response Paul, specific to my situation I posted about. This is great but I was also looking for some sources of information on a...

Thanks for the response Paul, specific to my situation I posted about. This is great but I was also looking for some sources of information on a wider scale -...

SQLKnowItAll (1/17/2012)

---

In my previous company we used SQL Server Reporting Services (SSRS) on a daily basis. Depending on the size of your data SQL Server Analysis Services (SSAS) may be...

It may seem a slight tangent to what you're after, however, I watched about half of this yesterday:

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DBI334

At about 20-25mins in he speaks about Report Builder and the...

Robert Murphy UK1 (1/17/2012)

---

Check this out for using Visual Studio 2008 for database projects (I take it your not using 2010, as they made a few improvements there):

I guess the...

GilaMonster (1/17/2012)

---

Here you go...

http://www.red-gate.com/products/sql-development/sql-source-control/

Aside. Developing directly on the production server is one hell of a risk. Sooner or later a miss-type or other similar happening is going to cause major...

Thanks for the reply Rob. Subversion and Tortoise SVN are two names I recognise from the devs speaking about it so there's a good chance they're using them which is...

The devs that use the same live database do, but I do not. I believe they each have their own databases then deploy to the live database (the one which...