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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|