| Groups | Blog | Home |
|
March 2003 May 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 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 remove the job Posted by John at 4/28/2005 2:32:45 PM I am trying to remove the job but it gave me the following error.
---------------------------
Microsoft SQL-DMO (ODBC SQLState: 42000)
---------------------------
Error 14274: Cannot add, update, or delete a job (or its steps or schedules)
that originated from an MSX server.
----------------...more >>
Results are different Posted by John at 4/28/2005 12:00:00 AM why the following two query's results are different... any idea why?
select count(*) from MedicalHistory where CDate between '01/01/2001' and
'12/31/2001'
1728066
select count(*) from MedicalHistory where year(CDate) = 2001
1739088
Thanks in advance....
...more >>
ADO query restricting to SELECT Posted by Ajey at 4/28/2005 12:00:00 AM Hi,
Can I restrict INSERT, DELETE, UPDATE, INTO queries in ADO? I get the
query as input from user. Run it using ADO connection. Display the result in
grid. However I want to allow only SELECT queries. Is there a property on
ADO which allows this? Otherwise I will have to do the parsing mys...more >>
Problem with big data transfer Posted by oLiVieR CheNeSoN at 4/27/2005 12:00:00 AM Hi,
I have MSSQl 2000 , SP3 with WIn2000
when I transfer from one table to another, 115852 records, le server hangs.
I tried with 70000 records and it worked. even with 90000 records.
With more than 90000 records, the server hangs.
Any idea ? It might be a bug in MSSQLsvr ? any know...more >>
can't register server Posted by Tcs at 4/27/2005 12:00:00 AM I have SQL Server 2k, sp3a, on a w2k, sp4 box. I'm at home, where I
have no domain. I have two clients, one w2k Pro, sp4, and the other
XP, sp1. I'm using Windows authentication. Neither can register my
server. The error msg is the same for both:
<mysvr> - SQL Server does not exist or acc...more >>
Timeout expired. The timeout period elapsed prior to completion o Posted by Sachin Surana at 4/25/2005 10:44:04 PM Hi All,
We are using DAAB (Microsoft.ApplicationBlocks.Data) to execute stored
procedure from .NET But at times we get the following exception "Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding".
Would appreciate immediate ...more >>
Expert advised needed. Posted by John at 4/25/2005 9:30:56 PM Dear DBAs.....
I would really appreciate if any one give me good advise for that.
I had a table CustomerHistory in which there are 15 Billions of records.
Basically in that table we are archiving the data for last 5 years and we
use that table for reporting purpose.
Cust_ID INT
Ta...more >>
Partioning the table and View Posted by Joh at 4/25/2005 4:35:46 PM There was a MedicalHistory table in which contain 10 Billions of records so
I did partioning into five tables and
insert the data according to year. Now the problem is that when I run the
stored procedure from the table(Medical History) it took
5 seconds and when I run the stored procedure throu...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Size of the table. Posted by Joh at 4/25/2005 3:59:53 PM Want to findout the size of the table, how can I ?
...more >>
DataFile Posted by Joh at 4/25/2005 3:40:09 PM Select * into MedicalHistory_2001 from MedicalHistory where
year(Creationdate) = 2001
Select * into MedicalHistory_2002 from MedicalHistory where
year(Creationdate) = 2002
Select * into MedicalHistory_2003 from MedicalHistory where
year(Creationdate) = 2003
Before using the above three c...more >>
Log file size continuously grows Posted by Farhan at 4/25/2005 7:35:11 AM Log file size continuously grows, even I placed Simple Recovery mode. Any one
tells me, how can I prevent this problem?...more >>
very urgent Posted by Joh at 4/25/2005 12:00:00 AM
Dear Professionals
I want to ask one thing like my database recovery model is Simple and I am
using
Insert into table
select * from table (3226303 records)
Its filled up the log and my harddisk gone full, can any one let me know the
solution like I don't want Log to be saved.
...more >>
SQL Server 2000 client tools on XP x64 Posted by mark-seattle at 4/22/2005 5:32:08 PM Has anyone gotten SQL Server 2000 client tools (Enterprise Manager, ...) to
install on a XP x64 box? Everything I have tried results in Setup running in
memory, but doing nothing....more >>
Table Corruption Posted by Rogers at 4/22/2005 6:34:03 AM how we can solve the table corruption problem ?
Thanks...more >>
Offline use Posted by John at 4/22/2005 1:15:39 AM Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seem...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |