• Windows Forms and SQL Server 2008 database

    Now, I have created two different things: A local database and a Windows form. With the Windows form (In Server Explorer), I added the database's connection. How can I begin querying it using LING-to-SQL? Thanks!

    ITKE346,195 pointsBadges:
  • How to store TOP 2 variables in SQL Server 2008?

    How can I make it so that I can store the top 2 results in 2 variables?create table t(id int); insert into t (id) values (1),(2),(3),(4); declare @id1 int declare @id2 int select top 2 @id1 = first id, @id2 = next id from tIs there a way to make this happen in one query without using a loop?

    ITKE346,195 pointsBadges:
  • T-SQL: Split function

    I'm trying to split "1, 2, 3, 4, 5, 6, 7, 8, 9, 10" into a table or table variable. Is there a function that returns each number in a row?

    ITKE346,195 pointsBadges:
  • I keep receiving an error in SQL Management Studio

    When I'm trying to create several users in SQL Management Studio, I first create them under the server name, followed by the database. However, when I'm trying to log on, I keep getting this error message: A connection was successfully established with the server, but then an error occurred during...

    ITKE346,195 pointsBadges:
  • Logging and finding queries in SQL Server 2008

    In SQL Server 2008's activity monitor, I can see the most expensive queries. But my question is if I can actually log this info via Query Analyser? Thanks!

    ITKE346,195 pointsBadges:
  • iDB2 connection String permenant solution

    I have a DB2 connection string to our i-Series that works. "DataSource=10.10.10.10;userid=LIVEXML;password=LIVE1;DefaultCollection=DATALIB031;" We have been developing a lot of apps and web services that use this type of connection. My problem is when our i-Series software is upgraded (about every...

    ToddN200011,100 pointsBadges:
  • SQL Server configuration

    How would I configure SQL Server 2008 R2 to handle 1 million connections?

    ETCGMan40 pointsBadges:
  • How to query a SQL Server 2008 database from Outlook

    The purpose of this module is to monitor the activity of Outlook and grab the attachment (. Zip file) for a specific email address and subject line and place it on the server (and create the Server Folder(s) Structure: CompanyName->weekNo.->zip file(s)) I have to mention that we are going to...

    SoftwareQuestions5 pointsBadges:
  • SQL query help – SQL Server

    Okay, I hope I can explain my dilemma... I need a SQL select statement that will Select part_number from RCTOOL the column part_number has values such as BR643-0034-344-34 AS54-54689 A77360-3454-34456-4 B7374-343-33-32-356-433-11-1 In each of these cases ALL we want it to return is the values UP to...

    MyDanes35 pointsBadges:
  • SQL server 2005 and 2008 needed on same network. Same machine or seperated?

    Hello there, I have to install both SQL server 2005 and SQL server 2008 in order to use CRM software and a financial software. After chatting with the financial software support & the CRM guys I understood I have to have both versions on my network since each needs its own version of SQL server...

    abmolibenny10 pointsBadges:
  • SQL Server 2008 R2 replication

    Good Day. I configure Transactional Replication using SQL Authentication. The subscription account was added to the PAL and it belongs to the Sysadmin group and database_owner role. When I clicked on the VIEW SUBSCRIPTION STATUS and the result shows that the synchronization is working. I also...

    ABSA5 pointsBadges:
  • SQL server native webservices and PHP

    Hi, I have a SQL server 2008 database and I need to query it from PHP running in a Linux box. I thought that using webservices was our best option. I am trying to use native HTTP SOAP in SQL server. Following some tutorials, I made first an SP USE [Basededatos] GO /****** Object: StoredProcedure...

    Claubolson35 pointsBadges:
  • Creating second instance on SQL Server 2008 cluster

    Hi, I need help to create second instance on SQL 2008 Cluster. I have active/passive Windows 2008 R2 cluster and currently using a default instance of SQL. Most of the blogs mention that installation of new instance is same as the first one and you need to provide IP, network-name and disk...

    PowerEdge5 pointsBadges:
  • Unidirectional replication in SQL Server 2008

    Can transactional replication be bidirectional?

    Dougm10 pointsBadges:
  • Creating service accounts in Windows 7 home edition

    In Mike Hotek's book SQL Server 2008 he gave instructions on how to create service accounts using XP. How do I create these accounts using Windows 7 home edition? Thanks.

    kerrycorr5 pointsBadges:
  • Getting 2008 voting data inside Spatial

    When creating a choropleth map, first I must obtain the data. If I have the table of values in my possession, what are the steps for moving the data inside Spatial?

    lloydia5 pointsBadges:
  • How to make fast indexing and flat text search in SQL database

    Our objective is to achieving good speed with Full-Text Search on an MS-SQL/2008, using Sphinx DB Indexing and text search engine. Our challenge: can we reach speeds better than 3 sec/per simple term search on a DB containing about 2GB of data / 200+ tables with complex permission system...

    Eid24305 pointsBadges:
  • Update duplicate records

    Before change: CLAIM_ID CR/RE   Internal TAT 11061488        Rebill 27 11061488        Credit  11061488 Credit  11062027 Rebill  34 11062027        Rebill  11071404 Credit  12 11071404        Credit            After change : CLAIM_ID CR/RE   Internal...

    SQLbamola5 pointsBadges:
  • SQL query

    I have 3 columns: development no,city, status for stamp (this column is set by 0,1,2). I want to write a query that specifies percentage of stamps per city; for example percentage of stamps with 1 in city x, percentage of stamps with 2 in city x, percentage of stamps with 1 in city y....and so on....

    hengameh5 pointsBadges:
  • Can any one post IKM online test questions (SQL Server 2008) please?

    IKM online test questions SQL Server 2008.

    IKMsql1235 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