• Identifying data in SQL Reporting Services

    I am using SQL Reporting Services, and one of the files has the same ID but a unique position number. The field names are ID, pos, phone number and extension. Now, for example, a person with three phone numbers will have three records (pos 1-3). In this scenario, how would I identify a phone number...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to find out what is happening in a Database?

    We have an old server that runs SQL Server 7 on an NT system. One database has processes running that are not documented. I have written triggers to report any deletions, inserts or updates made against the database's tables. All I can report is that an insert, update or delete has occurred, the...

    Mjf75 pointsBadges:
  • Creating View With Xml file and table in sql server 2005

    Hi, I have an Active Directory Xml File and I have archived Table with Active Directory With Limited Information like(GUI,FName, Userid) I like to create a view By left join active directory file and archived table. Thanks for reply in advance Please reply to this question

    1 letters5 pointsBadges:
  • How to manage memory for SQL 2005 x64 on 64-bit WS2003 Ent

    I have a Windows 2003 Enterprise 64-bit server running SQL 2005 x64 with 32GB RAM. The SQL database is acting as a transaction database. What is the best way to manage memory on this server? Should I adjust the paging file? If so, to what? Any ideas are appreciated!

    Jean.young5 pointsBadges:
  • Not able to coonect to SQL Server 2005 from Front End in windows Vista Home Basic

    Im not able to connect to SQl Server 2005 installed in my local PC to .net application.But im able to open SQL server 2005 seperatley & able to create tables.Im getting connection failed error while trying to connect.Please give slution for this.

    Karanam5 pointsBadges:
  • MSSQL$BKUPEXEC Service won’t start.

    Hi All! I have a problem with this MSSQL$BKUPEXEC service after a power failure on my SBS Server Premium Edition, this service and along with these below are also not starting as they're meant to be; Backup Exec Device & Media Service Backup Exec Job Engine Backup Exec Server BlackBerry Dispatcher...

    RicoSoya45 pointsBadges:
  • Restrict a script to reduce SQL injection attacks

    I want to reduce SQL injection attacks. How can I restrict a script to execute one query at a time?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Toggling a case sensitive query in SQL Server 2005

    It appears that my queries of stored procedures, tables, columns, etc. are case sensitive in SQL Server 2005. Is there a “case sensitive” option that I can toggle on and off?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sage Mas 500 setting up Microsoft Project link.

    I am running Sage M500 - I need to be able to link my project files to my M500/SQL data and vice versa. I see lots of information on functionality but only consultants that want to set it up! HELP Me do this for free and save the day!

    Karl Gechlik9,860 pointsBadges:
  • Avoiding shut down to update windows

    If an sql server is being used for asp solutions, what is the best way to avoid having to shut down when running windows updates? Trying to come up with solution to keep clients from losing access to software.

    Newbie275 pointsBadges:
  • Increasing the performance of a slow query in SQL Server 2000

    I am using SQL Server 2000 SP4 on Windows 2003 Server, and I am having a problem with my queries. One of them was running fine a couple of weeks ago, but all of a sudden it is taking considerably longer to process than it used to. How might I resolve an issue like this from the database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL: Using a column created in the SELECT in the WHERE CLAUSE

    Can I use a column in the WHERE clause that I created with 'AS' in the WHERE clause. I have tried and SQL tells me that the column is not in the table? Thanks, Ray

    RayT30 pointsBadges:
  • Initialization DB-Connect Failed, Return Code 000256

    I have migradted 4.6C with 4.6D Kernel from HPUNIX, and Oracle to Windows 2003 Server, 4.6C, and MSSQL 2000, when updating the Kernel getting above mentioned error, can someone please help

    Budi4655 pointsBadges:
  • Refusal to recognize SQL Server 2005 Express on a client PC

    I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that was...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Excluding Data Usin NOT IN

    I'm trying to export data from a sql table into sql reporter. The information I'm trying to retrieve is information regarding permissions (this is audit stuff). The problem is, there are spaces (and always a different amount of spaces) between the user and the permissions; for example: Type Account...

    Jerzdevs10 pointsBadges:
  • Create a sequence called Store_seq with the following values: increment by 10, start with 500

    Create a sequence called Store_seq with the following values: increment by 10, start with 500

    VB RD45 pointsBadges:
  • i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??

    i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??

    Pandu5 pointsBadges:
  • cube data fails to display

    Working through the Foodmart 2000 sample sales cube in SQL Analysis Manager, all goes smoothly but at the end data does not display. The error message is "unspecified error", unable to browse the cube. This is the Sales cube created with the Quickstart example on Foodmart 2000.mdb.

    Psf55 pointsBadges:
  • unable to attach sample database in SQL 2005

    Hi, I installed SQL server 2000 and SQL 2000 SP4. Than I installed SQL Server 2005. But when I am trying to attach the AdventureWorks Sample database, I am getting the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ An error occurred when attaching the...

    Ismav5 pointsBadges:
  • datamining SQL with access

    I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that access will see the database...

    Daiishi0 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