Marios Philippopoulos (2/13/2008)

---

Create as many tempdb data files as there are processors. Create them equally sized so that they take up pretty much the entire tempdb drive - perhaps with...

free_mascot (1/31/2008)

---

I have not much exposure of VMWare.

But if we think logically I won't perfer to run production on VMWare on follwoing ground:

1. It will share the resources like...

It doesn't error it just creates the table with username as schema which is not very useful, doesn't seem to pass through the specifying of schema.

There are just the standard...

User connecting using Windows Authentication, user is member of db_owner so database permissions should not be an issue.

User does get permissons via a Windows Group but this doesn't stop it...

Hi ALZDBA,

Default schema is dbo, and am specifying schema of dbo in create table command. Everything else seems to work same in OSQL and SSMS but only way to...

Ken,

Are you using a DNS entry from the App to SQL Server? Are you using same DNS entry as previous db server used (for minimal impact to users you've...

I had this problem when installed SQL 2005 SP2 - it defaults back to C:\Program Files\etc for the system db files, so if you've moved master,etc it will fail when...

Keep sa as dbo because never know what issues will arise from it not being set, especially if login assigned becomes obsolete. Also I've come across some functions such...