Archived Months
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 new users > may 2005 > threads for may 29 - 31, 2005

Filter by week: 1 2 3 4 5

Is there a Cube Browser for clients?
Posted by Andrew Graff at 5/31/2005 5:54:02 PM
I've created a database with SQL Server and a cube using that database with Analysis Services, but I could not find anything like the Cube Browser available in Analysis Services for client computers to use. I don't want more functionality than that which Cube Browser provides (although sortin...more >>


ODBC problem
Posted by troutman at 5/31/2005 4:28:29 PM
help : has anyone else had this problem. Connection to SQL Server Database Using IP Address Is Unusually Slow...more >>

Timeout expired ?
Posted by meg at 5/31/2005 2:44:38 PM
I have a vbs script that connects to a database and runs a stored procedure where a linked server is also used in the sp. I get this error when trouble shooting on the line that tries to execute my stored procedure: Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver]...more >>

how create table using another table?
Posted by Beemer Biker at 5/31/2005 2:03:41 PM
---not working--- create table mynewschedule from myoldschedule neither does insert mynewschedule select * from myoldschedule even though something like that was listed this week news:e$SuKdeYFHA.2508@TK2MSFTNGP15.phx.gbl I would like to extract some data from a table. Then let th...more >>

sql server vs express
Posted by John at 5/31/2005 12:51:20 PM
Hi What is the feature comparison of sql server 2005 full and the express product? If an application is developed on one, will it run on the other? Can we say that express is for clients who have previously gone for ms access? Thanks Regards ...more >>

divide by zero error
Posted by r at 5/31/2005 9:29:23 AM
How can I avoid this? I have the following calculations in a view: Data017_all.MTD_StkOrdAmt / Data017_all.MTD_TotOrdAmt * 100 AS MTD_OSO, Data017_all.YTD_StkOrdAmt / Data017_all.YTD_TotOrdAmt * 100 AS YTD_OSO, ....if the second number (the _TotOrdAmt) is 0, I get the divide by zero err...more >>

Scripting table
Posted by Vincent at 5/31/2005 9:02:09 AM
Does any body know if there is a way of scripting table with the contents? ...more >>

How to transfer data from SQL Server 2000 to MS Access
Posted by Adrian Inzunza at 5/30/2005 2:19:29 PM
Hi there: We're in the middle of getting rid of small and meaningless databases but I need to move some of them from SQL Server to Access. Considering that I'm a newbie, wich is the better way to do this.? How I can move all the information from our SQL Server to Access..? Any help will be ...more >>



How to remove free transaction log space
Posted by Andrew Austwick at 5/30/2005 12:00:00 AM
Hi I have a database running on MS SQL server 7, it is split into 2 files on drive c: and drive d: I run regular maintenace plans on the database. After carrying out transaction log backups, the transaction log has about 20mb in used space and 700mb in free space. Is it possible to shrin...more >>

Cannot connect to sql server
Posted by SWOTAR at 5/29/2005 10:48:02 AM
I am on a home network, Linksys router... all my computers are set up using peer-to-peer (workgroup) connections... However, I have one computer (dual-boot Linux & Windows 2k3 server evaluation edition) that has sql server's evaluation edition loaded on it... I can see the win 2k3 server from ...more >>


DevelopmentNow Blog