| 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 Scheduled job (DTS Package) fails Posted by SAC at 1/14/2007 8:02:38 AM SQL 2000
I have a DTS package that runs fine, but when I schedule it the job fails.
What do I need to check?
Thanks.
...more >>
sproc reading while datestamping? Posted by BarryM at 1/12/2007 5:23:48 PM Hi,
I have a sproc which returns a row from my table.
The table has a field which is to contain the date when the row was last
accessed ( ie. read) by the sproc.
Can my sproc return fields from the row, while causing an update to the
row's timestamp field, during the same hit on the db ...more >>
Query Help Posted by Hulicat at 1/12/2007 3:57:23 PM Hello,
I am trying to query out of the same feild for separate results.
The query looks like this:
select trunk, start as StartCall from table1 where status like
'%dialing%'
That works, however; I also want to get this statment into the same
results.
select start as endcall from table1 ...more >>
Virtual Memory Setting Posted by Greg Lumpkin at 1/12/2007 11:07:45 AM All:
I have a Pentium 4 2.2 GHz laptop with 512 MB of RAM. I installed SQL
Server 2005 Express Advanced Edition on it last night and it said that my
hardware wasn't optimal for the installation.
After looking at upgrades this morning, I have decided to max out the RAM to
2048 MB to see ...more >>
Max function in the Where clause Posted by SAC at 1/12/2007 11:02:25 AM I have a Purchase Order Items table. Items are considered "Open" if the
Bill of Lading date is not older than 60 days from today. At that point
they are no longer seen on the Open orders lookup form.
Sometimes a partial shipment happens and I flag all the items on the order
that they are par...more >>
Problem with "AS" in query - Experts Posted by Aleks at 1/9/2007 7:32:23 PM I have an sql statement, as soon as I add the part :
----
h.FirstNm + ' ' + h.LastNm as spousename, h.POBCountry as spousecob
----
It gives me the following error:
---
Server: Msg 156, Level 15, State 1, Line 16
Incorrect syntax near the keyword 'as'.
---
The full query is:
---...more >>
Problem trying to connect to remote server Posted by John at 1/9/2007 1:53:08 PM Hi
I can connect to one remote sql server using sql authentication but not the
other. The error I get is;
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL S...more >>
obtain object's id Posted by Jack Zhong at 1/9/2007 4:19:30 AM I would like to obtain the object's id with codes in the same object.
For example, there is a piece of code in prDemo to get prDemo's object
id. I would like to code could be moved to other procedures or
functions without any modification. So this code should be able to
recognize its host pr...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
BULK Insert Errors Posted by Matt Williamson at 1/8/2007 11:46:42 AM I'm having a little trouble with a Bulk Insert. This is my first time
working with this, so I'm not sure what I'm missing here. I've read
everything I can find about Bulk Insert in BOL and from querying the
archive, but I'm not finding the answer.
This is the error I'm getting when attempti...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |