• 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:
  • Upgrading from SQL Server 2000 to SQL Server 2005

    I have been offered a free upgrade to SQL Server 2005 Express Edition, but I am very pleased with my current version, SQL Server 2000. If I decide to upgrade, will I have any problems with our network? We use languages like C# and Visual Basic often.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Checking for a transaction isolation level in SQL Server Profiler

    How could I check if a transaction isolation level is being used for a LINQ to a SQL statement in SQL Server Profiler?

    SQL Server Ask the Experts2,585 pointsBadges:
  • The specified module could not be found

    We are trying to install a software (on about 70 workstations) that uses a sql type database that is stored on our server. We all have Windows XP and our server is Windows Server 2003. About half the Workstations are able to connect to the database with no problems. The rest are unable to connect...

    Kc54555 pointsBadges:
  • Improving I/O performance on SQL Server 2000

    I have SQL Server 2000 SP4 running on an Intel Xeon 2.33 GHz CPU with a 2GB RAM server. We have a total of eight workstations connected to this server, and Performance Monitoring says that the Avg. Disk Queue Length is at about 20 when all users are working concurrently. My tempdb logs are at 500MB...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Email from SQL Server Management Console

    I have created a view in the SQL Server Management Console and was wondering if there was anyway I could email that view on a monthly basis? I know that I can send notifications but there doesn't seem to be a way to have it attach my view. Your help is appreciated, Dustin DLaw@Daniluk.com

    RoadDust390 pointsBadges:
  • PERFORMANCE ISSUE while inserting bulk data in a blank table from 2 different tables

    how to improve insert performance in insert into mis_fcr_all_txns_susp_temp (select * from mis_fcr_all_txns_combi a where exists (select acct_no from mis_fcr_all_txns_fraud3 b where a.acct_no = b.acct_no) and a.TXN_DATE BETWEEN (REPORT_DATE - 60) AND (REPORT_DATE - 30));

    031219805 pointsBadges:
  • SQL Server 2000/2005 Transaction Logs

    Quick Ques. Are transaction logs cummulative? If I have a database set to Full recovery mode; database being backed once a day and transaction logs being backed up hourly, if the database needs to be restored, can I just restore the last transaction log file? Will the last transaction log file...

    JCDBA20 pointsBadges:
  • Writing a query in SQL for use in SQL Server 2005

    I’d like to write a query that would allow me to view items with a characteristic of my choosing and filter out the others. Is it possible to write something like this in SQL and use it in SQL Server 2005?

    SQL Server Ask the Experts2,585 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