Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | razmac55Starting Member
 
 
                                        1 Post | 
                                            
                                            |  Posted - 2009-06-02 : 09:22:06 
 |  
                                            | I am very new to SQL server and haven't even installed it yet.I have to setup SQL server 2005 and will probably install on Windows 2003 server on a virtualised 64 bit machine.This will be used in conjunction with a machine running Opentext version 9.0I was browsing the net and noticed that some people had issues and some advisod to lock pages in memory for 2005.Are there any issues or advice that anyone can give me before I get started? I have to get this done fairly soon.Thanks in advance,Ross |  |  
                                    | SwePesoPatron Saint of Lost Yaks
 
 
                                    30421 Posts | 
                                        
                                          |  Posted - 2009-06-02 : 10:04:21 
 |  
                                          | The "Lock Pages In Memory" option is not an issue. It's a feature to make sure no pages are flushed to page file.Also note that xp_sendmail is not available in x64/ia64 environment. E 12°55'05.63"N 56°04'39.26"
 |  
                                          |  |  |  
                                    | sodeepMaster Smack Fu Yak Hacker
 
 
                                    7174 Posts | 
                                        
                                          |  Posted - 2009-06-14 : 12:00:31 
 |  
                                          | How much memory do you have for your server? |  
                                          |  |  |  
                                    | afrikaMaster Smack Fu Yak Hacker
 
 
                                    2706 Posts | 
                                        
                                          |  Posted - 2009-06-15 : 17:29:43 
 |  
                                          | we run a 64 bit win 2008 Server as our primary server, when we tried to install SQL 2008 it gaves us pure headache.We later found out that, to install it. You have to run setup from command prompt and set the path for both the program files and data files.Apart from that, installing it, is a walkthrough like other versions. |  
                                          |  |  |  
                                |  |  |  |