Why bother with the dll's?

SELECT SERVERPROPERTY('ProductLevel') = service pack level

SELECT SERVERPROPERTY('ProductVersion') = build revision

SELECT SERVERPROPERTY('ProductLevel')

Thanks Jeff ... unfortunately getting the following:

EAccessViolation - Access violation at address 00403E7A in module 'slssqlmaint.exe'. Read of address 0000000F

D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\slssqlmaint.exe Process Exit Code: 1 (Failed)

Msg 50000, Level...

Sure about that? 2008 doesn't use IIS ...

Perfect, thank you! I will try this out shortly.

Wrong KB article?

BUG: File growth value for the tempdb database is not persistent when changed from fixed increments to percentage

Ok, nevermind ... just had to hit F7.

Oh my ... I was looking at the wrong page. I was looking at upgrade paths for 2008! By not seeing any supported upgrade paths for 2005, I was assuming...

Hey Terri, any thoughts on how to add some better logic in by randomizing the deptname a little better to avoid same deptname groups (teams)?

Thanks

No problem, glad it worked out for you.

Oh wait, no login at all works? Than what Nikhil said is correct ... the account which is running your SQL Service is the problem.

Sounds like the login has a default database which no longer exists, is not accessible, or that user does not have permissions to. If you have a different account you...

Junior_DBA (10/3/2008)

---

Adam,

It worked, thank you for your time....

I reinstalled from scratch, and now it looks is working ok....but I have a doubt........in the future, to not do the same disaster....how...

Just tossing out my past experience ... At my previous job we implemented several ESX clusters, and the performance was absolutely amazing for SQL Server. We bench marked several applications...

Junior_DBA (10/3/2008)

---

Can I run everything from the beginning , but delete all the folders, all the files...and everything....like nothing in muy computer with SQL server???

WOuld you mind telling me how...