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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|