Viewing 15 posts - 8,656 through 8,670 (of 9,241 total)
madhu.arda (12/11/2008)
getting free space in virtual memory is less.
it would be more important to try and ascertain what is causing the paging
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2008 at 5:07 am
ahenderson (12/12/2008)
gave permission to everyone.
your talking share permissions here right?
What "security" permissions did you set?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2008 at 4:58 am
vickiy (12/11/2008)
AWE only applies to Enterprise, doesn't it?
no, under sql2005 AWE applies to 32bit Std, Dev and Ent as does the lock pages in memory option.
http://msdn.microsoft.com/en-us/library/ms175581(SQL.90).aspx
Under sql2005 64bit only Ent...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2008 at 4:52 am
the white icons mean you do not have permissions on that server to manage the sql services (stop,start, etc)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2008 at 4:21 am
dont forget to carry out the post 2005 migration tasks.
run dbcc update usage and rebuild all indexes\stats
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2008 at 5:01 pm
attach the databases first as when the script is applied to add the logins it will fail as the users default database does not exist. Maybe it doesn't really matter...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2008 at 4:00 pm
Jeff Moden (12/9/2008)
... heh... or some very high velocity pork chops fired at point blank range. 😉
tee hee hee ROTFL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2008 at 2:24 pm
awp (12/11/2008)
I have decided to do a side by side installation:
undoubtedley the best way to go
awp (12/11/2008)
- script all the logins from sql 2000 instance and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2008 at 1:51 pm
the dis advantage of log shipping is that the best state you can get is read only, the database will be unavailable when log restores take place. Replication will produce...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2008 at 1:43 pm
dont forget to rebuild all the indexes afterwards too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2008 at 1:33 pm
run a repair on the .NET2 framework via add\remove programs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2008 at 1:24 pm
or just click start then run and type
odbcad32
then hit return 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2008 at 3:15 pm
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
Viewing 15 posts - 8,656 through 8,670 (of 9,241 total)