• Upgrade SQL 2005 Cluster to SQL 2008

    We have a remote SQL 2005 server set we will be replacing with a Windows 2008 Cluster. The db supports a 3rd party app. The app has not completely endorsed for SQL 2008. If I build an active/passive cluster with SQL 2005 on Windows 2008, is there the ability to upgrade the sql server to a SQL 2008...

    tcstl95 pointsBadges:
  • Upgrading SQL Server 2000/2005 to 2008 with VMWare and EMC SANs

    Has anyone ever seen a White Paper on the best way to utilize features of both VMWare and EMC Symmetrix based SANs in a real-time or rapid batch based upgrade from SQL Server 2000/2005 to SQL Server 2008 with minimal downtime for application availability?

    SQL2K8Dude5 pointsBadges:
  • SQL Server 2005 or SQL Server 2008

    I have been trying to learn SQL 2005 from like a month or two and i think I have done a good job. Now I was about to try some security stuff in it but I saw that SQL 2008 is in market. Can any body suggest me that what is the difference between the two and can I switch to SQL 2008? What ever I...

    JrSoftwareDeveloper5 pointsBadges:
  • SQL Server Data Files and Threads

    I am reading a Microsoft Press Book MCTS Exam 70-432 and in chapter 2 it talks about Data Files and it says "SQL Server creates a thread for each file underneath a database. As you increase the number of files underneath a database, SQL Server creates more threads that can be used to read and write...

    Rick Martinez585 pointsBadges:
  • Page level lock in SQL 2008

    What is the meaning of page level lock in Microsoft SQL 2008 enterprise edition? How many records are locked?

    Akansha150 pointsBadges:
  • SQL processor license

    On a physical server we select 2 processors. We then select SQL 2008 STD 1 socket license. since the server has 2 processors, can we assign SQL to only processor and run? If we can, can the second processor on the server be used by the OS on the server?

    Enterprises5 pointsBadges:
  • SQL 2008 system tray icon

    How can I add a system tray icon for SQL 2008 just like SQL 2000?

    Saga10 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • How to change datetime values in SQL Server?

    I want to present a datetime value without hours, minutes or seconds in SQL Server 2008? Would this code work?Statement @SomeDate datetime = '2013-09-18 16:30:22' select trunc_date(@SomeDate) ----------------------- 2013-09-18 00:00:00.000

    ITKE1,051,735 pointsBadges:
  • Impact on application after upgrade from SQL Server 2005 to SQL Server 2008?

    What would be impact/changes to be done in my application which is using general SQL for upgradation from SQL Server 2005 to SQL Server 2008 ?

    Vht5 pointsBadges:
  • Free Chapter – Beginning Spatial with SQL Server 2008

    Another free chapter download is available on the IT Bookworm Blog. Written by: Alastair Aitchison Book: Beginning Spatial with SQL Server 2008 Overview: "Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the...

    BrentSheets6,940 pointsBadges:
  • Database Newbie

    I'm quite new to database security and MS SQL server 2005 and 2008 and was hoping to find some extra sites or books to help as I am currently writing an application to send OS info and service tags to our SQL server. I obviously can t have the SQL server directly on the internet with an open port...

    Neutrino90 pointsBadges:
  • Integrate MOSS with SQL Server 2008

    Can someone provide a step-by-step or point me to a guide for integrating MOSS with SQL Server 2008? Thank you very much. Moderator Note: This is a submitted question

    BrentSheets6,940 pointsBadges:
  • SQL Server Fails to Start When Moved to Different Node

    Sql 2008 R2 on Windows 2008 R2 cluster. When I move instance from node 1 to node 2 everything is fine: all resources come online as they should. When I move the instance from node 2 to node 1, all resources except sql server and agent come online. If I delete errorlog and start the sql server...

    Spadasoe5,130 pointsBadges:
  • SQL server 2008 downgrade to express

    Due to our budget we are being forced to downgrade some servers from SQL server 2008 R2 to Express. Was told it 's a saving of 20k per PC.Are there any issues that we need to know that may cause us problems? I know Microsoft does not make downgrades easy.. If anyone could shed some light I'd...

    ToddN200089,355 pointsBadges:
  • Moving SQL Server database without affecting VB 6 code

    I am using VB 6 code with Microsoft Access database. Now I want to move to SQL Server 2008 database without affecting my VB 6 code. Any suggestions?

    vikasjains20 pointsBadges:
  • Installing SQL Server 2008 and VB 6 on the same PC

    I have 1 pc.3 drives-c:,d:,e:. Now I want to install SQL Server 2008 and VB 6 on the same PC. Mean to say Can I make use of SQL Server 2008 with VB 6 on same machine?

    vikasjains20 pointsBadges:
  • My database .mdf file got corrupted in SQL Server 2008

    My database .mdf file got corrupted and I have no means to get my schemas. I tried with a few softwares available on the internet but its turns out that with all of them being demo versions, I don't give back the repaired file. Is there any other means by which I can restore my db? I am using MS...

    mjozekh5 pointsBadges:
  • Crystal Reports 8.5

    I have a report that uses SQL 2008 database. It is a money field. I do not want the decimal or the $ sign to show. If it has cents like 1.50 I want it to appear as 150 if it is just 1.00 I want is to be 100. How do I accomplish this?

    llplora10 pointsBadges:
  • Best value for fillfactor in SQL?

    What is best value for fillfactor in SQL?

    mukeshkumar1230 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following