| Groups | Blog | Home |
|
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 Failed at first hurdle. No localhost instance. Posted by JohnD at 6/7/2007 12:00:00 AM Hello All,
I'm very, very new to this and I seem to be stuck right away.
I've installed SQL Server 2005, and I'm trying to install the "Adventure
Works" sample. However, I have no localhost server running - so everything
fails when trying to connect. If I go to SSMS and try "New Server
R...more >>
SQL problem Posted by JL at 6/6/2007 5:27:40 PM I think this should be easy but I can not figure it out.
I have two tables:
Orders -
OrderNumber
SourceLocationID
DestinationLocationID
Locations -
LocationID
Name
Address
I want to run a query to retrieve the location data for the Orders
SourceLocationID and DestinationID, someth...more >>
SQl Server 2005 -- Access Forms Posted by thersitz at 6/6/2007 2:30:03 PM Hi,
i've imported into SQL Server 20045 a db built in Access 2003 -- using the
import data command on the SQL Server menu.
My question is -- is it possible to use the Access Forms I built to point at
the SQL Server and interface with the data in its new location? If so, can
you point me ...more >>
Arithmetic Overflow Posted by SAC at 6/6/2007 12:03:06 PM I get an arimetic overflow with this statement:
CONVERT(varchar(10),CONVERT(smalldatetime,[LESTDP]),101) AS BOLD
LESTDP is in the format 20070601
Any help would be appreciated.
Thanks.
...more >>
memtoleave and -g-switch Posted by TIwang at 6/6/2007 2:48:01 AM hi out there
On our Windows 2003 Servers w. sp1 running MS SQL Server2000 w. sp4 we see
from time to time that we get this error "cannot allocate 64k
continous memory" or "SQL Server could not spawn process_loginread thread"
which could be caused by nothing left in the "Memtoleave" pool - I ...more >>
Optimization and Integrity Error Posted by Gabe Matteson at 6/5/2007 3:41:36 PM
Is there any way to run an optimization and integrity check against the
master and msdb databases? Below are the log files. Thanks!
- Gabe
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'SRVDB1' as 'RRG\rrg-sqlserver' (trusted)
Starting maintenance plan 'System ...more >>
Newbie: Do I need to set a triger using Identity? Posted by Robert Johnson at 6/4/2007 5:51:34 PM In other words do I need to set a trigger or will setting Identity do the
trick. I got an error that the value was not there.. but according to MS
Server Management Studio the field is set to true and inital value is 1 and
to incrment by 1. Not sure why it didn't increment. Using Visual Studi...more >>
peoplesoft and sql 2005 Posted by SAC at 6/4/2007 10:54:18 AM Is there an odbc driver for peoplesoft so I can extract data from it?
If so, is it the Oracle one?
Thanks.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
sql mail not sending Posted by SAC at 6/4/2007 10:38:41 AM I'm using sql 2000.
I've set up sql mail to alert me when a dts package fails, but it hasn't
been sending anything. Then the other day I opened Outlook and it sent all
these messages.
I'm using Outlook 2003 and from what I've read I need to have it opened all
the time. Is there a way t...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |