• Can I transfer a SQL license/install to a new server

    We are in the process of upgrading on of our db applications to a new version. This version will require a replication server, meaning we will need a SQL server. Ether 2003 or 2008.  We will need to have a full working test environment before rolling out live with it. Can we transfer our "test"...

    swinehart68031,050 pointsBadges:
  • I need to replace a word in a Document through SQL Server 2008

    Hello  i'm using SQL 08 R2 to store my resume collection , i want Sql to find an Email  in the MS WORD document and replace it with an empty string  so far I've succeeded to find the word using fullTextSearch  this my example for finding the documents that contain an email  SELECT  document...

    Shayguri15 pointsBadges:
  • Sample Test Data from Production in SQL Server 2008

    Is there a data generation tool that can populate tables in a test database with a percentage of actual data from a production database? For example, to extract data based for a date range from a specific table, and all related tables to be populated based on the corresponding related referenctail...

    Teguma15 pointsBadges:
  • SQL servers merge transactions

    In vb.net windows application,i used sql server 2008 for database. For deployemnt and implementation process, we used currently the sql server is in the web.client have different locations and want to access application from any where. The problem is at some rural area the internet down time is...

    Qqqqqqqqqqqqqqqqqqqq20 pointsBadges:
  • SOLAP in SQL 2008R2

    IS there SPATIAL OLAP implementation in SQL 2008R2

    JiriJ5 pointsBadges:
  • Create QA database with only some production tables

    I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They're all in the same filegroup in the original database. I've...

    Rwaltz5 pointsBadges:
  • What are the best tools for SQL monitoring and SQL diagrams?

    we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?

    Persa5 pointsBadges:
  • Hide SQL Server 2008 input parameters

    Hi Sir, I wanna help from you . i have designed a report on reportserver . (sql 2008). its includes two variables which are userid and password. Because entering the user id and password , only the data who can view authorised section. User id and password should be keyed and it check with the...

    Virajtky5 pointsBadges:
  • SQL 2008 job problem

    I have a schedule SQL2008 job to export the contents of a table to a text file each day. The job runs fine when I manually execute it, but if the schedule executes it, only 4 or 5 lines of text out of about 13000 are produced to the text file. Any ideas anyone? The job script follows: EXEC...

    DavidHa!!110 pointsBadges:
  • How to transfer database from SQL Server 2008 to SQL Server 2005

    how to attach database of  sql 2008 into sql 2005

    Itready5 pointsBadges:
  • trying to use MAC address authentication for AP from NPS RADIUS Windows Server 2008.

    We are trying using MAC address authentication for AP from NPS RADIUS Windows Server 2008. Two things we are facing need help: What's the "condition" selected and how's the format? Secondly, How do we excute the query of SQL( 2008)table column? I do make conection successful but I do not have any...

    CHENS265 pointsBadges:
  • 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:

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