Getting started with SQL Server | Forum profile

Hello,   Please, could you have a look on this link ? http://msdn.microsoft.com/en-us/library/at8a576f.aspx   You should find some ideas to "dig" for the use of SqlDataAdapter ( i suppose that you are using Sql Server )   Don't hesitate to post again for more help or explanations.   A little advice : this question would be asked on the Sql Server Data Access Forum...

Yes, per user licensing will use all available sockets on the machine, up to and including the maximum for your edition of SQL Server.  It's generally preferred for sites with fewer users.  Per processor licenses unlimited users for one processor socket only...you need to license each socket individually.   Does this help?   Aaron Alton

Finally. Strategy 2 worked. Upgrade went without a hitch. Unfortunately I have to add the services not provided by 2000 separately, such as Reporting Services, but at least I can connect and log in to the server.   Gary  

Question answered.  The Walthrough added the AdventureWorks sample database to App_Data folder. Therefore, only this user database under the Database Explorer was modified, not the database at the local SQL Server folder.    What is the purpose for adding a database into the App_Data folder of the Visual Studio? 

Here is the point !! i have to shutdown the passive node in order to launch sql setup. Otherwise it always fails !! Once int the checking screen, i switch on the second node wait until it's on and continue the install. But the pb is that I cannot select the second node during the setup process..... I think that this kind of pb is about my VPC cluster config......

Hello, I did it, that's why i know all my 16 cores are normally used, in this page i used automatic processor affinity and i/o affinity. But in the task manager as in other system mangers, i see that 1 core on 4 is very used and the other three not. Your terms are clear moreover i'm french. Do you know if there's something to change maybe on my windows 2003 server configuration? Thank you Have a nice day as well.

I was wondering, is it possible to say we have 3 columns, the 3rd being not null.  If I enter a value for the first and second, I want it to automatically lets say add up 1 and 2 and put the value to 3. I don't know if it is possible, but if it is that would be nice.

Hello  all,   I am facing a weird problem (or I don't know if is  commonly faced  ) I am doing a bulk upload of my excel data using OPENROWSET keyword (SQL 2000) At the end of the excel sheet there are few empty rows. These rows are getting added as null rows in the table. How can this be avoided?   Thanks Rach.

Well, I wiped it all out and installed 2005 Express and MSEE and it is up and running...even with my data on a different partition.  I am not sure I want to risk breaking it by upgrading to 2008 Express.  Maybe in a week or so when I have some free time.

If you are using a non-default port you have to either specify the port you are using, or ensure that the SQL Server Browser Service is running. [Ajmer Dhariwal MCITP, MCDBA, MCSA & Sybase certified dba | Blog at http://www.eraofdata.com]