Viewing 15 posts - 8,686 through 8,700 (of 9,253 total)
configure the min value to be a sensible value other than zero but not higher than max
December 7, 2008 at 2:36 pm
in the interests of database\referential integrity don't re use them. As stated, if you're needing to re use the column it probably shouldnt be a PK.
December 7, 2008 at 2:58 am
George Dickson (12/4/2008)
OK, thanks! I guess I'll get started uninstalling and reinstalling.
backup and save your system databases first if you have already created logins, databases, etc
December 6, 2008 at 8:32 am
dva2007 (12/6/2008)
sorry forget to mention 32 bit.
as Ken stated x86 is the version you require
December 6, 2008 at 8:29 am
Barkingdog (12/5/2008)
drive C: OS, pagefile
drive D: tempdb
drive E: log...
December 6, 2008 at 4:20 am
begs the question, what other apps are running on these sql servers?
December 6, 2008 at 4:14 am
nick harris (12/5/2008)
So to list out the current spns I should use
SETSPN -L against what server? My domain controler or my database server? If...
December 6, 2008 at 4:08 am
dva2007 (12/6/2008)
Windows Vista Home PremiumService Pack 1
32 bit or 64 bit?
December 6, 2008 at 4:04 am
dva2007 (12/6/2008)
i have got sql server developer edition which is having different types.
SQL Server Itanium
SQL Server x64
SQL Server x86
I have got Windows Vista Home on my machine. Which...
December 6, 2008 at 3:46 am
there do seem to be problems with services running under domain accounts not registering their SPN's, local system works fine.
SETSPN -L
should list all registered SPN's (not just for sql server)
use...
December 5, 2008 at 12:54 am
a warm server should show very different memory usage
if you've only just started it, monitor for a week or so
December 5, 2008 at 12:46 am
how big is the database?
you could use SQLExpress 2005 if its under 4GB
December 5, 2008 at 12:44 am
from BOL
Logical and Physical File Names
SQL Server 2005 files have two names:
logical_file_name
The logical_file_name is the name used to refer to the physical file in all Transact-SQL statements. The...
December 4, 2008 at 12:32 pm
the logical filename is generally used internally by SQL server, changing it to something different after copying the database is something i would defintiely do.
December 4, 2008 at 12:07 pm
Viewing 15 posts - 8,686 through 8,700 (of 9,253 total)