all groups > sql server (microsoft) > august 2004 > threads for august 15 - 21, 2004
Filter by week: 1 2 3 4 5
CPU are not used properly...
Posted by roger NO[at]SPAM roditek.com at 8/19/2004 8:56:29 PM
Hello all,
I'm currently facing a performance problem. I tried different things
without finding the problem...
I have two machine on which I have installed sql server 2000.
The first machine (A) is running windows server 2000, it has 1 Pentium
4 processor and 1Gig of memory. Here is the ... more >>
Newbie SP parameter question
Posted by Kevin Counselman at 8/18/2004 2:28:12 PM
This seems like it should be simple, but I haven't been able to come up
with the magic.
I have a query like:
------
SELECT *
FROM tblSMSchedule
WHERE (strUser IN ('Kevin', 'Bob') )
-------
this works as desired. What I need to do is put this in a stored procedure
l... more >>
Check if table has changed
Posted by Blacky at 8/18/2004 1:49:54 PM
Hi
I'm not very experienced with SQL, so plz bare with me.
I'm busy developing a C# app that is accessing SQL Server 2000. I have to
check a table and update my screen if something in the table has changed.
How do I check if anything inside the table has changed?
Kind Regards
Nick
... more >>
2nd Try: Restore Database Dialog missing Backups (Archive BIT)
Posted by Doug Crabtree at 8/17/2004 11:43:40 AM
I have a strange problem with restoring files. I have one SQL server
installation that does not show any .BAK files that no longer have the
archive bit set. Is there a switch somewhere that I can throw to
change this back?
I have 3 other SQL server installations in different places that do
... more >>
User Defined Function: Convert String value of Table to Table Object
Posted by Erik Grob (MCP) at 8/17/2004 8:51:44 AM
Does anyone know where to find or how to write a quick user defined fucntion
that will return a table object when passed the string name of the table
object. The reason why I want dynamicallly set the table name in a stored
procudue WITHOUT using concatination and exec a SQL String.
Hence
... more >>
newbie needs help with different SQL versions
Posted by JSE at 8/16/2004 6:33:23 PM
Hello everyone.
I am brand new to the "SQL" and SQL software, and don't know very much about
it.
I am considering purchasing an network enterprise application that requires
Windows SQL Server 2000, but a single user version of this application will
work with MSDE (desktop) on a standalone ... more >>
|