Bulk Data Migration from DB to DB via Web Service
Thu, 28 Aug 2008 23:31:45 +0800
Hi,
As requested by customer, I need to allow a rich-client program (in C#) to
pass some data from local DB (MSDE) to the remote MS-SQL server, via WEB
SERVICE. (~1000 record each time) Since I guess there is no way to control
the transaction in the client side, my idea is to pass the entire data set
from ...
|
RE: KB948109 Windows Update Install Failure 66E
Thu, 28 Aug 2008 08:08:53 -0700
Hi,
i have tried anything from this tread.....but nothing
works.
Again and again he logs that he tried to remove another
patch and fails with this operation.
I run Vista x64 and SQL Server Express 2005....
I think in germany i get no free support for this product....
Dirk
*** Sent via Develop ...
|
Database diagram support objects cannot be installed
Thu, 28 Aug 2008 17:01:53 +0200
Hi!
i've created a database with several tables and two schemas. Now I wanted to
create a diagram but get the following error.
Database diagram support objects cannot be installed because this
database does not have a valid owner. To continue, first use the Files
page of the Database Properties ...
|
Migrating from SQL 6.5 to SQL 2005
Thu, 28 Aug 2008 07:54:01 -0700
I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. Can
I copy databases from SQL 6.5 to SQL 2000?
If not, I will need to install SQL 7.0. Will it install on XP Pro?
I have an install CD from MSDN but I can't find any product keys for a CD
this old. Any ideas?
Thanks,
BrianR ...
|
New to SQL 2005 and backing up databases
Thu, 28 Aug 2008 06:29:01 -0700
I have just started working in SQL 2005 and was wondering what the easiest or
standard way is to backup the databases on the SQL Server.
Thanks...Mike ...
|
i want to ignore the time aspect. Is there any parameters you can send to getdate() to specify return of just the date?
Thu, 28 Aug 2008 14:18:01 +0530
Dear All,
I want to compare a date with a getDate()
the problem is that the getDate() returns the time too...
hence 1/1/2004 >= 1/1/2004 13:21 is false...
hence 1/1/2004 >= 1/1/2004 is true...
i want to ignore the time aspect. Is there any parameters ...
|
Insert, Update Trigger with If update
Thu, 28 Aug 2008 00:21:01 -0700
Hello all!
I have a insert ,update trigger that fires when a specified column is
updated (if update). This is working well. But when a new set of data is
inserted into the table this trigger is doing nothing. I guess when a new set
of data is inserted into the table my specified column is updated(if update) ...
|
|
|
Problem with SQL script
Wed, 27 Aug 2008 22:01:01 -0700
still a newb at this, so i would appreciate a little help.
I keep getting an error of : The column prefix 'bur' does not match with a
table name or alias name used in the query
I am querying across 2 databases. "bur" is an alias (set in the same way as
the other aliases) , but it does not seem to be recognised ...
|
Erwin with Sql Server 2005
Wed, 27 Aug 2008 16:41:03 -0700
One of our clients is having a problem reverse engineering their database
with Erwin.
It seems to give them many error messages. I am not sure what their problem
is with the program but I assume that Erwin should be able to deal with
stored procedures, views and tables.
They tried running the script we ...
|
add a field to a SQL Query during run time
Wed, 27 Aug 2008 11:47:45 -1100
I have this query:
SELECT RIGHT('0000000000' + CAST(CHEKNMBR AS VARCHAR(7)), 10) AS
Check_Serial_Number, RIGHT('0000000000' + CAST(CAST(NTWPYRN * 100 AS INT)
AS VARCHAR(10)), 10) AS Amount,
REPLACE(CONVERT(VARCHAR(10), CHEKDATE, 101), '/', '') AS Issue_Date, VOIDED
AS Void_Indicat ...
|
