all groups > sql server misc > july 2003
Network Backup
Posted by Adnan at 7/25/2003 1:11:03 PM
I want to backup up one of my Database running on SQL Server 2000 on to
another machine on the network. I already have a Database Maintenace plan
set up which backs up the database on the same box. But now I want to back
it up on a different machine as a disaster recovery measure. Under the
Ente... more >>
PeopleSoft
Posted by parnelld NO[at]SPAM scc-fl.com at 7/14/2003 9:57:09 AM
Hey all,
I apologize, but is there a PeopleSoft group for those of us running
it on MS SQL Server 2000?
If not, does anyone know how to create one?
Thanks in advance,
Derek Parnell... more >>
SQL2000 - Restore point in time
Posted by mark NO[at]SPAM futek.com at 7/11/2003 6:20:48 PM
I can't restore from a full backup. Here is the situation:
One of our developers was working with one of the tables in database
and 'accidently' ran a 'delete' statement. All the records are gone.
This happened at 3:30 PM.
About 10 minutes later I backed up the database (with full backup).
... more >>
Strange SP Problem...
Posted by fredfreddy1892 NO[at]SPAM hotmail.com at 7/11/2003 7:23:48 AM
Got a stored procedure that works fine, but occasionally it begins to
give back odd data, but only to ADO in my VB applications. This only
happens to one database (on a server with over 40 identical schema
databases) and only to one stored procedure in that database. The
problem goes away tempo... more >>
query help?
Posted by Jerry Jackson at 7/11/2003 2:15:58 AM
using the sample data shown below....
inv id style color season size
1 ABC BLACK SUM S
2 ABC BLACK SUM M
3 ABC BLACK SUM L
4 XYZ GREEN SUM S
5 XYZ GREEN SUM M
6 XYZ GREEN SUM L
7 DEF BLUE WIN S
8 DEF BLUE WIN M
9 DEF BLUE WIN L
... more >>
Updating part of the text in an NTEXT field
Posted by Rocky at 7/10/2003 11:27:13 AM
SQL Server Version - 7
Table - Pages
Field - Content
Hi,
I need to update an ip address in an ntext field. I have looked at =
UPDATEXT, the trouble is the ip address does not appear in the same =
place within each row. The contents of the field were popuulated at =
run-time. I need to s... more >>
HELP: SQL script to backup all databases
Posted by NoSpam at 7/9/2003 2:40:43 PM
I would greatly appreciate some help, or a point in the right
direction, please. I am new to MS SQL Server administration, and
specifically scripting for MS SQL Server.
I want to create a SQL script that would list the names of all
databases to a text file, then I want to use a loop-statement... more >>
Need Web-Based DB Record Editing Tool
Posted by hoochiegooch NO[at]SPAM hotmail.com at 7/9/2003 6:01:23 AM
Hi, all.
Is anybody currently using a web-based tool
to add/edit/delete records to SQL Server 2000
tables? I've been writing my own ADO.NET &
ASP.NET code, but surely I don't have to do
all this myself! I played around with a
product named ASPRunner; they're exactly what
I need to do, but... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
nText
Posted by Rocky at 7/8/2003 11:19:27 AM
SQL Server 2000
I am trying to pull off a record from a table which has 2 ntext fields. =
How do I retireve all the information stored within these fields. =
Example code for query analyzer would be great.
Thanks for any help in advance
Rocky... more >>
Next SQL Version
Posted by mo at 7/7/2003 9:48:19 AM
We're just about to buy SQL Server 2000 but before we do we'd like to know
if Microsoft plan to bring out another version of SQL server and, if so,
when this might be.
Thanks for any responses.
... more >>
Newbie to SQL Server 2000 and would like to both learn it and prepare for 70-228 and 70-229
Posted by Cruz Gracia at 7/6/2003 9:59:07 AM
Hello,
Can anyone recommend good SQL Server 2000 book/material that is
comprehensive yet an easy read that also serves a good background to the
70-228 and/or 70-229 exams. I'm not a DBA (more of systems/network admin),
so I
want to concentrate on 70-228 first. I also want to KNOW SQL Server, ... more >>
"Query Contains Only Ignored Words" (#7619)
Posted by Dino M. Buljubasic at 7/4/2003 3:33:00 PM
> I am having a problem when querying data from database.
> Some of the queries throw an exception and I don't know how to fix it.
>
> The error I get is "Query Contains Only Ignored Words" (#7619)
>
> Any help would be appreciated
... more >>
|