• 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:
  • Error connecting to a SQL database

    I receive the following errors when I attempt to connect to a SQL Server database on my home computer: 1) Keyword not supported: 'intigreted security'? 2) An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact...

    SQL Server Ask the Experts2,585 pointsBadges:
  • search Button In vb.net 2005

    The code is for searching entire sql database if i enter RegistrationNo which is primary key plz help.iam getting errors. If IsNull(TextBox1) Then MsgBox "Please Enter the RegistrationNo" End If If IsNull(Me.TextBox1) = False Then Me.Recordset.FindFirst "RegistrationNo= '" & Me.TextBox1.Text & "'"...

    Shaz255 pointsBadges:
  • Transact SQL stored executed from AS/400 CL program.

    How can I execute a Transact SQL stored procedure (actually in the database) on a SQL 2000 database from an AS/400 CL program.

    Jcorzine20 pointsBadges:
  • SQL 2005 Password

    If you move a sql 2000 database to sql 2005 which admin password does it have now.

    Jabbman4220 pointsBadges:
  • Database and Log file location

    How do I change the default location for database and log files during a SQL 2005 installation?

    Quincy185 pointsBadges:
  • Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

    How to Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

    NET20085 pointsBadges:
  • Retrieving Records based on Record Selection from another table

    I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables,...

    Tjlevin10 pointsBadges:
  • Removing data in a column after a hyphen

    We imported a text file and one of the columns has first and last names in it. However, there is sometimes a hyphen with a title after the name. We need to create a SQL statement that will look for the hyphen and remove it and anything following it. Example: Column 1 Column 2 02/18/09 John Doe...

    Sunitalynn15 pointsBadges:
  • Unable to backup sql database.

    the full error that I am receiving is Backup- \\usfshk3ap09.edcllc.net\D: DataAn unknown or unexpected database error occurred while attempting a DBCC. The file name "C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_Config.mdf " is too long to create an alternate stream name.

    Terrywilson40 pointsBadges:
  • Video hosting

    I am including a video howto section to my business website. I have minimal experience in php and sql but have already created a SQL database for the information. I want this to be both dynamic and directable through the title of the video. can someone please give me direction.

    Tripodcomputerservices20 pointsBadges:
  • Connectionstring for paradox db password protected

    Hello everybody, Searching for answers I've found this insteresting page!! I've created a SQL query to a paradox database, it works fine with a non- password protected table: Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended...

    Starbasestarfleet20 pointsBadges:
  • Large DB, low capacity line, resync log-shipping options.

    Hello, We've a large SQL2000 DB which is 335GBs in size and a majority of tables are geographically replicated to a subscriber using transactional replication across a 10Mbit line. We're going through the process of converting the DBs' environment to SQL 2005. Unforetunately I think this means...

    SuperCoolMoss140 pointsBadges:
  • table row values for column headers

    Hi. I have two tables in a simple database: Prices ID (int, identity, PK) Year (smallint - year of value) Quarter (smallint - year quarter 1-4) Area (smallint - FK to Areas.ID) Index (float) Areas ID (int, identity, PK) Name (varchar) So, as you can see, the Prices table contains price information...

    Snowbunny5 pointsBadges:
  • Crystal Reports last twelve months

    I wrote a report that accululates invoice totals for each customer in a sql database based on period and year for period. I manually entered the last 11 months in the formulas by taking current month minus 1, then current month plus 10, year minus one and so forth. How can I make this process...

    Dunbar5 pointsBadges:
  • Reporting and Mirrored SQL2005 DB

    Can i access the sql2005 mirrored db via crystal reports for reporting

    Civmailman15 pointsBadges:
  • SQL DB MIRRORING ACROSS VPN?

    Can SQL 2005 DB mirroring work if the mirror server is to be in another building (building networks connected via VPN router)? We just want employees to be able to remote into the mirror server from home if power is lost at the main building.

    Kareemr695 pointsBadges:
  • How to move the msdb database to sql 2005

    I have a server running sql 7.0 and I need to move the msdb database to another server running sql 2005. When I try to restore the db from a backup I'm getting a compatability error message. Any suggestions greatly appreciated.

    Bubbanm90 pointsBadges:
  • How to get started in a SQL Environment

    I have been in an AS/400 world up until now. We are moving to SQL for a JDE EnterpriseOne implementation. What would be the best way for me to get up to speed on a SQL Server Database? Thank you for any and all insight.

    Kacerc65 pointsBadges:
  • Tricky Grouping problem!

    I am trying to migrate some Employee absence data, from one table to another. The data currently looks like: Employee, Date, Reason ------------------------ dave,01/01/08,sick1 dave,02/01/08,sick1 dave,03/01/08,sick2 dave,04/01/08,sick1 dave,05/01/08,sick1 bob,01/01/08,sick1 bob,02/01/08,sick1...

    EggBeard5 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