Viewing 15 posts - 8,671 through 8,685 (of 9,241 total)
Lynn Pettis (12/9/2008)
Are you clicking on the Execute button or the Parse button.
which button are you clicking to execute the script?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2008 at 2:06 pm
exec sp_change_users_login 'Update_One', 'Current user in DB', 'SQL login to link to'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2008 at 6:24 am
herbiechin (12/8/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 8, 2008 at 4:00 am
configure the min value to be a sensible value other than zero but not higher than max
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 7, 2008 at 2:58 am
you sure its not dis appearing ink LOL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 7, 2008 at 2:41 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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2008 at 8:29 am
Barkingdog (12/5/2008)
drive C: OS, pagefile
drive D: tempdb
drive E: log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2008 at 4:20 am
begs the question, what other apps are running on these sql servers?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2008 at 4:08 am
dva2007 (12/6/2008)
Windows Vista Home PremiumService Pack 1
32 bit or 64 bit?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2008 at 12:46 am
Viewing 15 posts - 8,671 through 8,685 (of 9,241 total)