commandtimeout on privat adapter
Tue, 4 Dec 2007 10:03:01 -0800
Hi,
The adapter in an dataset, via generted code in VS2005, is defined private.
How can I set the commantimeout in this case.
For example, this a snipped from generated code on a dataset:
Public Overloads Overridable Function Fill(ByVal dataTable As
dsDeltaV.INTERFACEDataTable) As Integer
...
|
[SQL2005] equivalent to the SQL 2000 taskpad view in Management St
Tue, 4 Dec 2007 03:29:03 -0800
Hello,
I just installed SQL 2005, and I am looking for the information about my
file usage, as I was able to see in the taskpad view with SQL 2000.
Could you help me on this please ?
Thanks in advance,
Regards,
Vincent ...
|
how to find out if a TSQL table is being updated?
Fri, 30 Nov 2007 17:05:57 -0800
how to find out if a TSQL table is being updated?
for example if someone does an update to a table that takes a long time, is
there anyway for me to check the status of that update process?
...
|
DROP COLUMN
Sun, 25 Nov 2007 20:13:47 -0200
If I execute ALTER TABLE DROP COLUMN XX but the column XX has Constraints
there will be an error.
I should first delete the related Constraints.
Is there any way to delete all of the Constraints related to this column?
Should I navigate before for all of the constraints of the table and delete
the relat ...
|
Database Create fails from a client via eroom installation wizard
Fri, 23 Nov 2007 01:14:31 -0800 (PST)
I have a problem where I am trying to isntall emc's documentum e-room.
I have already posted on their forum with no help.
I have two 2003 servers. One has sql server 2000 sp4 and the other one
is configured as the sql client.
When I run the eroom wizard for a new site on the client, I enter the
information ...
|
How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation?
Wed, 21 Nov 2007 13:41:14 -0800
How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?
...
|
Terminal Services and SQL Server
Wed, 21 Nov 2007 08:34:02 -0800
The company I work for is thinking of implementing two new Windows 2003
servers, and is also wanting to update our backoffice software. The new
software uses an SQL Server Database, and so requires SQL Server.
My questions come from the fact we also have several remote offices that
connect via Microsoft ...
|
|
|
Question on CAL
Mon, 19 Nov 2007 20:49:01 -0800
I would like to know that I've upgraded SQL 7.0 server to 2000. some of CAL
licenses are still 7.0, Does it need to upgrading to 2000 as well? Where
could I find information about these at microsoft?
Thanks
Kcid ...
|
SQL Server 2005 Management Studio - Don't want to save every query
Wed, 14 Nov 2007 08:08:02 -0800
Query analyzer for SQL Server 2000 has an option to set the default action
when closing queries to "don't save." I can't seem to find this option in
the 2005 Mgmt Studio.
Is there a setting that I can change so it doesn't prompt me to save every
time I close an item?
Thanks,
Joe ...
|
MDAC compatibililty
Mon, 12 Nov 2007 10:00:00 -0800
I have an ERP system deployed which uses SQL Server, and we are currently
looking to update to a new version. The new version and the old version use
different MDACs, does anyone have any insight into any issues I should be
concerned about when running older software with a newer MDAC? We want to
run both ...
|
