Forum Replies Created
Viewing 15 posts - 6,106 through 6,120 (of 7,505 total)
-
RE: Having troubles accessing data after the upgrade to SQL Server 2005
First of all : don't panick
If you still have a copy of the sql2000 (or a backup of it):
have a look at
-
RE: sqlagent service doesn''''t running under a domain account
can you post the sqlagent.out file ?
All our sqlagent's are served using a windows account.
-
RE: Installation using INI file
you may want to have a look at :
i.e. SQL Server 2005's Undocumented Solution for Unattended Installs
-
RE: I can''''t allocate 7Gb of ram from a total of 8Gb
Aarch yes.... the hotfix is "AWE hotfix SQL2000-KB899761-v8.00.2040-x86x64-ENU"
KB904660 has more on the cumulative hotfix.
-
RE: Question about indexes
should be FASTFIRSTROW.
search for "table hints" in BOL
-
RE: Question about indexes
implicit_converts will indeed messup things.
rule 1 for any RDBMS : tell the system what you know !
SQL2005 can generate nice xml-plans which show you implict conversions !
<
-
RE: I can''''t allocate 7Gb of ram from a total of 8Gb
Would you mind testing what happens when you make it 8Gb or even 12Gb in total ?
-
RE: Installing Management Studio on my PC.
if it finds VS2005 installed, it can add the components for SSIS (format dts), reporting server apps and the olap dev stuff.
Else it installs it all if you choose so.
-
RE: I can''''t allocate 7Gb of ram from a total of 8Gb
another wild guess : how big is your pageing file(s) ?
-
RE: I can''''t allocate 7Gb of ram from a total of 8Gb
Is your /3gb /pae in the first settingsline of your boot.ini
Did doublecheck that this is the active line and that your server is started with these settings !
-
RE: I can''''t allocate 7Gb of ram from a total of 8Gb
Did you try seting MIN server memory as well as Max server memory to 6G ?
and then stop/start the sqlserver ?
-
RE: Question about indexes
jut to add ...
when you build your query in Query Analyser, you can check out the execution plan. (exstimated /executed)
(Ctrl+L or Query/display exstimated execution plan)
(Ctrl+K or Query/Show execution plan)
This option...
-
RE: Installation using INI file
on your installation disk, there's a template.ini file which explains all the parameters and has a couple of examples.
Yes you can add the parameters as you expected, but you'll also...
-
RE: Transfer SQL 2000 logins to SQL2005
you may want to try ...
select 'exec sp_addlogin ['
+ name
+ '],'
, password
, ', @encryptopt=skip_encryption'
from master..sysxlogins
run it on your sql2000
run the result on your sql2005
Be suspicious and TEST it !
-
RE: SA Fixed Server Role
No.
If you are authorized to be sysadm, you're internaly switched to sa.
sa has dbo-authority for the whole of the server/instance.
Viewing 15 posts - 6,106 through 6,120 (of 7,505 total)