Reindex DBF file from Ms-SQL 2000
Is it possible to reindex an extenal dbf file via linked server ?

Answer Question   |  August 18, 2008  9:51 PM
DBF file, Linked servers, SQL Server 2000

Database tables interrupted…..
Any input at all would be greatly appreciated – All I know is that a companywe provide IT Support to had 4 databases running when the SQL services were shut down on the server. Now the fellow cannot see any of his tables – nothing shows up when he opens SQL, or in his ODBC [...]

Answer Question   |  August 15, 2008  9:47 PM
SQL Server, SQL Server errors

SQL Subfile and position to ability
I have a subfile that can be sorted by any of 4 fields, so I want to use imbedded SQL to read the data out of my PF in order to populate the subfile. I want to be able to allow the user to enter position to information, and position to that entry – normally, [...]

Answer Question   |  August 15, 2008  7:03 PM
SELECT statement, SETLL, SQL Subfile, Subfile

i5/OS vs MS sequel server 2005
The powers that be would like to replace our 20 year old i5 home grown billing system with a .NET solution (partial) over MS SQL Server 2005. How do we convince the powers that be to keep & improve what they have or should we just surrender and start taking .NET classes?

Answer Question   |  August 19, 2008  2:54 PM
.NET, i5/OS, iSeries, SQL Server 2005

Job Database Mail to Sharepoint Server Entry
Hi…. I want to do … SQL schedule Job database mail to sharepoint server entry,,, Any idea to show the way. Coz I’m very new to sharepoint server. And I’m using SQL Server 2005 64 bit. Schedule Job database mail is currently working properly and I want to send these mail to SharePoint Server. Thx [...]

Answer Question   |  September 28, 2008  1:51 AM
Database Mail, SharePoint, SQL Server 2005, SQL Server 2005 (64-bit)

Executing System Stored Procedures
What kind of “Permissions” does a developer need in order to execute sp_fulltext_catalog, sp_fulltext_column, sp_fulltext_database, sp_fulltext_table, sp_addLinkedServer, sp_addLinkedSRVlogin ?

Answer Question   |  August 13, 2008  2:56 PM
Developers, Permissions, Stored Procedures

joining what is the diffrences between oracle proprietary join and sql 1999 compliant joins
what is the diffrences between oracle proprietary join and sql 1999 compliant joins

Answer Question   |  August 13, 2008  12:44 PM
Join logical files, JOIN statement, Oracle proprietary joins, SQL compliant joins

Access databases
I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?

Answer Question   |  August 29, 2008  2:26 PM
Access Database, Microsoft Access, SQL, SQL Server 2000

I need to move a sql 7.0 database to a different server running sql 2005.
What would be the best way to do that and will the jobs and DTS jobs come with the database? If not how can I move them also. Thanks for any suggestions.

Answer Question   |  August 13, 2008  2:21 PM
SQL 2005, SQL Database

SQL Server 2005 ‘alter user’
Hello, I have been trying to run the following instruction in QA use database_name alter user db_user_name with login = [domainlogin_name] but keep getting the error Msg 102, Level 15, State 1, Line 3 Incorrect syntax near ‘login’. I know this method exist in SQL Server 2005, are any of you able to run the [...]

Answer Question   |  August 20, 2008  12:45 PM
Alter user, SQL Server 2005, SQL Server errors

List the names and addresses of all employees who are Mangers
Employee (emplD, fName, lName, address, DOB, sex, position, deptNo*) Department (deptNo, deptName, mgrEmplD*) Project (projNo, projName, deptNo*) WorksOn (emplD* projNo*, hoursWorked) where Employee contains employee details and emplD is the key. Department contains department details and deptNo is the key. mgrEmplD identifies the employee who is the manger of the department. There is only one [...]

Answer Question   |  August 13, 2008  12:23 PM
SQL Database

Can’t Upgrade to SQL Server 2005
I am trying to upgrade a SQL Server 2000 SP4 standared edition running on 64bit Windows 2003 to SQL 2005. Since I am trying to upgrade, I am updating the Default instance. After selecting default instance, the wizard takes you to what components to upgrade; but the Database services is locked so it cannot be [...]

Answer Question   |  August 13, 2008  9:41 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades, Windows Server 2003 x64 Edition

Receiving an error in Quality Assurance on SQL Server 2005
I am trying to run the following command in Quality Assurance on SQL Server 2005: use temp alter user [MY-LP79EFIWXO93login_a] with login = [MY-LP79EFIWXO93login_b] However, I keep receiving this error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near ‘login’. Do you have any idea why?

Answer Question   |  August 12, 2008  4:26 PM
Quality assurance, SQL Server 2005, SQL Server errors

Copying a database from SQL Server 2000 to SQL Server 2005
I am using the Copy Database Wizard to copy a database from SQL Server 2000 to SQL Server 2005. I gave it the data file path on the source server (ex. SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLData), but it returns an error when I attempt to execute the package (“Access to the path ‘SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLDatactyis_before_migrate_data.mdf’ [...]

Answer Question   |  August 11, 2008  4:03 PM
SQL Server 2000, SQL Server 2005, SQL Server database

write multiple images from SQL database using response.binarywrite
It seems I am able to write a single image with the following code: ID1 = replace(request("ID1"), "'", "''") Dim connStr connStr = Application("DSNFPT") Dim rs Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "select [Image],[ContentType] from FPT_Images where ID = " & int(ID1) & " order by id desc", connStr, 2, 4 If Not rs.EOF Then Response.ContentType [...]

Answer Question   |  August 11, 2008  10:48 PM
Response.BinaryWrite, SQL, SQL Database, VBScript

Link Oracle 10g with Sql server problem
i have created a link between our Oracle DB and SQL server db it was succussfulty created and i was able to select data from oracle table using SQLServer. then i have created a view in sqlserver using this link to read from Oracle, the view was created create view dah_test as ( SELECT count(*) [...]

Answer Question   |  August 24, 2008  8:00 AM
Error 7399, Oracle 10g, Oracle error messages, OraOLEDB.Oracle, SQL Server errors

DTS of TEXT to BLOB or CLOB
Is there a maximum size to DTS from text to a Blob or clob ?

Answer Question   |  August 29, 2008  7:55 PM
BLOB, CLOB, Data Transformation Services, DTS

Database hanged due to concurrence
Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration issue? What should we check [...]

Answer Question   |  August 11, 2008  5:40 PM
Database performance and tuning, SQL Server 2000, SQL Server database, Windows Server 2003

Calling an Oracle stored procedure from SQL Server
Is it possible to call an Oracle stored procedure from SQL Server?

Answer Question   |  May 10, 2010  3:59 PM
Oracle, SQL Server, Stored Procedures

How to create new ramco test server?
Plz help me,when i restore my sql database with ramco backup then my database is restore but problem is that front-end not lounch in my system.

Answer Question   |  August 19, 2008  3:50 AM
SQL Server 2005, SQL Server backup