• Copy BLOB to BLOB using TSQL

    Is there a way I can copy a BLOB from one column to another using TSQL ?

    Prototyper5 pointsBadges:
  • What is the best way to replicate SQL 2008 DBs to a failover site?

    We are looking to replicate our SQL 2008 databases to a hot failover site.  We can't use DB mirroring due to the number of databases we have.  Has anyone replicated databases to a hot site using a replication solution and what was your experience.

    DaveMPA55 pointsBadges:
  • The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly.

    We have installed sql server 2008 (64 bit) on windows server 2008 enterprise edition, in which around 10 jobs to populate the dimensions from relational db to analysis cubes. I am frequently facing the same error and the services gets stopped. "The SQL Server Analysis Services (MSSQLSERVER) service...

    GIG240 pointsBadges:
  • Powershell 2

    Hello I installed PS (ver 2) from windows updates. I have a couple of Q: 1)The event viewer shows a bunch of event id 4374 package not applicable 'warnings' but I tried running some cmdlets and they work fine in 2 However, I get an exec of scripts is disabled on this system for version 1 execution...

    Sense2k10 pointsBadges:
  • SQL Server Express 2008 with Advanced Services Installation

    I am trying to install this program on a Windows 7 OS, and I'm having a very difficult time. I have a 64-bit computer, but I'm trying to install the 32-bit version (x86) because I only have a 32-bit version at work, and I'm practicing at home what I eventually want to do at work and I want...

    Dataempress115 pointsBadges:
  • SQL Server Express 2008 w/Tools vs. Advanced

    Hi, I installed SQL Server Express 2008 w/Tools on my Windows 7 OS. I just found out that if I want to download the AdventureWorks database .msi from codeplex, I need SQL Server Express 2008 w/Advanced Services. Do I need to uninstall the SQL Server Express 2008 w/Tools and install SQL Server...

    Dataempress115 pointsBadges:
  • How to count the common column rows in the table for each column and row…..

    I have a table and that table have columns like d1,d2,d3,d4....... d1      d2    d3    d4 --------------------------- 200   300   100  300 100   200   101  101 300   ---    300  200 how can i display the output like below...  for each row.... ColumnD1 Count 200    3...

    Paanduranga15 pointsBadges:
  • Production SQL Database has been restored with Old database backup

    Dear Expert, I need your Advice, today in morning i run Symantec backup restore on SQL 2008 server where i overwrite the production Database with Old backup. Is there any way i can retreive the old Database until yesterday. i dnt have any backup of New database which i accidentally overwritten.  ...

    Aleem60015 pointsBadges:
  • ADO not receiving errors raised in sub procedure

    Hi, I'v known for a while that ado has it's limits when it comes to dealing with errors... but this one hurts: I have a StoredProcedure (SP) that calls a sub procedure. In the sub procedure an error is raised. The error does not reach ADO for some reason. After some research I find that if the sub...

    Palloquin95 pointsBadges:
  • 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:
  • 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?

    ITKE352,420 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