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...

Eric Chen

06-30-2003 06:09 PM
Andrew J. Kelly

How can I find when current database was restored?

Vodochnik

06-30-2003 06:08 PM
Narayana Vyas Kondreddi

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

Roberto Ortolano

06-30-2003 05:51 PM
Narayana Vyas Kondreddi

Our organization is currently running Windows 2000 Server. The fundraising software we use is scheduled for an upgrade and the maker says we must...

Allyson Brase

06-30-2003 04:35 PM
Allyson Brase

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...

Joe Sarna

06-30-2003 04:22 PM
Aaron Bertrand - MVP

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...

shev

06-30-2003 03:43 PM
Dinesh.T.K

Whatever number of files you have, the db backup should back them all up. Then you can compress them all, mail them all, restore the db with them all...

Awada

06-30-2003 03:13 PM
Will

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...

Alex

06-30-2003 03:06 PM
Andrew J. Kelly

I don't think so. The security administrators server role can manage logins for the server, but not limited to a subset of...

Mohammed

06-30-2003 03:00 PM
Quentin Ran

Approximate schema: CREATE TABLE Questionnaire_def (Questionnaire_def_id INT IDENTITY, Questionnaire_name VARCHAR(50) NOT...

Jacco Schalkwijk

06-30-2003 03:00 PM
Jacco Schalkwijk

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)

Mike

06-30-2003 02:48 PM
Narayana Vyas Kondreddi

Alan, Whats the database compatibility level? It should be 70 and above for ALTER TABLE.....DROP COLUMN to work You can check the compatibility...

Dinesh.T.K

06-30-2003 02:47 PM
Alan

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...

harvinder

06-30-2003 02:46 PM
Quentin Ran

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

Danny Presse

06-30-2003 02:19 PM
Dejan Sarka

We are planning to setup our live server to replicate do a transactional replication to a backup server. The live server will probably be licensed...

Patrick Nance

06-30-2003 02:14 PM
Patrick Nance

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...

Moh Abb

06-30-2003 01:29 PM
Aaron Bertrand - MVP

Hi, We have couple of big tables( 20 -4- Gig) in one of our database. These tables are on Primary file group. Due to high I/Os on these tables,...

Moh Abb

06-30-2003 01:08 PM
Moh Abb

sql2k sp3 I try to exec a remote proc: exec sqldev6.adv084.dbo.sel_abc and get the message: Server: Msg 18483, Level 14, State 1, Line 1 Could not...

chris

06-30-2003 12:39 PM
chris

The page in question has been corrupted. The page header (containing the page Id and the object/index ID) has been overwritten in some way....

Paul S Randal [MS]

06-30-2003 12:06 PM
Paul S Randal [MS]

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

Janice Gilbert

06-30-2003 12:02 PM
Dinesh.T.K

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...

Renato gVizuet

06-30-2003 11:46 AM
JC Wood

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...

Cristiana Martins

06-30-2003 11:42 AM
Aaron Bertrand - MVP

Hi, We plan to implement Disaster Recovery plan and system for SQL 2000 server and databases. SQL server is connected in headquarter network....

Milan Ojstersek

06-30-2003 11:04 AM
Flicker

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...

Georges

06-30-2003 10:15 AM
Vishal Parkar

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...

Bruce de Freitas

06-30-2003 09:56 AM
Bruce de Freitas

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...

Cristiana Martins

06-30-2003 09:48 AM
Cristiana Martins

This has been reported as bug. Check...

SriSamp

06-30-2003 09:29 AM
SriSamp

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...

Mattias Andersson

06-30-2003 08:56 AM
Bill Cheng [MSFT]

Hi, Performance issues are complex to troubleshoot on newsgroups. It depends on the actual environment. However, I can provide some general...

Bill Cheng [MSFT]

06-30-2003 08:48 AM
Bill Cheng [MSFT]

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...

John

06-30-2003 08:47 AM
Dinesh.T.K

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...

Mike

06-30-2003 08:13 AM
mike

After weekend restart of server, problem disappeared, so will not pursue further. Both VB Data View and Query Analyzer execution of Select statement...

Craig Hessel

06-30-2003 07:45 AM
Craig Hessel

appreciate your input <g> "John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote

SQL

06-30-2003 07:40 AM
SQL

Hmmm. I didn't consider that aspect of things, but that is precisely the symptom we were seeing. Each developer stress testing the app wanted to...

Matthew Bando

06-30-2003 07:37 AM
Matthew Bando

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...

Dan van Ginhoven

06-30-2003 07:29 AM
Jacco Schalkwijk

Hi, I dont know if this is the best place to post this problem, but I'm hoping that one of you might have come across it perhaps. I'm getting the...

LP

06-30-2003 07:08 AM
LP

There are three possible reasons for this which usually point to a restore that has been run from a backup. 1. It is still in the process of...

Mandar Naik[MSFT]

06-30-2003 06:58 AM
Mandar Naik[MSFT]

Thanks Andrew. Normaly, all of my query use a valid index. I think that many of these statistics have been create when we have built the database...

Jonathan Chretien

06-30-2003 06:44 AM
Jonathan Chretien

Also, since you have configure this server as a linked server, you may do the same thing via SEM, go to your linked server properties, and the...

Wayne Snyder

06-30-2003 05:44 AM
Wayne Snyder

If you are licensing in per seat mode, it means that each different user must have a license... This will work OK for your web app IF you know...

Wayne Snyder

06-30-2003 05:42 AM
Wayne Snyder

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...

yuhong Wu

06-30-2003 05:39 AM
yuhong Wu

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...

Bharath

06-30-2003 05:37 AM
Wayne Snyder

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...

Thirumal

06-30-2003 05:30 AM
Thirumal

I upgraded a SQL Server 2000 from SP2 to SP3. I have an ASP site running COM+/IIS5/ADO that are accessing the SQL Server using disconnected...

VKolev

06-30-2003 04:02 AM
VKolev

I'm using Small Business Server 4.5. The server with NT4 server Operating System was installed with Proxy Server, SQL7, Veritas 8.0, PK SmartMon...

Khoo Siau Chew

06-30-2003 02:40 AM
Khoo Siau Chew

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...

Lasse

06-30-2003 01:53 AM
Lasse

Check sp_help_job, sp_help_jobhistory, sp_help_jobschedule, sp_help_jobserver, sp_help_jobstep system SPs. -- Dejan Sarka, SQL Server MVP FAQ from...

Dejan Sarka

06-30-2003 12:40 AM
Dejan Sarka

Thanks everybody for all the insightful responses. In our design, most reports have a date and/or time argument. We have a replicated...

Chandika

06-29-2003 11:53 PM
Chandika

Geoff N. Hiten (SRDBA (AT) Careerbuilder (DOT) com) writes: This is not completely correct. You can say UPDATE STATISTICS tbl, EXEC sp_recompile...

Erland Sommarskog

06-29-2003 05:09 PM
Erland Sommarskog

Collation options depends on the version of SQL Server you are using. For SQL Server 2000 you have improved collations compatibility. Search in BOL...

Cynder

06-29-2003 02:13 PM
Cynder