|
|
|
November 2004 December 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 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 transactions using SQL Server 2000 Posted by Noe at 2/21/2005 3:23:08 PM Does somebody know about how many transactions can SQL server run at the same
time?...more >>
SQL Server Not enforcing referential integrety Posted by Chris Malan at 2/21/2005 5:17:02 AM Yes, believe this if you will. Today I was told a customer table disapeared
with all the contract tables still there. CustomerID is the PK in
customerTbl and is a FK in all contractTbls - a 1:N relationship.
Apparently alll the contract tables were still there and if one looked in
them th...more >>
RAND() -function in UDF Posted by Geert Vanhove at 2/21/2005 3:35:03 AM Hi,
for generating high volume stresstest data, I created a UDF that generates a
variable lenght string variable for usage in load processes.
This is my script:
create function f_generate_string (@length int)
RETURNS varchar(4000)
as
BEGIN
DECLARE @i int
DECLARE @str varchar(4000)
S...more >>
How to Track Logins Posted by Mike Thomas at 2/20/2005 10:00:06 AM In SQL Server 2000, Developer Edition, is there a way to track logins, both
successful and unsuccessful, after the fact. Eg, is there a way, for
example, to view all login attempts for a previous date?
Many thanks
Mike Thomas
...more >>
L Posted by Mike Thomas at 2/20/2005 9:57:38 AM
I'm a programmer rather than a DBA and have been having trouble with using a
second computer to access and test some applications on SQL server. I am
using SQL Server 2000 Developer's Edition.
I have an SQL Server instance on Computer1 to which I am connecting to from
Computer2.
The S...more >>
Connecting to MSDE Database via home network remote computer Posted by David Block at 2/20/2005 12:29:01 AM Hello,
I have trouble connecting to the MSDE databsae via my laptop computer that
is connected to my home network. I have MS SQL Server (MSDE) running on my
main computer. I created a C# application to connect to the database from
both computers. When I try to connect from the laptop, I ...more >>
Using SQL from Upsized Access Database Posted by Jeff Teel at 2/18/2005 9:35:12 AM I am new to SQL and am needing some guidance on how to enter data into an
SQL database. When using Access I had a form to enter data or entered
directly in the table. Is there a way to get the Access forms to transfer to
SQL or a program to make the forms?
Thanks
Jeff
...more >>
Capture of Data from input stream Posted by rjblanch at 2/18/2005 12:51:02 AM Hi all,
I am fairly new at the SQL game, but I have a situation that I wish someone
could help me with.
I have a data feed from a PABX that sends call records out into the real
world. I need to be able to capture that data ("|" delimited and ended with
CRLF) and put it into a table that I...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Find All Empty Table in database Posted by Richard Thayne at 2/17/2005 4:57:46 PM I am looking for a way to find all the tables in my database that are empty.
I know how to do it on each one individually but that would take too long.
How can I do a mass find of all empty tables in my database? Thanks
...more >>
Find All Empty Tables in a database. Posted by Richard Thayne at 2/17/2005 4:55:13 PM
...more >>
Query to determine if a certain value exists Posted by Daryl Muellenberg at 2/17/2005 4:34:09 PM Basically I want to know if a certain value exists for a certain column in
the table. I don't care how many rows may contain that value, I just to need
to know if any row contains that value. Since it is a large table I don't
want to search the whole table. I want the query to stop as soon as it ...more >>
Stop default instance before install named instance? Posted by Maggie at 2/17/2005 8:19:03 AM Platform: Windows 2003. SQL Server 2k sp3a, already with a default instance
We are planning to install a named instance on the server that already has
default instance installed. We will follow the instruction from books
online( How to install a named instance of SQL Server 2000 (Setup)).
...more >>
SQL Developer Edition Posted by EricM at 2/15/2005 11:21:17 AM I am in the process of developing a web site for my company and would like to
use SQL Server. Our hosting company Crystaltech.com offers SQL DB's in their
hosting packages. Our company does not own SQL 2000.
My question is: Can we purchase SQL Developer Edition to design the DB and
maintai...more >>
Updating from CSV file Posted by Paul at 2/15/2005 1:49:04 AM This is probably such a bonehead question so forgive me. I have an existing
database that I need to import CSV files into it . That part I can do.
Where I am having my problem is when I have two items that are the same,
instead of updating the existing row it creates a new row. How would I...more >>
Needle in a haystack Posted by Chris Malan at 2/15/2005 1:49:04 AM I am a programmer, not a database admin or sysadmin, hence my stupidity when
it comes to SQL Server.
I have been asked to try and retrieve alll transactions enetered into a
certain table yesterday. There is no date field in the table that will help,
and nothing else either. A wrong amoun...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |