• SQL query How to select nth row from a table if they are not in any order

    How to select nth row from a table if they are not in any order

    Johnsmak5 pointsBadges:
  • How to display values in one table by referring and checking values in another table?

    how to display values in one table by refering and checking values in another table

    Sqldb5 pointsBadges:
  • SQL SERVER 2005 Security use Kerberos instead of NTLM

    How can I setup sql server 2005 to use kerberos authentication instead of NTLM?

    Rick Martinez585 pointsBadges:
  • Master Data Services – Confused by mdm.tblStgMember

    Hi, In Denny's excellent blog on loading data into Master Data Services, he populated the staging tables as follows: INSERT INTO mdm.tblStgMember (ModelName, HierarchyName, EntityName, MemberType_ID, MemberName, MemberCode) VALUES ('Adventure Works', NULL, 'FirstName', 1, '', 1), ('Adventure...

    IanR5 pointsBadges:
  • Excel as a front end to sql, data integrity

    how do I put a value in a sql field that will not be counted in a excel pivot table? I am using excel as a front-end to sql. In particular, I am using pivot tables to slice and dice sql tables. The field I am interested in has either a text value or a NULL: CaseID (varchar (15), null). When I pull...

    Dannl10 pointsBadges:
  • SQL-Using count and inner join in a single query

    Hi Trying to retrive a report from the DataBase using left join on two tables. To get the count of resultant table, I'm using count. But the output shows error. If I comment count statement then the query executes successfully. I feel there is some error in the syntax of the count that I'm using....

    SQLmurali5 pointsBadges:
  • Does Forefront Endpoint Protection support SQL Server 2008?

    Does Forefront Endpoint Protection support SQL Server 2008? This question is from the Microsoft Live Chat which took place on July 13th.

    ITKE364,180 pointsBadges:
  • Problem on Roaming Profile

    I have implemented Roaming profile in our organization. It is creating profile on the local system when the users get login. After logoff the user the data is saving on server and local pc also. I like to delete the profile when the user logoff to avoiding space occupying on the local system. Can...

    Jothibasu0 pointsBadges:
  • sql 2008 export to txt for backup and incremental backup

    Hi i have one db that i want to back up, so thought id export to txt file/flat file then back that up and then daily increments into that file? cant find the steps to do it..have the wizard..

    Jordaan5 pointsBadges:
  • Help upgrading from SQL Server 1997 to SQL Server 2005

    When upgrading from SQL Server 97 to SQL Server 2005, what needs to be done? Can I restore 97 backups to 2005? Do I need to install any other software? Is this an easy process? We have 6 databases with about 300 GB of data currently.

    ITKE364,180 pointsBadges:
  • Sponsor Post: Fear the Cloud? Migration Pros and Cons (on-demand chat from 6/29/2010)

    Organizations need to able to quickly recover failed servers and their data in the event of an outage. Deploying a server recovery solution can save a company tens of thousands of dollars in lost productivity and lost business. This live chat on June 29th from 1-3 pm EST provides an exclusive...

    EmNichs3,250 pointsBadges:
  • .Net Application Routing Emails from SMTP to Exchange Server Error

    Our .Net app works fine using current We.config settigs if we send emails to an external SMTP host. When we point it to our Exchange server it won't work! Any ideas please help. Are there specific SMTP Server settings we need for this to work with Exchange, or any Exchange Server settings that...

    JimDoyle5 pointsBadges:
  • What’s the optimum amount of memory on a Quad core xenon 3.4 ghz machine?

    Should we load up a 64-bit OS for this machine? It will be SQL Server only. We want to have the best user experience so any help would be greatly appreciated.

    ITKE364,180 pointsBadges:
  • Mirroring SQL Server 2008 to a disaster recovery machine twice a day

    I want to mirror my SQL Server 2008 to a disaster recovery machine two times a day. Is there any free software to do this on a running SQL Server? If not, are there any cheap alternatives? Can scripts be run to copy the files over while SQL is running? Can I use shadow copy for this?

    ITKE364,180 pointsBadges:
  • Does SQL support nonlinear recursive queries?

    does sql supports nonlinear recursive queries

    Gomsbk35 pointsBadges:
  • SQL Explorer Not Connected

    Hi all My OS is WIN 7 , Oracle Server Installation (10g Express Edition) is Sucessful Oracle 10g Client Installation is sucessful ODBC connection is Sucessful. But SQL Expolrer - not connected Error is General SQL Error. Microsoft [ODBC Driver Manager] Driver is SQLallocHandle on SQL_HANDLE_ENV...

    Yes115 pointsBadges:
  • error in SQL workbench

    ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 SQL Statement: CREATE  TABLE `cape codd`.`SKU_DATA` ( )   Does anyone know how to fix or workaround this? thanks Whitney Ferrante

    Whitneyf5 pointsBadges:
  • How can i connect database from sql explore

    Hi all, My OS is Windows 7, I install Oracle 10g Express Edition then i install Oracle 10g client. Installation is Sucessful then i config ODBC setting.ODBC is Connection Sucessful.But SQL Explorer is Not Connected.How can i solve this Problem?Kindly Help.

    Yes115 pointsBadges:
  • Set DataTable name in returned data set

    I have a SQL stored procedure with simple select statements that returns multiple datatables within the dataset.  The stored procedure is being called from C#/.NET code.  The stored procedure is returning the data but the datatable names end up Table, Table1, Table2,...  when the dataset is...

    LordPerrin15 pointsBadges:
  • FreeRadius CentOS 5.5 Help

    Hello, I have setup a freeradius server on CentOS with a SQL backend. I am unable to autenticate using NTRadPing to test a user conenction. Just need some help to debug and find out the cause. Thanks! Scott

    Jonessc5 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