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

Latest Version
Posted by Anonymous Sender at 12/28/2003 7:16:33 AM
What's the currnt version (and SP) for SQL Server? ...more >>


Reordering
Posted by Dmitri Shvetsov at 12/22/2003 4:25:13 PM
Hi, I'm working with the MSSQL 2000 and C#. When I load my data from the database table in a DataSet I use the query to order all records by some column. Then I can work with these records, show them, edit, correct, insert, etc. It's done and works fine. The problem is to change the order...more >>

Problem defining a view!
Posted by Hallgeir at 12/22/2003 12:39:25 PM
I want to make a view so that it could be easier to work with the tables. I'm not very experienced but I manage to make simple views. My problem is this: In my table I have field called "Speed". In this field I find the values from 1 to 4. I want this field in the view to show "Very slow" instea...more >>

Strange MSSQL Error
Posted by news.starhub.com.sg at 12/22/2003 10:16:28 AM
Hi All, I have this strange error in my Event Log. The details are as follows, MSSQLSERVER: 18272 : I/O error on backup or restore restart-checkpoint file 'D:\Program Files\MSDE\MSSQL\backup\master4IDR.ckp'. Operating system error 3(The system cannot find the path specified.). The statement is...more >>

Help Plz - Bosses Son-in-Law and SQL server
Posted by John Thomas at 12/17/2003 7:18:46 PM
The bosses son-in-law is hacking around and "Trying" things :( Is there any ideas on allowing SQL access when he is inside our accounting application.... But limiting access when he is "Trying" things from outside the acct app? oh...did i mention he's an MBA :)...more >>

Data vanishing from SQL Server
Posted by dipankarganguly NO[at]SPAM hotmail.com at 12/17/2003 6:47:27 AM
Hi, Please help me to solve the following scenario. We are working on SQL Server 7.0 on Windows NT Server with Raid 5 . We are using a front end application through which all the things are done. For the last few days we are finding that certain sets of transactions are disappearing from ...more >>

DTS not connecting to oracle
Posted by ®arko Jovanoviæ at 12/16/2003 3:03:53 PM
It tells me client for Oracle not installed. I found an installation of the client but it's 200MB!!! Is this really it?!! tia Zarko ...more >>

Trigger Problem
Posted by masha at 12/14/2003 12:37:09 AM
Hi According to books online you can not write a trigger on system o temporary tables. But I want to know Is there any way so that I could write a trigger o system Table : SysObjects. Thanking You! Toee - mash masha@brain.net.p ---------------------------------------------------------------...more >>



Moving database from one SQL to Another
Posted by DavidM at 12/12/2003 4:52:17 PM
Hello -- I have employee that frequently needs to copy SQL Server databases from one server to another. The problem is, this employee doesn't know SQL Server and doesn't seem to care about how he gets the database copied and moved over, as long as it works. I've emphasized to the employee ...more >>

Tool for creating diagrams of stored procedures
Posted by adeveloper at 12/9/2003 8:40:32 AM
Hi, When you have a lot of stored procedures it seems like being able to produce a diagram showing the dependencies/relationships would be one of the best ways of documenting them. It would give an immediate overview of the code and make it much easier to understand. Ideally I think you coul...more >>

sum
Posted by stermic NO[at]SPAM gw.co.jackson.mo.us at 12/4/2003 7:59:29 AM
i'm trying to run a crystal report with a sum of a certain column of dollar amounts. the problem is that there are certain instances where some of the records are duplicated and unfortunately the duplicated dollar amount is added into the total at the end. i'd like to know how to prevent this fr...more >>

How to delete a temporary table (#MyTable)
Posted by Todd Cary at 12/2/2003 8:44:16 PM
I create a temporary table (e.g. #MyTable). However, in the same session, I need to delete it so that it can be re-populated. What is the best way to do that? Do a delete query against if it exists? Todd ...more >>

Import from excel file to sql server database.
Posted by hsphuah NO[at]SPAM usa.com at 12/2/2003 4:44:28 PM
Hi all, I have a problem to import an excel file format to sql server database. My problem is that one of record fields consists of numeric or alphanumeric. After the import the data, I found that only numeric field record were successfully import. The alphanumeric field record did not get im...more >>


DevelopmentNow Blog