Viewing 15 posts - 8,671 through 8,685 (of 9,244 total)
if you use the upsizing wizard in Access it has the option to generate\configure an Access front end that you can then use to link to the SQL database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2008 at 1:13 pm
Phil Auer (12/9/2008)
I am, however, certain that I will always remember that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2008 at 5:50 am
check the following key in the windows registry
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2008 at 5:48 am
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
Viewing 15 posts - 8,671 through 8,685 (of 9,244 total)