• Designing a report in SQL from an Excel worksheet

    I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to import this specific information?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Questions about a SQL database with hourly transaction log backups

    We have a SQL database with a full recovery model that backs up the database once a day, along with hourly backups for the transaction logs. However, we only have one transaction log backup file, and it is overwritten every time. Are transaction log backups cumulative, and if so, does that one file...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL DATABASE SERVER

    Hi, Please how can I access a client SQL database server remotely to update date therein. My client have this MS SQL Server Ver. 9.00.2047.00, Product Level: SP1, Edition: Standard Edition. and I will need to update the data. I have to update the database. I have downloaded SQLEXPR and installed in...

    Chukbillo20 pointsBadges:
  • how to understand the flow showplan_text stmt

    hai everybody, desperately i need to understand the execution plan and flow of joins or any other queries using 'set showplan_text on'. i am getting the output, but the iam not getting the flow i.e. which part is executed first, from bottom or up [ how to read the lines which are sepearted by...

    Manickam0 pointsBadges:
  • SQL 2000 Reporting Services – Using embedded code to guide user on input parameters?

    I'm working on a report which has these input parameters: StartDate (textbox, data type is datetime) EndDate (textbox, data type is datetime) AccountNumber (dropdown, data type is string) I need to set up logic where if the user viewing the report has input only date values, they'll be prompted to...

    Darth Continent35 pointsBadges:
  • Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases?

    In SQL Server 2000, you can use a backdoor to create your own view in INFORMATION_SCHEMA... In SQL Server 2005, I get a permissions error though. Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases like the INFORMATION_SCHEMA views? Thanks...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Replication Logreader error. SQL Server 2000

    Hi I am using SQL Server 2000 replication , I have separate publisher,distributor and subscriber servers running on SANs. I get below error and synchronization gets struck, becuase log reader could not read data from the publisher db. Could you give me a quick fix for this error....

    Krajdba10 pointsBadges:
  • Order by using case statement SRS 2000

    I am using a case statement to order data on a SRS report, when the statement is ran, it returns the correct order, but when I save the RDL and preview it, it returns to ascending order. How do I correct this?

    Wi sundevil5 pointsBadges:
  • AR server

    we r using the AR server 7.0 the backend database is sql 2000 under window platform, so now if I need to change the database table format to CLOB then, any one could tell me what is the format of changing the database format, I mean the table format to In-row and Out-row method. Could any one...

    Jiji5 pointsBadges:
  • dtexec scripts just deleting data

    since reinstalling SQL Server Express, and SQL Server Express Manager, the dts scripts I have created with the import\export wizard are simply deleting all data in my target tables (when run via. dtexec), Yet they work ok from the wizard, and worked ok a few weeks ago. I don't understand what this...

    John t5 pointsBadges:
  • Storing text documents in tables in SQL Server 2005

    I have a table in SQL Server 2005 which is used to store text/word documents, and I have enabled full-text search on the column and included a corresponding document type for the document. The problem is when I upload a real NotePad Text/MS Word document saved from the NotePad/MS Word application....

    SQL Server Ask the Experts2,585 pointsBadges:
  • clustered sql 2000 to sql 2005 upgrade

    What can I expect when upgrading a clustered SQL 2000 box to SQL 2005?

    Ajf10 pointsBadges:
  • Unable to Restore Backup in SQL Server 2005

    I am unable to RESTORE Backup through code in SQL Server 2005 from VB.Net, even though that code is running fine in SQL Server 2000. The code is: "restore database [" + databasename + "] from disk ='" + Me.lblSource.Text + "' with move '" & dfile & "' to '" + Me.lbldatafile.Text + "'," & _...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error messages in Business Intelligence Development Studio on SQL Server Integration Sevices

    I am new to SQL Server Integration Services (SSIS). When I went into Business Intelligence Development Studio (BIDS) and tried to create a new project, I received this error message: "Could not load or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies. The system...

    SQL Server Ask the Experts2,585 pointsBadges:
  • must Access be installed to use Analysis Server

    Working with Analysis Manager Version: 8.00.194, my Sales cube looks good until I try to browse the data that comes from Foodmart 2000.mdb. Is this because Access is required?

    Psf55 pointsBadges:
  • Infopath Library

    We have an infopath form tha that is saved to a library. Is there a way to read that info into a sql database?

    Tecnique5 pointsBadges:
  • Maintaining a company table in SQL

    I am not sure if I should mix budget data and sales data in one table in SQL or separate it. Also, if I add descriptors into the table, this will only increase record sizes and reduce the value of caching by padding each record out with repeated data. Is using small descriptor tables at run time...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can we Use SQL 7 in Visual Foxprox

    Dear Friends, in my company we are using Visual basic with SQL, in VB we have very problem to create Text files, But We Good Know Foxpro (easily create text file in visual foxprox), so I want to use SQL 7 in visual foxprox, Note : Many Link i see on net, but not all working. Please send me reply...

    Abhiindia15 pointsBadges:
  • Creating a table with three fields in SQL

    I need to make a table with these fields: prof_name varchar2(20) subject_code varchar2(5) dept varchar2(5) The constraint on this table is that one professor can take, at most, two subjects. This means that the name of the professor appear, at most, two times in the prof_name column. How could this...

    SQL Server Ask the Experts2,585 pointsBadges:
  • For Save .doc file in Sql Server 2000

    I want to Save Word File in SQl Server, how it is possible

    Karankhandelwal5 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