Hello there, I need your help getting a sqlserver agent job up and running. Background: - We have a database that is fed syslog information. ...

Von

07-08-2003 12:07 AM
Von

what command do you put into a bat file to shut down and restart the sql server. I have "net stop mssqlserver" to stop it wrks using the run command...

Jim

07-07-2003 08:01 PM
Greg Obleshchuk

Michael (michael_baker (AT) advantexmail (DOT) net) writes: I get the impression that the lines have been wrapped. That makes it kind of difficult...

Erland Sommarskog

07-07-2003 07:31 PM
Erland Sommarskog

I'm stuck trying to get a trace file (I should say files since I've tried about 30 of'em) to work with the Index Tuning Wizard. In Profiler, I've...

jordan

07-07-2003 06:42 PM
jordan

Does anyone know about free tools like MS ISQL ?

Dumitriu Sorin

07-07-2003 02:54 PM
Aaron Bertrand - MVP

I cannot seem to find a group where this question would fit so I am posting it here. I have what I believe is a unique situation. I am using SQL...

Devin McMahon

07-07-2003 11:42 AM
Devin McMahon

When I script out my user-defined functions & attempt to install them on another system, I receive object-not defined errors because a udf (toward...

Peter

07-07-2003 10:45 AM
Peter

I just do not know what is SQL Service Control Manager. Thanks for explanation in advance. Deda Zheng

dzheng

07-07-2003 09:34 AM
Andrew J. Kelly

there's some question with me: how can I automatically start a trace everyday? I made a script on my trace information by SQl profiler but there was...

M

07-07-2003 06:07 AM
M

Question a) Its possible to do this by using the "syscomments" table. This table contains the source for the objects that you ask for. Only thing...

SriSamp

07-07-2003 04:35 AM
SriSamp

At our work we have a few database servers, and we often need to develop and run the same SQL script over each of the database servers. This causes...

Brian Oberman

07-06-2003 11:38 PM
Brian Oberman

I've been in the database industry for a long time and have seen some trends and fads come and go, but a tool I've seen recently will form an...

Dave Swan

07-06-2003 05:00 PM
Dave Swan

Hi, I need to learn How to use OEM(Oracle Enterprise Manager) to moniter sql server 2000. Can anyone help me and give me some website or...

dzheng

07-06-2003 05:59 AM
John Bell

John, I would be interested in how you find performance. Regards, David Penney www.metamatrix.com "John Peterson" <johnp (AT) azstarnet (DOT) com>...

David Penney

07-05-2003 07:09 PM
David Penney

What version are you trying to install? For instance, I can't install the standard edition tools on my workstation, but I can install the desktop...

Brad Casey

07-05-2003 06:30 PM
Erland Sommarskog

You can set the default path in EM. Right click on the server name and choose properties, then go to the database settings tab. For an indirect...

Cindy Gross

07-04-2003 09:11 PM
Cindy Gross

Hi : Is it possible to obtain the number of rows returned from a query while tracing using sql profiler. I am using microsoft sql server...

Gayathri Jayaraman

07-04-2003 05:31 PM
Largo SQL Tools

Hello, how can I clean my transaction log? (newbie question I know). Actually automatically clean when it is has a restricted file...

aleXsticY

07-04-2003 02:54 PM
Ray Higdon

How do you get to use SQL profiler. Is there a seperate .exe that you have to run to get it to work? When I click on it it says "profiler.exe is not...

Bob

07-03-2003 04:16 PM
Maciek Sarnowicz [MSFT]

First of all where do I get the Northwind sample (or equivalent) database for SQL 2000. Then how do I install it? Mike

Michael Lang

07-03-2003 01:32 PM
Michael Lang

Copy times seem to be normal. The backup is running at 80 kb/s vs the normal 800 kb/s

Andy B

07-03-2003 10:50 AM
Andrew J. Kelly

Hi all, Whereas using SQL7.0 and SP3.0 on Win2000, I use Profiler tool of SQL 2000. I'd like to know how can I catch up and display the transactions...

FatihMK

07-03-2003 10:03 AM
FatihMK

I have updates SQL Server 2000 SP3 and Books online SP, when trying to open books Online the error message come up with "can not open the file:...

Huu Le

07-02-2003 06:11 PM
Huu Le

There are quite a few statements, principally revolving around CREATE that have to be in their own batch - CREATE PROC for example. So if I were to...

bob

07-02-2003 02:47 PM
Kalen Delaney

check out DB Ghost at www.dbghost.com .It gives you the ability to version your database using source safe (all something like it) for all your...

mark baekdal

07-02-2003 12:54 PM
mark baekdal

Hi Marc, I think you need to reinstall the client tools and re-service pack. HTH, -- Greg Low (MVP) MSDE Manager SQL...

Greg Low \(MVP\)

07-02-2003 07:12 AM
Greg Low \(MVP\)

I've ran into a situation since moving to SQL 2000 SP3 that appears to be a bug when using Enteprise Manager (EM). If you are looking at Properties...

Doug Werner

07-01-2003 05:58 PM
Jasper Smith

Can Enterprise Manager and Query Analyzer be installed on XP Home Edition? I tried this and it just doesn't appear to get installed even though I...

07-01-2003 12:18 PM

Phil, I attended TechEd this year in dallas and there was a session on database consolidation by Phem Mehra. I don't know if you hace access to...

Carlos Eduardo Rojas

07-01-2003 12:13 PM
Carlos Eduardo Rojas

You can also read about recovery modes in books online. Maybe you can just use simple, if you don't need to take backups of your transaction...

Carlos Eduardo Rojas

07-01-2003 12:10 PM
Carlos Eduardo Rojas

I have checked all of the options in the reverse engineering dialog boxes...they all come out onto my visio drawing but they do not have arrows or...

jeremiah johnson

07-01-2003 09:09 AM
jeremiah johnson

How to clone an existing production running SQL2k SP2 on a Different Machine running SQL2K with SP3. Transfer all user logins and security roles and...

Atiq

06-30-2003 01:46 PM
Andrew J. Kelly

Hi everyone, We have been encountering the following message at the end of the error message when viewing the history of a SQL Server job after it...

Sergio

06-30-2003 11:22 AM
Sergio

delo5858 (smdelo (AT) bellsouth (DOT) net) writes: Could you make it with the Evaluation Edition in the mean while? It's valid for 120 days, so it...

Erland Sommarskog

06-29-2003 05:57 AM
Erland Sommarskog