| 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 stored procedure not found !! ??? Posted by Henning Winkler at 5/28/2007 2:42:28 PM Hi all,
I have a problem with a database on sqlserver 2000 ( 120 days eval ed)
on Windows 2000.
My database had been appended from another sqlserver 2000. But now I
have problems to call a stored procedure.
This sp is called by a VB6 application.
First a command object ist created, a active ...more >>
Upgrade from SQL Server 7.0 to 2000 Posted by myrights99 NO[at]SPAM gmail.com at 5/28/2007 1:03:57 PM I am not able to get detail information from what as changed from SQL
Server 7.0 to 2000 from T-SQL commands, statements, syntax etc
standpoint. any help, whitepaper, URL will be highly appreciated.
Thanks
...more >>
storing docs in a database - how to upload? Posted by M NO[at]SPAM at 5/25/2007 10:33:32 AM I have a directory of files that I would like to upload with some data
to a table so that I can store the files in the db. I'm not trying to
parse files into rows, I want to stick the actual file in the column.
Is there some kind of insert script, or bulk copy that I can use?
I have about 150...more >>
Replication controls (for an SQL newbie) Posted by John F Kappler at 5/25/2007 12:00:00 AM Can someone point me at a website that might help me understand about
replication and its parameters (e.g. jobs and schedules).
We have SQL2005 on an SBServer 2003.
We have a third-party database application that lives on the server.
We also have four notebooks that keep copies of the appl...more >>
Time Out error for application Posted by rittyta NO[at]SPAM gmail.com at 5/24/2007 8:59:48 PM Hi,
One of my application with around 20 tables was workng fine for
quite a long time ...now it started giving error for users saying
"Time out period elapsed prior to completion of the operation or the
server is not respondig" My tables are not that big ..one of the
tables have 100000+ reco...more >>
BOL 2000 side by side with BOL 2005? Posted by Bruce at 5/24/2007 1:55:10 PM Hello,
Is it possible to have Books Online 2000 coexist with Books Online
2005 on the same machine? I currently have BOL 2000 on my machine and
when I try to install BOL 2005 side by side with it, it detects the
older version and insists on 'upgrading' me. If I decline the
'upgrade', the in...more >>
Why, after restoring a database, do I have to prefix all objects? Posted by atoner.spam NO[at]SPAM gmail.com at 5/23/2007 1:33:52 PM I recently implemented log shipping and wanted to test that the
shipped version of the database I was restoring to was operational.
So, I detached it from Sql Server, made a copy, and reattached it
under a new database name.
Then, I created a new server login called "sqlaccount" that should ma...more >>
AWE Configuration Posted by Praveen at 5/23/2007 10:45:05 AM I have windows 2000 Server Service Pack 4 and SQL Server 2000
enterprise edittion. System has 4GB of RAM. Can I use AWE feature.
Thanks.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SUBSTRING in User Defined Function - Invalid column Posted by jknaty at 5/23/2007 7:59:27 AM I'm trying to create a function that splits up a column by spaces, and
I thought creating a function that finds the spaces with CHARINDEX and
then SUBSTRING on those values would an approach. I get an error
saying that the I have an Invalid column 'Course_Number'. Not sure
why but I am very ne...more >>
select query... Posted by Oonz at 5/22/2007 9:14:06 AM Hi friends,
i have to select values from the table consider with the following
record:
No HomePhone WorkPhone Mobile
20 23232 98327
the selection have to be done as:
No DeviceType DeviceInfo
20 HomePhone, Mobile 23232, 98327
since there...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |