|
|
|
March 2003 April 2003 May 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 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 |
Reading in mdf/ldf files Posted by charis at 1/30/2004 1:21:11 AM Hello.
I am completely new to SQL server. I have received an mdf and an ldf file
which were extracted from a SQL server. I want to translated them into
Microsoft Access or Microsoft Excel files (for analysis).
I have at my disposal MSSQLServer 7.0, and AccessXP, ExcelXP. Any help will
be appr...more >>
select KILL store procedure Posted by sightdev NO[at]SPAM yahoo.com at 1/29/2004 10:43:46 AM Greeting,
I would like to create a SP that will automatically KILL processes
older than six hours with app name ‘balloon'; I have a script that I
run and execute the pasted result from the select statement as below.
Any input will be greatly appreciated.
select 'kill',spid from sysprocesses...more >>
Remove a character from a string Posted by brianke NO[at]SPAM yahoo.com at 1/28/2004 12:00:35 PM I have a number of entries in a field called ProjectNumber. Some of
these project numbers contain an 'A' or 'B' at the end to indicate
prototype and released states, for instance 6183A and 6183B. My boss
now wants to eliminate the 'A' and 'B' from all the project nmumbers
since weno longer use...more >>
Install SQL 2000 Desktop Engine Problem Posted by Derek at 1/27/2004 5:15:57 PM Hi,
When I install MS SQL 2000 Desktop Engine on
a win2K computer, I got an error message:
"The instance name specified is invalid." and
then cannot proceed. Why ?
Please advise how to solve the problem.
Regards,
Derek
...more >>
How do I go about this search? Posted by tilli NO[at]SPAM weissenberger.at at 1/26/2004 5:05:40 AM Hi,
I have a relatively large database (lets say about 50.000 records) of
customers. Each time one registers, I want to check, if someone by
that address is already in the databaes.
The problem is, that each time you write an address, you write it a
bit differently. ie:
Martin Luther Kin...more >>
MVPS and friends, question for you guys. Posted by alexpeten NO[at]SPAM hotmail.com at 1/25/2004 6:01:25 PM Hi,
Please, consider me your friend. and think about the following. This
also apply to all the groups, not only where I post the message.
Before you reply to any of the question in the news server. Do you
think, What is the level of question you are answering?
How many times you reply rea...more >>
SQL 2000 performance diabolical when using 'delete from ... where X in (select Y from...)' Posted by nojunk_fixitdik NO[at]SPAM hotmail.com at 1/23/2004 2:17:53 AM I get a daily feed of customer records and 3 related tables. The
customer feed is of the order 60,000 records of which only 5,000 or so
are actually of any interest (in that they have records in the related
tables). Therefore we purge all the unused customers with the
following query:
DELET...more >>
min with a bit Posted by Not Me at 1/22/2004 11:06:56 AM Hi,
I'm trying to grab records with a priority over those marked as yes (-1) in
a certain field.
Trying "select id, min(bit) from tab group by id" does not work, as the min
operator doesn't work on bits.
Is there an alternative to my query?
Many thanks,
Chris
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Syntax help Posted by Peter Aitken at 1/21/2004 10:04:33 PM Can someone please tell this SQL novice why I get an "SQL Syntax" error with
the following?
UPDATE tblAttendees SET (DormName, DormFloor, DormRoomNumber)=('Angell',
'1', '101') WHERE iMISNumber='895'
--
Peter Aitken
Remove the crap from my email address before using.
...more >>
Network Question Posted by Ernie Adsett at 1/21/2004 7:25:10 PM We are developing with SQL 7 Developer Edition and planning to install
MSDE with the VB application. We received the following question from
the IT dept. of our client:
"Does your version of SQLServer database work well across a frame
relay wide area network?"
Should there be any problem...more >>
Passing a parameter into a LIKE command in a stored procedure... Posted by Fabio Papa at 1/20/2004 8:11:48 PM Hi All,
I am having quite a bit of trouble getting a certain stored procedure to
work properly. In my web page I have a list of checkboxes that post to the
url. When I retrieve the value for the "beds" checkbox list from the url it
looks something like "1,3,5,7". Now I want to pass this int...more >>
Latch wait time Posted by Paul at 1/19/2004 12:04:59 AM Hi,
I've got an SQL 2000 server with a few databases on it. I's been working for
2 years just fine.
But approx 3 months ago it started showing short periods of extreme disk
activity. No major changes in databases were made. The server is unavailable
when this is happening. I've set up a bunch o...more >>
Access migration to SQL/MySQL? Posted by Steve at 1/18/2004 9:54:00 PM Hello
I am looking for some advice about regarding the pros and cons for the
following.
We currently have several MS Access databases with the data held on
our local file server and each workstation holding it's own Access
front-end linking to those tables. We also have a website hosted
re...more >>
WIN NT Compatability Posted by Ken at 1/14/2004 3:39:08 AM I have a chance to buy a WIN NT Server with 2, 10K RPM SCSI drives with a P3
processor,etc, etc, The real question I have is that I will be runnning an
application that loads MSDE 2000. So, is MSDE 2000 compatible with WIN NT
4.0 or "MUST I" upgrade to Server 2003. I will have approximately 20...more >>
Help... float data resulting in inaccurate statistics :( Posted by The Enigmatic Mr. Jingo at 1/13/2004 12:24:25 PM I've got a problem stemming from the fact that our company's software
stores data (measurements) as float. What I am doing is calculating a
statistic (Cpk) that sometimes uses the standard deviation of the
data. Due to the inexactness of the float fields, I am getting back
non-zero standard devi...more >>
dbcc inputbuffer question Posted by fahyp NO[at]SPAM visa.com at 1/13/2004 8:04:09 AM Hi
got a weird one here;
a user wants to ensure that a sp is run only once. Hence, he wants to
somehow query the results of inputbuffer (spid) to find the procname
and compare against it.
Trouble is, we don't know where the underlying query/info is (its not
sp_who or sysprocesses).
...more >>
Database Copy... Posted by Nisha at 1/9/2004 2:55:53 AM Hi,
I am using SQLServer 2000, and I need to send a copy of my development
database to my colleague. He has installed SQLServer 2000 on his laptop.
What is the best way to do this ?
Should I send him the scripts to create the database along with tables /
procs etc. & then export the data in...more >>
Sql Server Notifications Posted by ddunipace NO[at]SPAM hotmail.com at 1/8/2004 8:34:27 AM Does anyone have any idea how I would go about creating an object that
can be informed of any modifications to a SQL data base. Specifically
a .NET object that can detect whenever a table is updated.
It is NOT possible to modify the database in anway, so I can't add
triggers etc....more >>
why does tempdb have a log file? Posted by doron_almog NO[at]SPAM msn.com at 1/7/2004 3:53:57 PM why does tempdb have a log file?...more >>
SQLServer developer edition on XP Pro? Posted by Gene Frassetto at 1/2/2004 7:04:43 PM I just bought a copy of SQL Server 2000 (with service pack 3a) that I
intended to install and run on XP Pro. My concern is that the requirements
list on the box do not include XP or XP Pro. Will SQL Server 2000 developer
edition run on XP Pro?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |