Groups | Blog | Home


Archived Months
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
all groups > sql server clients > june 2004 > threads for june 8 - 14, 2004

Filter by week: 1 2 3 4 5

LDAP from OPENROWSET
Posted by at 6/12/2004 1:05:26 AM
Anyone have a working example of a LDAP: call from SQL through OLE data access call? ...more >>


Prompt
Posted by Noor at 6/11/2004 3:18:43 PM
In oracle we use Prompt like in the run time it prompt to give input like insert into test (id, name) values (&id&, &name&) How can I fulfill this in SqlServer ? Thanks Noor ...more >>

How to remove a ' from a field
Posted by Jon Hirasaki at 6/11/2004 12:41:02 PM
I need help removing a ' from a field...more >>

Table locked by Firehose Mode
Posted by Tony Myhrberg at 6/10/2004 7:37:24 AM
I have a table in SQL Server that sometimes cant be updated because the table is in "Firehose Mode". There is an article (KB237398) about this and the solution is to list all rows with enterprise manager and that helps. Thge problem is that the table continously get into firehose mode. We ...more >>

Deadlock Problems
Posted by Farhan Iqbal at 6/9/2004 11:37:10 PM
Hi all Now a day I am facing too-many deadlock problems, is there any way or possibility that I make automated job, for diagnose the deadlock victim and kill that process. Any advice will be greatly appreciated. Farhan Iqbal ...more >>

One question
Posted by Noor at 6/9/2004 11:24:02 AM
I want to ask one question regarding optimization point of view like I have one table named ExerciseDetail and when any updation perform from the front end so first we delete all the records in Exercise detail against specific Exercise Plan ID and then again insert all the records so can any bo...more >>

SQL through Front Page
Posted by art at 6/9/2004 11:01:06 AM
What do you do when you are doing a search of a SQL database through Database Results Wizard and an asp page and the error comes back Database Results Erro The operation failed. If this continues, please contact your server administrator Nothing in the event viewer on either the web server ...more >>

EM slows windows
Posted by Andy Mous at 6/9/2004 7:08:54 AM
Often, EM running on my desktop will cause all other windows either to refresh very slowly or not at all. (I may get a border with some of the display) I can't navigate to any window completely until I shut down EM. SQL 2000 running on Win2k. Thanks....more >>



when I try to add an ODBC connection
Posted by Dave at 6/9/2004 6:18:31 AM
This is the message that I get; "The setup routines for the SQL Server (32 bit) ODBC driver could not be loaded. You may be low on memory and need quit a few applications." Running Win XP Pro SP1. PC has 256 MB of RAM. Pagefile is set to a maximum size of 1500 MB. Why do I get this ...more >>

Logshipping error
Posted by Noor at 6/8/2004 7:03:29 PM
I have received the following error in the logshopping=20 3041 : BACKUP failed to complete the command BACKUP LOG [LMS] TO DISK =3D = N'D:\Program Files\Microsoft SQL = Server\MSSQL$XORBIX\BACKUP\LMS_tlog_200406081859.TRN' WITH INIT , = NOUNLOAD , NOSKIP , STATS =3D 10, NOFORMAT=20 Thank...more >>

GOOD URL OF LOG SHIPPING
Posted by Noor at 6/8/2004 1:00:20 PM
can any body give me any good URL from where I can buildup the good understanding of Log Shipping with practicle example Thanks Noor ...more >>

Active X sql error
Posted by Matt at 6/8/2004 10:35:42 AM
Sql Windows/32 ActiveX error ActiveX object creation failed-please check that your installation is valid. How can i fix this error? The user can execute the command on other machines except his own. Is there something Im missing? ...more >>


DevelopmentNow Blog