• 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:
  • Why isn’t my data displaying in the next page of Gridview?

    I added a sqldatasource from my toolbox to my aspx page. I then configured the sqldatasource to connect to a table. I then added a gridview to the same aspx page and selected the sqldatasource as it's data source. In addition to other column formatting etc., I set paging to true. I then opened the...

    Ilfoprog50 pointsBadges:
  • Sql Query in AS400

    I am trying to execute a Query String but I receive following error Query exceeded the specified time limit or storage limit however my query length is normal, nevertheless i have executed larger query too. How to solve this problem.

    Mr. SEA130 pointsBadges:
  • Crystal Reports in vb.net

    iam getting error while making connetion to sql server by OLEDB provider. The error is Sql server does not exit or access is denied ,sqlstate 08001

    Shaz255 pointsBadges:
  • SQL server 2005 to SQL server 2008

    I am following using sql server 2008 but following some lessons written by BOB Taybor. Is MyCompany.mdf for 2005 abailable in 2008 format?

    Standaman15 pointsBadges:
  • windows Server 2003

    Hi, we are in the process of developing an SQL Server-based application for the purposes of monitoring historical server performance and baseline data. Which windows Server 2003 tool and specific data-gathering option would be best suited to obtaining this information?

    Jessie12320 pointsBadges:
  • Free Chapter – Beginning Spatial with SQL Server 2008

    Another free chapter download is available on the IT Bookworm Blog. Written by: Alastair Aitchison Book: Beginning Spatial with SQL Server 2008 Overview: "Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the...

    BrentSheets6,925 pointsBadges:
  • SQL Server error: Cannot find log file

    I am receiving the error, "cannot find log file." I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql in C#

    How can I attach And detach a database file to sqlserver in C# code ? please give me an example of this

    Sajjadzare5 pointsBadges:
  • Restoring a deleted table in SQL Server 2005

    How do I restore a deleted table in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Variables in T-SQL

    Hi, I want to know y does the following script run in SQL and not in T-SQL DECLARE @tblName varchar(30) SET @tblName = CONVERT(VARCHAR(20),GETDATE(),112) + 'Table' DECLARE @sql nvarchar(4000) SELECT @sql = 'CREATE TABLE "' + @tblName + '" ( ID VARCHAR(15), Name VARCHAR(15) )' EXEC(@sql) go it gives...

    Babar198220 pointsBadges:
  • SAP Implementation

    Has SAP been iimplemented in Shipping Company? Who are the implementation partners. Is SAP ecc 6.0 ideal on oracle DB or SQL DB.?

    Enjay15 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:
  • Field in crystal reports duplicating lines from quote

    Using Crystal Reports XI on windows XP accessing SQL 2000 running on windows 2003 server using a Visual Manufacturing database. This is hard to describe accurately but here goes... I am running a report that uses QUOTE, QUOTE_LINE, QUOTE_PRICE and QUOTE_Binary_to_notes. QUOTE_Binary_to_notes is a...

    Mcgentrix5 pointsBadges:
  • Slow SQL Query

    when i run below all SQL Query simulataneously against 1500000 Rows its take 10 minutes i put the non-clustered index on the columns TATCallType ,CallTo the data type of both columns is varchar select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where...

    Mxaxyogesh200230 pointsBadges:
  • SSIS Import from Multiple Databases

    How do I iterate over a series of databases with identical structure and import from a seris of tables within each using the SSIS ForEach facility?

    RobH5 pointsBadges:
  • Using Oracle 10g Stored proc in SSRS 2005

    I'm trying to create a dataset from an oracle stored proc.The stored proc takes in parameters and generate multiple rows through a OUT ref cursor. BUT when I create a dataset and run it I get ONLY one single row. My reports need to show data for multiple persons(multiple rows).Some times when I run...

    Ala10ala15 pointsBadges:
  • Connection of Crystal Report 2008 with VB6.

    Plz let me know the procedure to bring the controls of Crstal Report 2008 in VB6? What control has to be select and what coding should be use for the same??am using sql 2000 as a back-end.plz help..

    Anishrohlx5 pointsBadges:
  • MS SQL SERVER (BKUPEXEC) Services wont start

    Hi ALL, Background: Windows 2003 Server returned the error missing or corrupted file after the server was found OFF due to possible power problems (Server is on a UPS). Ran a CHKDSK on the server and it fixed the missing or corrupted file problem and server now up and running. Is seems that my SQL...

    Ahmyown30 pointsBadges:
  • Configuration of Report Server – no errors but Window Service Identity shows not configured

    Using Vista SP 2 and SSRS 2005. When in the Windows Service Identity, I only see the Local Systems in the Built-in Accounts. I have read in a few documents that normally there are 3 options, (Local System, Network Service, Local Service). Can someone tell me where this list gets it’s values? I...

    Jennyp5 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