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 > july 2003 > threads for july 22 - 28, 2003

Filter by week: 1 2 3 4 5

Split value in deferent columns
Posted by Farhan Iqbal at 7/28/2003 11:44:29 AM
hi, 1988@@57@@5185 I want to split upper value in three deferent column and want values like this col1 = 1988 col2 = 57 col3 = 5185 is there any why to split this value in desired fashion? Thanx Farhan Iqbal ...more >>


Diagram Pane in SQL Server Enterprise manager doesn't show column names
Posted by raca NO[at]SPAM rogers.com at 7/25/2003 7:45:50 PM
Hi all, When right-clicking on a table in Enterprise Manager 2000 and selecting Open Table...Return all rows I initially get a Results pane (which is normal) and when I press toolbar button for Show Diagram Pane all that I see in that pane is: * (All Columns) - just one option for that table....more >>

Access 2000 Upsizing Wizard
Posted by aaronshover at 7/25/2003 1:30:59 PM
Ok, I finally figured out SQL somewhat. I cannot upsize all of my databases using the upsize wizard provided with Access 2000. I can upsize some database, but most importantly, not the one I need to upsize. Does anybody have any idea why some would upsize and some wouldn't? Could it be a p...more >>

Sql-Server Agent
Posted by irs at 7/25/2003 12:51:59 PM
Hello All Can any one help me out to create Jobs and Run Jobs on Sql- server Agent which is in the Management Folder. Thanks ...more >>

filegroup name
Posted by Farhan Iqbal at 7/25/2003 11:20:38 AM
Hi All Is there any why to know filegroup name object wise. Mean which object is belong with which filegroup. Thanx in Advance Farhan Iqbal ...more >>

SQL server lite
Posted by Murdockio at 7/24/2003 9:13:54 AM
We have a C/S application, but our Client DB will not be connected with the server fulltime. In this case what kind of SQL server (LITE) we can use on our client machines to have synchronized the Data Bases with the serve master DataBase using a dial-up connection one hour per day or even ...more >>

How to get Various Databases into SQL-Server Enterprise Manager
Posted by Irs at 7/24/2003 7:36:59 AM
Hello All I Need to get various Databases into ConsoleRoot\Microsoft SqlServers\SQLserver Group of SQL-Server Enterprise Manager.I could get this in Query Analyzer Thro Object Browser,But how to get in ConsoleRoot\Microsoft SqlServers\SQLserver. Please Do reply ASAP Thanks...more >>

ESQL-C error -137
Posted by Dhiraj Patil at 7/24/2003 5:17:19 AM
I am having code that inserts a records in to a table by reading from a flat file. The Problem is that when first time it enters into the loop it Reads and Inserts the record correctly then it commits also but when it enters Second time it reads data but while inserting it generates erro...more >>



What is a hash table ?
Posted by Tim Conner at 7/23/2003 4:41:44 PM
The BOL mention that a hash join creates a "hash table" to resolve the join. But what is a hash table ? it is just like a temporary table ? Additionaly, could you give any recommendation about links, books or articles that widely explain the different join algorithms ? Thanks in advance,...more >>

At what time I was last restore my database
Posted by Farhan Iqbal at 7/22/2003 5:47:55 PM
hi, I want to know that, at what time I was last restore my database. have any idea. Thanx Farhan Iqbal ...more >>

Encrypt connection channel
Posted by Tushar Karsan at 7/22/2003 3:11:42 PM
(Been reading other messages on this subject but could not find an answer, that is why I'm posting this. Please note, although I have posted to several groups, I've set follow-to microsoft.public.sqlserver.security in case I posted to where I shouldn't have, sorry if I have). Using + ASP.Net...more >>

Data Migration Licensing
Posted by Tom Wolf at 7/22/2003 7:11:42 AM
If you are migrating the SQL Server software and associated application databases from one machine to another does Microsoft allow you to run SQL Server on both machines simultaneously for the period of time necessary to complete the data migration? I found verbage to this effect under th...more >>

Convert string to numeric in order by
Posted by Nuno Pereira at 7/22/2003 6:51:51 AM
I have a string field in a table and it's content is 1,2,3 when i order by this fiels the result is 1,10,11,12,2,3 how i can convert in order by the field to numeric and if i can't how i can resolv this problem....more >>


DevelopmentNow Blog