| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 Name part search. Stumped... Posted by redfoxk NO[at]SPAM hotmail.com at 3/21/2006 9:41:21 PM /*
I'm having a problem making a select statement to return the
correct results.
Here is an example of what I'm trying to do. Two tables:
@TblNameParts which contains the master list of all the name
parts and the MasterNameID which is a pointer to the master
record.
@TblCriteria which is b...more >>
DTS+ASP Posted by Aleks Kleyn at 3/21/2006 8:46:27 PM Suppose i create procedure in DTS and I want to manage call of this
procedure from ASP code. How I can manage this. I have SQL 2000 and for me
both ASP and ASP.net are interesting\
Thank you
--
Aleks Kleyn
http://www.geocities.com/aleks_kleyn
...more >>
focus bug in between ADP and QA Posted by aaron.kempf NO[at]SPAM gmail.com at 3/21/2006 4:12:13 PM Team;
I have seen this bug about 20 times in the past 3 years.
LITERALLY.
a) have an ADP open to the queries window
b) choose query analyzer on the taskbar
c) do something in qa
d) select access on the taskbar
Do you know what happens??
ADP sits there and automagically fires the spro...more >>
How to configure MemToLeave memory option? Posted by pshroads NO[at]SPAM gmail.com at 3/21/2006 2:12:32 PM I have been encountering errors on a couple of my SQL Servers and in
researching the problem I think that I may need to configure more
MemToLeave space. I have not been able to find any articles that
suggest how to go about calculating how much MemToLeave I need though.
I use AWE to a fixed 5....more >>
Backup/Restore MSSQL database from domain host? Posted by Noozer at 3/21/2006 12:00:00 AM My domain host provides Windows hosting, including MS SQL database.
Unfortunately it doesn't provide remote connections to their MS SQL server.
I can see no method of retrieving my database structure, or the database
populated with data, from the hosts control panel.
I'm sure that I could u...more >>
Find objects that access a particular column Posted by k0mput3r at 3/20/2006 12:26:54 PM Hi,
Is there a store procedure or a simple way to find all objects (
sps, views... ) that access a particular column of a particular table?
Thanks.
Komp.
...more >>
Memory allocation in MS-SQL 2000 instances Posted by dries at 3/17/2006 5:33:37 AM Hi,
From a previous sys-admin I inherited a a MS-SQL (2000) machine with 3
instances. It is a nice machine with 4 Gb of memory but the memory allocation
is very weird:
Instance A: 1400Mb
Instance B: 1000Mb
Instance C: 80Mb (!)
Instance C is performing badly under a bit of pressure which s...more >>
Alternative to OpenXML Posted by Shilpa at 3/17/2006 12:24:33 AM Hi All,
I want to pass XML and the data in the XML should be stored in the
tables of the database. However, I do not want to use the OpenXML
statement. Please let me know.
Regards, Shilpa
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
every user to take his id Posted by xxxxyz NO[at]SPAM abv.bg at 3/16/2006 4:00:07 AM Hi,
I have sql server 2005 database.
In one of the tables when a record is inserted I want to save the user
id from sysusers and the date of insert. So every user has to be able
to get his id from sysusers. I use this:
select uid from sysusers where name=USER_NAME(). But these users
haven'...more >>
migrating from 2000 -> 2005 as simple as ... Posted by RTL at 3/15/2006 7:01:52 PM ....detach and attach?
Regard article:
http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/
I have been trying to do research on migrating our SQL2000 to SQL2005 [on
another box] and have not found a lot of helpful information. This article
makes it ve...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |