Thanks

Hi there,

I used a script to changed around 60 cust-test DBs from Full to simple recovery model as they were not needed to be in Full recovery mode etc

I did...

it works fine for me using it on 2005...post your errors..

I think while this is a good script...the build it report for max storage used by tables is faster if you needed a quick look..

of course the query can be...

Nice post geoff. Does anyone think using DBmail hence getting your sql server to send mails, is a security risk?

At my current place we seems to have .net utility...

Sorry this wasnt part of Brent's reply:

No matter how much training material you have until you work on a real BI project its not good enough but I guess you...

I posted this at:http://www.brentozar.com/archive/2009/03/should-i-specialize/#comment-48578%5B/b%5D

Do DBAs think that lot more 3rd party tools (specially on a troubleshooting side..back/restore etc) like redgate, idera, lightspeed would lessen the need of a...

Msg 8152, Level 16, State 2, Line 8

String or binary data would be truncated.

The statement has been terminated.

(0 row(s) affected)

Get above? Any idea. running in 2005

Tested individual statements and they...

Really good article. I guess list could be end less as the time pass by requirements or usage change. But at least when you just been handed a...

Sorry for the delay but I have sorted this using a store proc utilising dynamic sql. It wasnt that hard to be honest. Its been deployed in our prod...

Hi all,

Thanks for your support and useful links.

We are using enterprise edition. Just for your info we found some logic issues with Application side. It was using log4j ...

I mean only give access to selected schema not to all.

Also give db_owner...should it make diff as I just want the user to be able to read/write not own it...

I created a local User Test1 on my local machine just to test some schema settings. Then I added the user in Logins at the Sql server instance level....

You may find the following references on SQL Server Memory Management useful:

http://technet.microsoft.com/en-us/library/ms189334.aspx

http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778(v=vs.85).aspx

http://support.microsoft.com/kb/283037

http://msdn.microsoft.com/en-us/library/ms175581.aspx

- i THINK the first and...

May be try BI route to add spice to your role..or if you that good open your own consultancy...

Does it matter if you making decent leaving as Prod DBA? ...