|
|
|
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 5 Link tables Posted by SW at 1/31/2006 4:50:00 PM Hi,
Can anyone point me in the right direction for creating link tables in SQL
2000 standard edition?
I want to link to tables in a Intersystems Cache database.
Thanks in advance,
SW
...more >>
Log shipping and licenses Posted by SW at 1/31/2006 4:41:32 PM Hi,
I want to set up log shipping. I have SQL 2000 Standard edition running on
two instances of SQL server running on the same machine.
If I installed SQL server 2000 Enterprise edition on another machine, I'd be
able to take advantage of built-in log shipping functionality and it would
be...more >>
Convert Access query to SQL View Posted by Senthilkumar at 1/31/2006 12:00:00 AM Hi,
I have used an access table to create a chart report to show how many calls
were handled in a month. How do i conver the Access sql to MS sql server
view. Here is the access sql:
SELECT (Format([ComplaintDate],"mmm"" '""yy")) AS Expr1, Count(*) AS [Count]
FROM [Complaints]
GROUP BY (Fo...more >>
net without a server machine Posted by Sam at 1/31/2006 12:00:00 AM How to connect users to sql server in a small net where
users are connected to one of the PC's and there is no
server machine?
thanks
...more >>
get table and sp information Posted by Daves at 1/30/2006 3:16:17 PM hi,
is there a way to find all stored procs in a database and the date they were
updated? Also can I query some "master" table to find when the table schemas
were last updated? This because I'm trying to synchronise a project I'm
working on locally and remotely at the same time...
thx
...more >>
location of data files (changing this) Posted by Les Stockton at 1/30/2006 8:30:17 AM I moved a database from one server to another. After doing so, someone told
me that the data files need to be moved to a secondary disk. I'm needing to
know how to change SQL Server so that all of it's database files are located
somewhere besides the default location. How do I do this?
I w...more >>
a query quickie (for PROs?) Posted by Mika Myllyvirta at 1/30/2006 12:00:00 AM Hi,
Here is the problem:
I need to get all rows from TableA where TableB.Nbr is 5 and 10 (and
15). Example here:
TableA
======
Id, Title
01, Row1
02, Row2
03, Row3
Tables are related with Id and AId.
TableB
======
Id, AId, Nbr
01, 01, 5
02, 01, 10
03, 01, 15...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |