• XML Schema Problem

    hi I have an xml file <UserRoleConsumers> <UserRoleConsumer> <ConsumerID>67</ConsumerID> <RoleConsumerID>89</RoleConsumerID> </UserRoleConsumer> <UserRoleConsumer> <ConsumerID>45</ConsumerID> <RoleConsumerID>78</RoleConsumerID>...

    Dilipd0065 pointsBadges:
  • SQL 2008 R2 CPU Count

    The SQL 2008 R2 Std specification says it can use up to 4 cpus.  If I have two quad-core xeon processors.  Would this count as 8 or 2?

    LeeHerr15 pointsBadges:
  • Connect JasperServer and Sql 2008

    i tired these steps : # Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver # Extract to a good location. I chose c:program files to extract to. # Copy the sqljdbc4.jar to your installation directory which by default is: c:program...

    Edkettavan5 pointsBadges:
  • SSRS Dynamic Report Parms

    I am desiging a report to use several parameters. The first parm is report type. I need the other parameters to show or hide depending on the selection made to the first parameter. Can anyone help? Thanks

    Mgee165 pointsBadges:
  • Help navigating SQL Server 2008 database?

    Hi all, I'm facing an interesting challenge... Lets say: I have a payment coming in and of course my client has not specified which of the 45 open invoices he is paying. The amount does not match any single invoice so it has to be a combined payment for 2 or more invoices. Now, I can get my...

    Palloquin95 pointsBadges:
  • Answer a Question, Win The Official Ubuntu Server Book!

    At the beginning of the month, we gave away The Official ubuntu Book, and now we're giving away The Official ubuntu Server Book, Second Ed.! The book includes a DVD that contains the versions of Ubuntu Server needed for different CPU architectures. You also receive a code for a free online version...

    MelanieYarbrough6,345 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:
  • Error Message when restoring a SQL server DB in SQL Server Express 2008 R2

    This error received and cannot determine resolution: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 10240MB per database. The DB.bak file is 1.67MB

    Trackster209515 pointsBadges:
  • Service Broker downside

    I have service broker up and running accross 2 instances. If data is entered/updated on table A in instance A, it will send a message to the target queue and a stored procedure is used to read in the message and perform the update to table B on instance B. Once service broker is up and running,...

    Ndoan5 pointsBadges:
  • Updating SQL express to SQL 2008 R2 on server 2008 with sharepoint 2007

    At present we are running a Windows 2008 Server which has Sharepoint 2007 installed and houses our exchange server.  Apparently only the Express version of SQL server was installed initially and now the 4GB database limit is affecting our intranet. Have been advised that we need to update to SQL...

    Weboneau5 pointsBadges:
  • SQL Server 2005 & 2008 on a Cluster in Production

    Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because...

    Lorisj3325 pointsBadges:
  • Automatic backups for production databases without taking SQL server offline

    I need to automatically create backups of my 42 production databases every night without taking my SQL Server 2008 offline. Is this possible? A full backup and transaction backup so I can step back to the exact time I need?

    ITKE346,250 pointsBadges:
  • 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:
  • Master Data Services – Confused by mdm.tblStgMember

    Hi, In Denny's excellent blog on loading data into Master Data Services, he populated the staging tables as follows: INSERT INTO mdm.tblStgMember (ModelName, HierarchyName, EntityName, MemberType_ID, MemberName, MemberCode) VALUES ('Adventure Works', NULL, 'FirstName', 1, '', 1), ('Adventure...

    IanR5 pointsBadges:
  • Does Forefront Endpoint Protection support SQL Server 2008?

    Does Forefront Endpoint Protection support SQL Server 2008? This question is from the Microsoft Live Chat which took place on July 13th.

    ITKE346,250 pointsBadges:
  • sql 2008 export to txt for backup and incremental backup

    Hi i have one db that i want to back up, so thought id export to txt file/flat file then back that up and then daily increments into that file? cant find the steps to do it..have the wizard..

    Jordaan5 pointsBadges:
  • Mirroring SQL Server 2008 to a disaster recovery machine twice a day

    I want to mirror my SQL Server 2008 to a disaster recovery machine two times a day. Is there any free software to do this on a running SQL Server? If not, are there any cheap alternatives? Can scripts be run to copy the files over while SQL is running? Can I use shadow copy for this?

    ITKE346,250 pointsBadges:
  • Best way to back up SQL Server 2008 database?

    What's the best way to back up my SQL Server 2008 database? We are currently backing up the SQL data files during off hours but soon we'll be going 24/7 and we'll need to use maintenance plans and shadow copy. Can someone provide help?

    ITKE346,250 pointsBadges:
  • SQL Server 2008 query To Find Columns with incorrect information

    This is difficult to expalain so i will try and give you an example Record                  Surname               Age            Town 1                          Smith                   ...

    Davewaltonuk20 pointsBadges:
  • Linking users of Access 2003 to SQL Server 2008 database

    We plan to go to SQL Server 2008. We need to link our Microsoft Access 2003 users to the databases created in SQL Server 2008. Will we be able to do this considering ODBCAD32 is what we use, and the databases we create will now be 64-bit?

    Mike8005 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following