• T-SQL query to ACESS 2007 database

    I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks

    DamMan5 pointsBadges:
  • execute as with synonym

    This is a good one, I have a stored proc in database A that first deletes some rows from a table in database A. it then does a delete from a synoym that references a table in a different database. We were trying to use a "execute as" with a windows sql account "domain\srvc" that has sysadmin...

    tcstl95 pointsBadges:
  • jasper server with sql server

    does jasper server allow you to use sql server as your database server..if yes can you guys help me out...im stuck with this for almost a week. thanks in advance...

    Skillszone10 pointsBadges:
  • Tuning SQL query with hierarchy result through DB link

    I have the below SQL query: /********************************************************************************************************/ SELECT tm_super.tm_nbr ,tm_super.tm_fname ,tm_super.tm_lname ,tm_super.super_tm_nbr ,tm_super.super_fname ,tm_super.super_lname ,tm_super.super_job FROM (SELECT...

    Jlaksmana5 pointsBadges:
  • Filling data in datagridview in vs2005 with windows develpment

    HI all I have a more than 80000 data in sql server 2008 in a single table. Then i have to show that data in datagridview. But the performance has very slow some time my machine hang. It has taking several minute. So i have to improve this performance could anybody help me. For information i am...

    Visualpro5 pointsBadges:
  • Display Bug with CFTextArea?

    Is there a bug or a trick needed for cftextarea to display DB retrieved query data? When I try to display a single retrieved MS-SQL varchar value in a cfwindow dynamically created form, I must refresh to see the value. A HTML textarea control on the same form displays properly. Multiple query rows...

    PKS15 pointsBadges:
  • Adding data in SQL 2005 server

    i am trying to add data on an sql database from backend problem is it does not acceptnull values kindly help. My email address is edmuia@yahoo.com

    Zippyyepee15 pointsBadges:
  • In DB2 when a select statement is executed, it is taking lot of time and the table is being locked.

    In DB2 when I'm giving a select statement its taking lot of time, the reason is like the table is a very huge table. As a result some times it is locking the table. Can any one help me for executing the select query with any option which would not lock the table. Thank you in advance.

    UmaGandreddi80 pointsBadges:
  • Changing the sql server service and agent windows account password

    Hello, we are considering changing the sql server service and agent's password. What all should be considered prior to doing this? This will include doing this on 2000, 2005, and on clusters. Thanks!

    Rob35 pointsBadges:
  • Exporting SSRS Report in Simple Excel sheet(not formatted)

    Hi All, when I export and ssrs report in excel, it gets exported in excel but in a fancy format. I want to export the data in a simple excel sheet format so that I could apply filters or formulaes. If any one of you are aware of this do let me know please. Avhilash.

    Avhilash5 pointsBadges:
  • SQL Server 2005 question self join query

    I have one table that name is TblCategory on that 2 columns are CategoryName another column name is UpperCategoryID my table is like this CategoryName UpperCatID ------------ ----------- Book Commerce Commerce Accounting Science Math Commerce B.O. Material Pen Pen Link Pen Renolods I want ouput...

    Kotnimahesh5 pointsBadges:
  • SQL Server 2008: Difficulty setting mixed mode authentication password

    I am attempting to install SQL Server 2008 (64-bit) on Windows Server 2003 SP2 (64-bit). During the installation, I get stuck at the step where it asks for a mixed mode authentication password. Following the requirements, I have tried a strong password but I am still getting the error message, "The...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Encrypt the password in SQL 2000

    How to pass encrypted passwords in connection string in asp/vb using sql server 2000. Im trying to create a new user login for the applications using SQL server 2000. However want the end users to avoid viewing the login credentails for sql server 2000 in the connection string part. Hence prefer to...

    S09875 pointsBadges:
  • Estimate SQL Server tempdb space for a query

    Database - MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge - about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns retrieved 2. Join...

    BR5 pointsBadges:
  • unable to connect to SQL from Access

    I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version of...

    Standaman15 pointsBadges:
  • Refresh/Run SQL

    We upgraded to Crystal Reports 2008. Our older version queries appear to work... In the Older Verion all we did is click the lightening blot. Now... we have to go through Database, SQL to run/refresh the query. Isn't there a one click key for to run these queries?

    CrazyCoder5 pointsBadges:
  • SQL Server tables – What account created the object

    Is there a way to see who created or droped a table in sql server?

    Rick Martinez585 pointsBadges:
  • SQL Server: Index and Key

    What is the difference between a key and an index? Whe I issue a SELECT statement, and the table has an index, do I still have to use my key?

    bogeybetsy560 pointsBadges:
  • SQL select command

    Hi i hope all doing well, i have a problem with this SQL select command : **************************************************************** SELECT DISTINCT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price,...

    Abrahm7570 pointsBadges:
  • Memory overhead recommended for benchmarking SQL server 2005 on vSphere

    For a 'direct' physical to VM comparison of SQL server 2005, would anyone recommend giving the VM extra (say, 1.5GB) RAM to compensate for any overhead the OS needs? So a direct comparison would then be 1vCPU, 2.5GB RAM VM & SQL set to use 1GB RAM) vs. SQL on physical host set to use 1CPU and 1GB...

    SKrep5 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