Archived Months
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 connect > august 2006 > threads for august 15 - 21, 2006

Filter by week: 1 2 3 4 5

(local)
Posted by Alberto Brivio at 8/21/2006 5:23:55 PM
Dear ALL, my environment is SQL 2000 SP4 on WIN2003 Server Standard. In enterprise manager, when I have to create a new sql registration, on a server I can see (local) instance, on the other one NO !! Server are the same, (HP Proliant DL380) , please could anyone of you give me an he...more >>


SharePoint Transaction Logs - switched to simple, now what?
Posted by Donavon at 8/21/2006 6:59:02 AM
Well like everyone else, I see folks moving to simple recovery mode for their SQL databases and making more daily "full" dB backups. So now that I have moved from full to simple recovery mode. I still have all these transaction files killing me in space. Like 77GB! I don't think I can dele...more >>

Urgent: Connection between SQL 2005 SP1 - IIS on AMD 64bit
Posted by Mert Sakarya at 8/19/2006 12:12:31 AM
Hi, We have a 33GB database on Windows 2003 RC2, SQL Server 2005 SP1 on HP585 AMD64 bit with 4 CPUs, 16GB RAM and 3 disks on storage array. Our five web server connects to database and queries database. The problem is when we make a request on a web server, it generates a query and execut...more >>

browsing for server
Posted by badazizi at 8/18/2006 10:02:02 AM
I have placed a Windows 2003 server, running SQL Server 2000 on a DMZ that is on my internal network. I understand that as a Windows system starts, it advertises its services through Service Advertising Protocol, which allows client computers to browse and select servers of a particular type ...more >>

Calling an Oracle Stored Procedure from a Sql Server 2000 Stored Procedure using a Linked Server
Posted by Richard Urrutia at 8/17/2006 3:03:18 PM
Hi, I'm trying to call an Oracle stored procedure from Sql server and I have this error message Could not execute procedure 'INTEGRE_INTERNET' on remote server 'ORA_DEV1'. [OLE/DB provider returned message: One or more errors occurred during processing of command.] [OLE/DB provider returned...more >>

Server: Msg 8115
Posted by at 8/16/2006 3:57:56 PM
I am experiencing an error message when I run a TSQL and I don't know how to correct it. Server: Msg 8115, Level 16, State 8, Line 38 Arithmetic overflow error converting numeric to data type numeric. In this code I am extracting hierarchical information. I am going 6 levels deep. The s...more >>

Running a package from another computer with DTSRunUI
Posted by rmcompute at 8/16/2006 10:12:02 AM
I set up a package with runs from a batch file on my computer after creating the script with DTSRunUI. I cannot run it on another computer. Do I have to copy DTSRun.exe to the other computer with the related rll files to get it to run ? Is there a recommended way to do this ?...more >>

Not able to register server name using windows authentication - Ur
Posted by Rajeshpillai at 8/16/2006 12:07:01 AM
Hi All, My issue like that.... I have SQL Server 2000 enterprise edition installed as named instance. I have configured mixed mode authentication also. But the problem is whne i try to register my sql server usuing windows authentication i get the following error message " Login failed f...more >>



Cannot Connect to SQL instance on SBS 2003
Posted by Rick Barwig at 8/16/2006 12:04:43 AM
I have a SBS2003 server that required a re-install of Sharepoint. I had 2 databases that are part of a document locator application, the application made its' connection using sa and the associated password. I removed and reinstalled Sharepoint and upgraded the sharepoint instance to SQL std ...more >>


DevelopmentNow Blog