Archived Months
January 2003
March 2003
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
July 2007
August 2007
September 2007
October 2007


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



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


DevelopmentNow Blog