Our company planning to migrate database server(Unix) sybase 11.9.2 . This database are avaliable in tape(DAT). I want to down load & convert to seq 7 or seq 2000 directly from tap to disk. If I am using dump statment it is showing error msg. Any one can solve this Issue. Thanking U r....more >>

Hi, there ! Can anybody tell me why the application MS ACCESS 2002 front-end + MS SQL Server 2000 back-end with the tables linked via ODBC is running perfectly well on LAN, and does not run on WAN ? The firewall and security issues excluded. Many thanks, Dmitri Kalinin...more >>

Hi, I have restored a database named 'TestDB' on my test SQL Server. To make it accessible with a billing module I use to delete the user in that database and once again use to assign permission to that user from Security > logins option. Today when i tried to delete the user from the ...more >>

Hi there, What we basically want is seperating the development and production servers. I need to transfer all the data to the new server from the existing server. My question is that what's a good way to transfer schema, tables and data from one SQL Server to another. I have tried export op...more >>

hi,i have a SQL server2000,there are some databases on the server,what I try to achieve is to limit access of each user. When they log into the server through "Enterprise manager", they can only view their own database but not all of them on the server. thanks...more >>

I had used to make full backup of a database and using winzip to compress the file to transfer it via email to another location. And because of the big email attachement of the compressed database I didn't succeed in transfering the data. Then I tried to alter the database as adding a secondary ...more >>

How can I find when current database was restored?...more >>

I just installed service pack 3a, and after the reboot I noticed that my sole server instance, which had been named, is now "(local)". Also, the previous instance name now shows up as a "remote" server. It appears that the old instance name *may* still work (as if an alias), or at least w...more >>

Hi, Is it possible to schedule a database backup with SQL 2000? I would like a script which would be run weekly and the backup file would be in the format: ..\backupYYYY_MM_DD.rtf Thanks, Georges ...more >>

Hello people, anyone has this problem? I'm seeing an object without owner in my database. So I cannot delete it or alter it. Anyone knows - how can reproduce this situation ? - how can it happen? - how can I detour it? The uid in sysobjects for this view is 33, but in sysusers I have no ...more >>

Hello, Had a system failure and the disk volume, where all databases were resided on, was gone. SQL application is on a different disk volume, and there is BAK copy for master, msdb and a user database. Who can share his/her experience or lead me to tech info links to rebuild the database? ...more >>

Hello is there a way to limit the transactions per second on a database or user bases on ms sql 2000? How? Thanks...more >>

We are attempting to install SQL 2000 on a new server running Windows 2000 SP3. Every time we attempt to install it we get an error. Error--Installation of the Microsoft Data Access Components package failed.(-1)--- Has anyone seen this before? Any solutions?...more >>

Hi I create a table with a field of varchar type,and when I insert values of chinese bracket and English bracket in this table,it seems the server can't distinguish the difference of them.follows is the script: 1.create table test(col1 varchar(10)) 2.insert into test values('(') --Engl...more >>

I have an SQL database that creates a lot of sleeping processes that have the AWAITING COMMAND command showin when I go into Current Activity-Process Info. These processes are created on ASP pages. It seems that after a couple of days, I need to restart the SQL server. Is the sleeping s...more >>

Hello, I hope you guys can help me with a problem that I am facing... I have started the MSSqlServer service and SQLServerAgent services with a domain username and password. There are periodic password resets to this user. Security policies within the company dictate that the password for thi...more >>

We have our website on a hosting server. In order for me to change fields in our database there, they said I need SQL Server. What should I buy? I just need the smallest, limited parts of SQL possible- for small simple changes. ...more >>

To date I've used nothing but MySQL and have loved it. The company I work for uses MSSQL and Access for their product database. Here is the situation: Product Manager has created a product database Products.DBF This file is saved on the same server as the SQL server. The goal is to ha...more >>

i have app running on sql2k ent. I recycled the sql log 3 times (sp_cycle_errorlog) and now i don't see errorlog.1 and errorlog.2 files any ideas why they are not there?...more >>

Hi, we have a problem with query and data can be reproduced as : create table dd1(dd int,dd1 int) create table dd(dd int,dd1 int) insert into dd values(1,10) insert into dd values(2,20) insert into dd1 values(2,20) insert into dd1 values(3,20) THIS STATEMENT WORKS ------------...more >>

Does anyone know how to search for more than one key word at a time in MS Access 2000? Example: Cars or Trucks (in a Memo field)...more >>

Over the weekend we did a hardware upgrade to our DB server and some drives did change. We have setup most of the DB back again, but the security is still in the master.mdf file. If we restore this file back we will loose everything that is working now. anyone know how to export the sec...more >>

Hi, Which SP in SQL that can give us the following info: Where SQL is installed (Drive letters) Where System DBs and Temp DB are. Which service pack SQL is on. Any feed back is appreciated. Thanks Moh ...more >>

Hi. I have a query where a single column is used as join key. In TableA the column is nvarchar and in TableB it is varchar. TableB has a clustered index on that column but the join will do a full table scan on TableB. When I convert the coresponding column in TableA to varchar the que...more >>

What type of field do I create for OLE objects? (text, ntext...) What field size? thks...more >>

Hello people, anyone has this problem? I'm seeing an object without owner in my database. So I cannot delete it or alter it. Anyone knows - how can reproduce this situation ? - how can it happen? - how can I detour it? I don't know... Thanks a lot Cris *** Sent via Develope...more >>

Hi, I have a lot of databases in my server, but the point here is that I cannot see none. When Enterprise Manager starts there's an error appearing: snap-in failed to initialize Name: Microsoft SQL Enterprise Manager CLSID: 00100100-1816-11D0-8EF5-00AA0062C58F After this e...more >>

(SQL 7 - Enterprise Edition) What is the minimum priviledge (sql server role or read/write to specific object ...) required to view jobs in SQL Server ? I want to avoid giving SYSADMIN role to some database user who needs to create, schedule nd maintain SQL server jobs. How is it possible...more >>

hi all, I have schedule some job which was working from last 3 months but suddenly last week it stopped working . normally it give next run date with not given and it show successful one last day but when try to run that it gives me error " Error 22022:SQl ServerAgent Error:Jobxxxx does ...more >>

In the relationships properties I have setup a relation between 2 tables. I did not check any of the boxes. I noticed then that a child record does not require a master record. What is required to force a child record to have a master record ? If none of the checkboxes are checked as I did in ...more >>

Hello. In SQL 7 Profiler, I want to get a trace of ONLY the statements greater then a specific duration, say 1000 ms. I set it to 1000 but I get a LOT of other statements in the trace, where teh startime and duration are null. How can I filter the trace to ONLY show the statements ove...more >>

Hi, I keep getting this error while trying to restore the database: "Exclusive Access could not be obtained because the database is in use. RESTORE database is terminating abnormally." I am sure though that noone has logged onto the system while I doing the restore but I keep gettin...more >>

Hi, We plan to implement Disaster Recovery plan and system for SQL 2000 server and databases. SQL server is connected in headquarter network. Recovery SQL server will stay on remote location (site) and it must have the most recent copy of SQL production databases. SQL server has 2 dat...more >>

Greetings! How do I add duration: 00:00:25 00:00:25 00:00:25 in a sql statement. I have been able to add just the minutes or just the hours with the following statements Here is the syntax to sum hours and minutes Select sum(datepart(hour,convert(datetime,Duration))) from re...more >>

Hi all, What is the best method to bring up a database, when tempdb is corrupt? I am not able to start the database server when there is a problem with my tempdb? Recently, when my master database file got corrupt, I copied the maser (master.mdf and mastlog.ldf) files from my weekend ...more >>

Hi All, We are having a lot of tables in an online database 'TRANS'. There are no clustered indexes in the tables. There are only non-clustered indexes in the tables. we do a weekly re-org of tables by creating and dropping non-clustered indexes. We are planning to configure transacti...more >>

Hi , Can any one of you tell why the below warning message appears. I have found this when i created a table. Also I would like to know what are the side effects on this table & DB, because of this warning. Warning: The table 'RawMailList' has been created but its maximum row size (...more >>

I'm connecting to a SQL Server 2000, sp3 running on Win2k Server, SP3, english version from a workstation with Win2k, sp 3, english version. The client software is written in C# and I'm using ADO.NET to connect. Occasionally I get this fault: Assertion failed! Program: ...\..\..\Myprog...more >>

Hi, Do sequences of transactions logs are broken when a restore occur ? Thank you danny ...more >>

I work on an ASP app where all the data is stored in tables that is shared by customers and segragated based on an ACCOUNTID column. In other words, all customers store their contact data in the contact table but they can only see the data that has their accountID. I have a new requirement to...more >>

When I renaming tables,columns below message comes to Query Analayaser Result Window. Is there any way to hide it, because this may hit performance if there are 1000's of columns updated Thanks Caution: Changing any part of an object name could break scripts and stored procedures. The COLUM...more >>