Have a table that has a field with various records (such as DOM45, IMK34, 3IMK). Can perform a LIKE command %IMK% and retrieve the records containing...

chop847

01-21-2004 03:12 PM
Quentin Ran

One way might be to use count(*) so it can use a non-clustered index to get the value. If your specifying the PK and it is clustered it will have...

Andrew J. Kelly

01-21-2004 03:10 PM
Andrew J. Kelly

These are the wait times that we have accumulated over about 48 hours (SQL Server 2000). (We subtracted the initial values, just after rebooting...

Jeff Williams

01-21-2004 02:52 PM
Geoff N. Hiten

I was wondering if anyone had any information on Yukon in regards to mirroring, and replication. I've searched all of Microsoft and I cannot find any...

Kerry Carlyle

01-21-2004 02:30 PM
Kerry Carlyle

Hi, One simple question. I have a DB with MDF+NDFs files and I want to restore/create its backup to a DB with only one MDF file. How? Thanks, PS: My...

Ian Hughes

01-21-2004 02:16 PM
ch

How is it possible to restore a DB from .BAK and .TRN files that aren't listed in the DB restore drop-down lists in Enterprise Manager? I've read...

Micah

01-21-2004 02:01 PM
ch

SQL2K SP3a Win2k Pro SP4 Probably one for people using perl for scripting. I'm having a problem scheduling perl scripts to run with sql agent. All...

01-21-2004 01:49 PM
Linchi Shea

I have run the sp_cycle_errorlog SP about 5 times and it does not create a new errorlog in the C:\Program Files\Microsoft SQL Server\MSSQL\LOG...

David

01-21-2004 01:48 PM
ch

I have this error: SQL Server Scheduled Task: 43, 'BackupIBMDat - tempdb' -- Status: Failed -- Task Invoked on: 1/21/04 1:30:00 AM -- Message:...

Whill

01-21-2004 01:23 PM
ME

Hi, Can someone please tell me the expected behavior of a stored procedure when called via an ADO command object. My question is, if ADO hits a...

Dan Coates

01-21-2004 01:23 PM
Mary Chipman

Hello, Wich command DBCC can rebuild all indexes in my database? Thanks LeandroLS

Leandro Loureiro dos Santos

01-21-2004 01:20 PM
Paul S Randal [MS]

Hello, does anyone know what could be wrong? There's a lot of similar entries in the SQL Server current log: 2004-01-21 17:54:00.01 spid57 Starting...

Fabio

01-21-2004 01:15 PM
Fabio

When reading SQL Server 7 books online for detaching a database, there is an option called skipchecks. If skipchecks is set to true, update...

Erin

01-21-2004 12:48 PM
Jasper Smith

Hi, I knew the MCDBA contains 3 required exams and 1 elective exam. 1) Can someone tell me, if I am not go to the training classes, just buy books...

Jenny

01-21-2004 12:39 PM
Steven S. Warren

I need to change the ip address and machine name on a server which I have sql server 7.0 enterprise edition running on. Is there any specifics to be...

kbf

01-21-2004 12:23 PM
Thirumal

We have a server with Win2K, SQL Server 2K SP3a. We have an helpdesk database on this server where helpdesk application uses. When I open the...

Tom

01-21-2004 11:40 AM
Andrew J. Kelly

Just wondering, I've never used the "Backup Device" feature that is under the "Management" folder in Enterpise Manager. What are some good reasons...

Kelly

01-21-2004 11:38 AM
Andrew J. Kelly

I have two computers that are on a LAN, both with Windows 2000 server, but NOT defined in any sort of "official" domain; just "peers." Can I set up...

Larry Woods

01-21-2004 11:27 AM
Quentin Ran

I'm working with a database server placed in a datacenter remotely placed from my work location, and accessing the database through Enterprise...

Sunil Dash

01-21-2004 11:13 AM
ME

Hi When we open the table in design mode in Enterprise manager, there is a provision to enter the description of the field. I would like to know in...

Aditya

01-21-2004 10:56 AM
Aditya

sql2k sp2 A long running query in QA produced this message:(snippet) General network error. Check documentation. Unknown token received from...

chris

01-21-2004 10:52 AM
chris

This may seem like stupid question but I have been plinking at this for a while with no success so I have to ask: On a machine running win2k server...

mmac

01-21-2004 10:41 AM
mmac

hello i have to perform searches with the contains parameter not on a table but on a view. When i do this i get an error "no full text index...

Roland Osterode

01-21-2004 10:27 AM
Hari Prasad

Hi I am trying to test out SQL server running on a Windows 2K machine. I was told how to get around the sql server install so that i could install it...

jp

01-21-2004 10:20 AM
Steven S. Warren

I have a 2MB SQL Server errorlog and would like to delete alot of worth less information out of the file? Will there be problem with SQL Server with...

Dan

01-21-2004 09:16 AM
Vishal Parkar

Hi, I have a database thats around 7 GB in size. Out of this the LDF file alone occupies 5.5 GB. Can I somehow backup this LDF file and delete this...

Karthik

01-21-2004 08:36 AM
Karthik

Hi all, We use SQL Server 2000 and I had a table with several million lines that was 4GB in size. To reduce the size, I deleted all the rows, but...

Don Saluga

01-21-2004 08:00 AM
Don Saluga

I want to use full text indexing. I have read you need to leave 50MB spare on the server. Is this per index,database or instance of SQL Server and...

Chris Kennedy

01-21-2004 07:51 AM
Chris Kennedy

I have TWO networked servers; one production, and one backup. I want to be able to use the backup in case of a production server failure. The loss...

Larry Woods

01-21-2004 07:19 AM
Larry Woods

I have a Win 2000 server running a SQL 7 Database. I am going to upgrade it to a Win 2003 server running SQL 2000 My question is what is the best...

Chris Coates

01-21-2004 06:56 AM
Ray Higdon

Our MIS staff recenlty moved the network to active directory - since then when a node on our active/active cluster moves to the othe node it takes...

rheath

01-21-2004 06:31 AM
rheath

Hi, I have a backup of a database which is around 1.5 GB in size. Whenever I restore the database via EM I get both the MDF and the LDF...

Karthik

01-21-2004 06:06 AM
glenvictor

I want to do query like this select id=startmm,hit=count(id) from memlog2003 where (memid1=10005143 or memid2=10005143) and startyy=2003 group by...

davidw

01-21-2004 04:15 AM
Harag

Hi, I want to write this SQL script --- create table table1( ID_TABLE1 varchar(15) not null constraint PK_TABLE1 primary key...

Antoine C.

01-21-2004 03:13 AM
Antoine C.

Hi, I have a user database 'MyDatabase'. There are various Tables in this db. After executing a complex query I get some statistics , which I have...

Chip

01-21-2004 02:19 AM
Chip

hi All, I have a 2.5 GIG SQL2K SP3 database with an Access XP front end application. As the database grew, the responce time has degraded...

Sam P

01-20-2004 09:34 PM
joe chang

Hi everybody. I'm trying to shrink my 100GB SQL 7 database but nothing happens. I've already tried to shrink using T-SQL and EM, but neither worked....

Thiago Santinon

01-20-2004 07:07 PM
Sérgio Monteiro

I need to put a series of records in two columns of an Excel file into an MSSQL database on a server I am connected to over a LAN. On my computer I...

Usarian

01-20-2004 06:29 PM
Narayana Vyas Kondreddi

Are there any benefits in choosing OLE DB interface instead of using the native DB-Library connectivity? What is recommended? Thanks, Adam

Adam Ticktin

01-20-2004 05:57 PM
Erland Sommarskog

After I followed the instructions on the the following document , When I'm restoring SQL 7 from one machine to another , It looks like everything...

Fulya Erol

01-20-2004 05:43 PM
Fulya Erol

I remember some time ago, coincidenteally, by browsing around in system tables, I saw a place where I could see which clients were connected to which...

Lisa Pearlson

01-20-2004 05:20 PM
Lisa Pearlson

I have a Standard SQL Server User Account when I tried to update the Database Role for a corresponding database it requested a password. What would...

Dean

01-20-2004 04:58 PM
Jasper Smith

We are looking to install SQL Server and want to purchase a new machine for it. Are there any particular machine models that are known to work well...

Me

01-20-2004 04:47 PM
Andrew J. Kelly

I have a transaction log that is ~1GB in size of which all is being used. I backup the transaction log and it now only uses ~500MB. When I attempt...

Kevin

01-20-2004 04:00 PM
Aaron Bertrand - MVP

SQLServer 2000, SP3 I have SQLMail setup and working on this server, except it will only send mail when the Outlook client is open. I've done just...

Kevin

01-20-2004 03:14 PM

I am trying to create a new database, say name YYYData. I designed it in Visio and created a .DDL file. When I opened the file in Query Analyzer...

EagleRed@highflyingbirds.com

01-20-2004 02:41 PM
EagleRed@highflyingbirds.com

If the autogrow is set on a database primary file group when does the server actually grow the file? Does it wait for an out of space condition or...

Kirk

01-20-2004 02:10 PM
Quentin Ran

The maintenance plan when run with -RebldIdx causes the Data file shrinkage from a manully expanded file. I expanded a database file and ensured that...

Henry Jartu

01-20-2004 01:47 PM
Henry Jartu

Hi everyone, I am new in the MS SQL server world in cluster. I am in the process of implementing a cluster of SQL server 2000. Some of the IT...

Wilfrid Ertaud

01-20-2004 01:26 PM
oj

Does anyone know the maximum amount of RAM supported by SQL Server 7 enterprise edition running on Windows 2000 advanced server Thanks

F Aguilar

01-20-2004 01:25 PM
Andrew J. Kelly