I am the only DBA/Developer at my organisation and I am currently looking after 7 Servers with several databases on each plus one large Data Warehouse. They never had...

I had a simalar problem on two of our SQL 2000 Servers. When I tried to shrink the databases through the EM it appeared to do nothing.

I...

Just for everyone's information:

You cannot use the VB or VBA function StrConv(strValue, vbProperCase) as suggested by paulhumpris as it is not supported by VBScript.

I ended up creating a User Defined...

I am wanting to convert to Proper Case.

I was wanting to be able to do this via a stored procedure as I insert rows into a table. ...

I have completed all my Microsoft exams (SQL + NT + W2K) by self study using the Microsoft Training Guides and the Exam Cram books. I found that the...