|
|
|
January 2003 March 2003 April 2003 June 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 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 July 2007 August 2007 September 2007 October 2007 |
cryptoAPI Posted by Andy Atherton at 7/31/2004 1:27:11 PM When using SQL 2000 personal desktop (i.e MSDE) on win 98 Machine with our
VB6 application we sometimes get this error
[Microsoft][ODBC SQL Server Driver][SQL Server]CryptoAPI function
'CryptAcquireContext' failed.
Error 0x8009001d: Provider DLL failed to initialize correctly.
On Win2000/20...more >>
Connect from sql query via IP adress - is i possible? Posted by Just D. at 7/31/2004 12:23:11 PM Does anybody really know is it possible? We don't want to create a linked
database, but we need to make some steps on the remote database, gather some
data and then send this data to our main server via IP connection, setting
the connection every time when the remote server wants to transfer the ...more >>
Job Scheduler fails and Managing Tempdb Posted by babalwa NO[at]SPAM hotmail.com at 7/28/2004 2:28:09 AM Hello,
I have two issues, hoping someone can help.
Issue 1. I have various DTS packages that copy data from Progress
Database to Sql Data Warehouse. The ODBC Connection is stable and
packages have been auto scheduled by creating a job that is managed by
the SQL Agent service to run daily ...more >>
Maintaining versions in the database Posted by kbalusu NO[at]SPAM yahoo.com at 7/26/2004 2:09:23 AM Due to the nature of our development, we have to modify our database
btn successive releases ( all of them are simple enough like adding a
column). I am wondering how to effectively control the sync btn
release and database.
For exampe our release 2.1 and release 2.2 might not run with the same
...more >>
Size of SQLServer databases with indices Posted by barthome1 NO[at]SPAM comcast.net at 7/23/2004 7:47:28 AM Hello,
I am starting to examine using SQLServer instead of Oracle. I went
through the SQLServer import utility to copy tables from Oracle into
SQLServer. I then checked the size of the database.
I then started to specify indices for the tables. I did not see the
database file size grow a...more >>
EXEC Command with 'EXEC' as parameter fires twice Posted by mark at 7/22/2004 10:34:52 PM I created the procedure below in a SQLServer 2000 environment to export a
SQL query to a log file. The procedure exports all of the records correctly
but the procedure is executing 'someproc' twice.
Any help will be much appreciated.
Thanks,
Mark
CREATE PROCEDURE sp_queryToFile
@...more >>
hi.. newbie... Posted by Andy_HR at 7/22/2004 7:19:37 PM hi i'm new areound here so i dont know if i'm posting in the right news
group... i have a litlle problem...
i have a table with a product id and quantity on stock then i have a table
where my partners product id i conected to my product id ... and then i have
a insert into statemanet that conn...more >>
Incorrect Syntax Posted by GitarJake at 7/19/2004 3:27:42 PM Hello all,
Newbie here.
SQL 2000, Windows 2000
I'm trying to alter tables in my SQL DB using statements like the following:
/* AD_GROUPS */
alter table AD_GROUPS alter column AD_GROUP_NAME nvarchar(64)not null
go
/* ARTICLES */
alter table ARTICLES add column CONTENTTYPE_REF int nu...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Logging in irrespective of database access Posted by Laphan at 7/15/2004 7:21:55 PM Hi All
Wonder if you could shed some light on a really weird problem.
Basically we use a standard client side app that comms with 2 x SQL 2000 db.
This SQL 2000 db sits on a Win2003 Server quite happily.
The client apps sit on WinXP or Mac OS 9 quite happily.
In SQL Enterprise Manager...more >>
database entries Posted by dp at 7/9/2004 5:43:54 PM Im a newby to SQL so forgive me if this is a stupid question.
If I make an entry in my application can I query the database to return any
entries in any table that has been updated by the entry in the application?
I know I can return from a single table by using the statement select * from
TABLE...more >>
restore 7.0 to 2000? Posted by frank brown at 7/1/2004 4:14:52 PM Can I restore a backup from a sqlserver 7.0 database to a sqlserver 2000
database?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |