• Indexing in Microsoft SQL

    What is an index in Microsoft SQL? What types of indexes are available in SQL Server 2005? Do I need to know about this to create and deploy a database?

    TeachMeIT975 pointsBadges:
  • SQL Server 2005 maintenance plans

    I have several maintenance plans setup in SQL 2005, but if the backup fails I am not alerted in any manner how can I fix this? Will I need to script something or is this a built in feature?

    TeachMeIT975 pointsBadges:
  • Kerberos unconstrained delegation for MS SQL svc account

    Can an MS SQL service account run non-SQL services if "trust this user for delegation to any service (Kerberos only) has been enabled?

    Calicdaj5 pointsBadges:
  • Crystal Reports XI – SQL table fields that fail all compare tests

    I have an SQL table with a field that Crystal XI displays as string 300, call it mytable.mystring. If I create a formula field (myformula) such as... if {mytable.mystring} = "test value" then 1 else 2 This is what happens during execution...  when the the preceding test is true, Crystal returns a...

    BTod35 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:
  • dba deleting data

    Is part of a DBA's job to delete production data using SQL scripts?

    Biker015 pointsBadges:
  • SQL Work Files

    In the FOCUS programming language, you can retrieve data and hold that data for further processing at some point later in the program.  What is the best technique for doing this in SQL?

    Rhansard5 pointsBadges:
  • Receiving result sets in RPG (prior to release 7.1) from an SQL SP

    I have read through the IBM manual "Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries" for information related to returning a result set(s) from a stored procedure into an RPG program. The manual states that a Global Temporary table must be used for this...

    MapleLeafDeveloper5 pointsBadges:
  • Connect to remote SQL server from MySQL

    we have read only access to a remote sql server. the requirement is to read few tables from sql server and load to mysql tables (installed on Unix box). Please suggest the possible ways of achieving this.

    Nitibansal5 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:
  • How does exchange 2010 email archiving work?

    How does exchange 2010 email archiving work? Imean techincally speaking, does it stub? What do the users see, what is on the backend, a SQL database? I can't find any articles on how exchange server 2010 email archiving works under the hood?

    Tuck15 pointsBadges:
  • What is a linear recursive query in SQL?

    What is a linear recursive query in SQL?give me an example.Is there any nonlinear recursive query??

    Gomsbk35 pointsBadges:
  • Problems running AS400 stored procedure from SQLServer 2005 SSIS execute SQL task

    I need to run a stored procedure (with two input parameters ) that has no output, on an AS400. When I try using the IBM DB2 UDB for iSeries IBMDA400 OLE DB provider, I get the following error [Execute SQL Task] Error: Executing the query "CALL TPSDTA50GQ.PMCTESTTP('PETER', 4)" failed with the...

    PeterJC15 pointsBadges:
  • SQL problem: Adapting code fragment

    How do I adapt the fragment of code below to show: a) Two columns - the Filipino Population and the Total Population  b) The Filipino Population as a percentage of the total population  SELECT DISTINCTROW POPDATA.CITYNUM,  COUNT(*)FROM POPDATA  WHERE POPDATA.ANCNUMBER=720  GROUP BY...

    Mentos5 pointsBadges:
  • Database Security: SQL Server 2005 security login

    Like Oracle Logins how can we create Logins in Sql Server 2005? Please help me..........

  • Using mdf file in website

    When you've developed e website with vis stud, including an aspnetdb.mdf file and a database file for the webcontent, how can you use these mdf files on the isp server where sqlserver 2005 is running? A normal connectionstring in the web,sonfig file gives an error about the attachdbfilename being a...

    Makoe5 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:
  • Are parameters permitted on SQL Server 2000 views

    I think the answer to this is NO, but is there a way to create a view that accepts input parameters? I created the view hard coding in something that now needs the flexibility that a parameter would provide, but I've never seen a parameter on a view - Is it possible? Thanks

    CO Bill120 pointsBadges:
  • Recovering data from crashed database

    i   i have a question. my database  is crash .i don't have present backups.but i'm having  last week backups.  and  backup  strategy sunday   10 p.m  full backup everyday  1 p.m    differential backup every one hour transaction log backup  please give me reply as soon as thanks &...

    Venkatdbait35 pointsBadges:
  • Microsoft Retail Management System and SQL Server “Write” error

    I am running Microsoft Dynamics Retail Management System POS 2.0 on Microsoft XP platform.  Store Operations Administrator and Manager are working with no problems.  I know I am networked properly.  When I open the POS I get the following:  "Open-Incorrect Function", I can click OK and sign on...

    Cls5 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