• Can I install SQL Server 2005 32 bit on 64 bit OS?

    can I install SQL Server 2005 32 bit on 64 bit win 2003 OS?

    Siddiquiali15 pointsBadges:
  • Running scripts in SQL Server 2005

    How can I run scripts in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Implementing a chat using SQLServer Service Broker – how good an idea it is?

    We are designing a chat engine. That's basically a message queue. When our customers will adopt it, there will be thousands of people chatting. In our company we use SQLServer heavily, and this is an argument for preferring Service Broker over MSMQ. Is Service Broker a good idea? Each chat session...

    Marcofaustinelli5 pointsBadges:
  • Earn 50 knowledge points by tweeting out our iPad contest!

    We'll give you 50 knowledge points for sending out a tweet about our iPad contest, happening now through February 16th! Spread the word, earn points, and qualify yourself for an iPad or Amazon.com gift card! Contest details at the Community Blog.

    MelanieYarbrough6,345 pointsBadges:
  • Resolving all losing conflicts-Merge Replication in SQL Server 2005 and 2000

    The application I support uses SQL Server 2005 as the publisher and SQL Server 2000 at the subscriber. One of our clients went nuts trying to prune his database and deleted a year and a half of sales data. Unfortunately I did not have a backup, but I did have an old copy of the db. I manually...

    SQLFish5 pointsBadges:
  • How to concat SQL Server 2005 data with line feed

    I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The script I...

    TLMercer45 pointsBadges:
  • Cross-database name change in SQL Server 2008 stored procedures

    Hi: The easy part is the databases will be on the same server.  However at the moment I am writing code in database SOMEDATABASE_TEST which is accessing objects in SOMEOTHERDATABASE_TEST.  When its time to go to production the names are going to change to SOMEDATABASE and SOMEOTHERDATABASE. ...

    Rusty25 pointsBadges:
  • How to populate datagrid using store procedure

    m trying to populate a datagridview using a store procedure called from  a module but it is givign me some problem as in my module i use the Function as a bindingsource can someone help me here im totally lost

    Implicitcherry5 pointsBadges:
  • SQL 2000 view debug help

    I have the following (admittedly convoluted) view that I cannot get right for some reason that I cannot see. Consider the following: SELECT     s.s_SAMPLEID AS LimsSampleId, s.U_CLIENT_SAM_NO AS ADASampleId, MAX(s.SAMPLEDESC) AS SampleDescription,                      ...

    DavidHa!!110 pointsBadges:
  • Connect Powerbuilder in SQL Server 2005

    how to connect the sqlserver 2005 database in power builder

    Venkateshr5 pointsBadges:
  • SQL Server 2008 Upgrade

    I have 7 SQL Servers I need to upgrade from SQL Server 2005 to SQL Server 2008. Can I install the SQL Server 2008 prerequisites using Microsoft System Center? If yes how?

    Rick Martinez585 pointsBadges:
  • SQL Server 2005 Enterprise Edition SP3 Performance

    We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the...

    Rick Martinez585 pointsBadges:
  • Recursion in Visual Studio 2010

    I'm running Microsoft Visual Studio 2010 Professional on a Windows 7 laptop and trying to learn C#. I'm working on recursion and want to prompt the user to enter a specific word into a console application and then use a recusive method to print each character of the user-supplied word on a separate...

    QMac10 pointsBadges:
  • SQL Server 2008 tables

    I  have 2 tables, tanle1 and table2 Can someone help for  SQL query  for table3 with 2 colums colum 1  is select number from table1 for colum2 in table3  I need to get the total number of times  each number in colum1 of table1 apears in in colums n1,n2,n3,n4 of all events in table2 as shown...

    Ajibola110 pointsBadges:
  • Performance and Resource Consuming Monitors SQL Server 2008 R2

    Are there any specific GUI tools available to monitor the performance and resource consuming process? At present we are using third party tool to do so (Spot light)?

    ITKE342,865 pointsBadges:
  • Cost to Upgrade to SQL Server 2008 R2

    How much will it cost to upgrade from SQL 2005 to the 2008 R2?

    ITKE342,865 pointsBadges:
  • Select/Insert Statements causing out of memory error run under VB Script

    I'm using VB Script on a Windows 2003 Server against an Oracle 10g database to both query against a table and insert new rows of data against that same table but as it runs it starts eating up RAM and when it gets to about 1.5gb it causes the out of memory error.  As far as the Select...

    TheBandit15 pointsBadges:
  • Earn 250 Knowledge Points now by tweeting out our contest

    We've recently added 250 Knowledge Points to the following profiles for tweeting out our Google Nexus One Challenge: JaideepkhandujaOwenAmbroseCarlosdlRyan8613MarkK Tweet out our Google Nexus One Challenge now and you can also earn the 250 Knowledge Point bonus. Remember that you don't have to be...

    JennyMack4,280 pointsBadges:
  • SQL command question

    I have three tables as below: Table 1: attributes fields: attID, att_CategoryID, name Table 2: att_Category fields: att_CategoryID, name Table 3: prodcutAttributes fields: ID, productID, attID, I desigining this tables to be able to add multiple prodcut attributes for ecommerce site. I don't know...

    Ktoby55 pointsBadges:
  • iSeries SQL ISNULL Equivalent

    What is the equivalent of the function ISNULL in t-sql in AS/400 iSeries Navigator SQL? or the equivalent of the NZ function in Access?

    Jaggerdude60 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