if i have the following data:
Name
--
SILFL-CFL-ELI24-220-GR
SILFL-CFL-ELI24-220-WH
SILFL-CFL-TOP-GLASS
SILFL-CFL-TOP-LOUVER
SILFL-CFL-TOP218-WH
SILFL-CFL-TOP226-WH
SILFL-FLU-EST18-220-WH
SILFL-FLU-EST36-220-WH
SILFL-FLU-FLA08-220-WH
SILFL-FLU-FLA13-220-WH
SILFL-FLU-MAR/P-218-220
SILFL-FLU-MAR/P-236-220-EB
SILFL-FLU-MAR/P-236-220-EES
SILFL-FLU-MAR/P-236-220
SILFL-FLU-STY108-220-WH
SILFL-FLU-STY113-220-WH
SILFL-FLU-STY15-220-BK
SILFL-FLU-STY15-220-WH
SILFL-FLU-STY18-220-BK
SILFL-FLU-STY18-220-WH
SILFL-FLU-STY30-220-BK
SILFL-FLU-STY30-220-WH
SILFL-FLU-STY36-220-BK
SILFL-FLU-STY36-220-WH
SILFL-GLS-GLOB-220-BK
SILFL-GLS-GLOB-220-WH
SILFL-GLS-ROLL-220-WH
SILFL-GLS-ROLL-220V-BK
SILFL-HPD-INT-ARCLT-150-WH
- When i run the following query no data is returned:
Select *
from TableName
where Name >= 'SILFL'
- If I add a dash the correct data is returned.
Select *
from TableName
where Name >= 'SILFL-'
Why is SQL Server seeing the string 'SILFL' as smaller than 'SILFL-'I believe that this is to do with the collation you have on your server.
Out of interest I did the same thing and got back the correct results.
You can probably get back the correct results by doing the following...
SELECT *
FROM YourTable
WHERE cast(Info as nvarchar(100)) >= N'S'
"Happiness is having a large, loving, caring, close-knit family in another
city."
George Burns
Anyway have a look at your collation and read about it on BOL.
Peter
"Nadim Wakim" wrote:
> if i have the following data:
> Name
> --
> SILFL-CFL-ELI24-220-GR
> SILFL-CFL-ELI24-220-WH
> SILFL-CFL-TOP-GLASS
> SILFL-CFL-TOP-LOUVER
> SILFL-CFL-TOP218-WH
> SILFL-CFL-TOP226-WH
> SILFL-FLU-EST18-220-WH
> SILFL-FLU-EST36-220-WH
> SILFL-FLU-FLA08-220-WH
> SILFL-FLU-FLA13-220-WH
> SILFL-FLU-MAR/P-218-220
> SILFL-FLU-MAR/P-236-220-EB
> SILFL-FLU-MAR/P-236-220-EES
> SILFL-FLU-MAR/P-236-220
> SILFL-FLU-STY108-220-WH
> SILFL-FLU-STY113-220-WH
> SILFL-FLU-STY15-220-BK
> SILFL-FLU-STY15-220-WH
> SILFL-FLU-STY18-220-BK
> SILFL-FLU-STY18-220-WH
> SILFL-FLU-STY30-220-BK
> SILFL-FLU-STY30-220-WH
> SILFL-FLU-STY36-220-BK
> SILFL-FLU-STY36-220-WH
> SILFL-GLS-GLOB-220-BK
> SILFL-GLS-GLOB-220-WH
> SILFL-GLS-ROLL-220-WH
> SILFL-GLS-ROLL-220V-BK
> SILFL-HPD-INT-ARCLT-150-WH
> - When i run the following query no data is returned:
> Select *
> from TableName
> where Name >= 'SILFL'
>
> - If I add a dash the correct data is returned.
> Select *
> from TableName
> where Name >= 'SILFL-'
> Why is SQL Server seeing the string 'SILFL' as smaller than 'SILFL-'
>
>|||Becuase it is. Anything with 4 characters is "smaller" than the same thing
with any character added at the end.
abcd' < 'abcd' + 'a'
What I Don't understand is why the query is not returning anything. All
those values are > 'SILFL', because 'SILFL' is < than all of them.
When I run the following, ALL The records are returned...
Create Table Test (Col VarCHar(50))
Insert Test (Col) VAlues ('SILFL-CFL-ELI24-220-GR')
Insert Test (Col) VAlues ('SILFL-CFL-ELI24-220-WH')
Insert Test (Col) VAlues ('SILFL-CFL-TOP-GLASS')
Insert Test (Col) VAlues ('SILFL-CFL-TOP-LOUVER')
Insert Test (Col) VAlues ('SILFL-CFL-TOP218-WH')
Insert Test (Col) VAlues ('SILFL-CFL-TOP226-WH')
Insert Test (Col) VAlues ('SILFL-FLU-EST18-220-WH')
Insert Test (Col) VAlues ('SILFL-FLU-EST36-220-WH')
Insert Test (Col) VAlues ('SILFL-FLU-FLA08-220-WH')
Insert Test (Col) VAlues ('SILFL-FLU-FLA13-220-WH')
Insert Test (Col) VAlues ('SILFL-FLU-MAR/P-218-220')
Insert Test (Col) VAlues ('SILFL-FLU-MAR/P-236-220-EB')
Insert Test (Col) VAlues ('SILFL-FLU-MAR/P-236-220-EES')
Insert Test (Col) VAlues ('SILFL-FLU-MAR/P-236-220')
Insert Test (Col) VAlues ('SILFL-FLU-STY108-220-WH')
Insert Test (Col) VAlues ('SILFL-FLU-STY113-220-WH')
Insert Test (Col) VAlues ('SILFL-FLU-STY15-220-BK')
Insert Test (Col) VAlues ('SILFL-FLU-STY15-220-WH')
Insert Test (Col) VAlues ('SILFL-FLU-STY18-220-BK')
Insert Test (Col) VAlues ('SILFL-FLU-STY18-220-WH')
Insert Test (Col) VAlues ('SILFL-FLU-STY30-220-BK')
Insert Test (Col) VAlues ('SILFL-FLU-STY30-220-WH')
Insert Test (Col) VAlues ('SILFL-FLU-STY36-220-BK')
Insert Test (Col) VAlues ('SILFL-FLU-STY36-220-WH')
Insert Test (Col) VAlues ('SILFL-GLS-GLOB-220-BK')
Insert Test (Col) VAlues ('SILFL-GLS-GLOB-220-WH')
Insert Test (Col) VAlues ('SILFL-GLS-ROLL-220-WH')
Insert Test (Col) VAlues ('SILFL-GLS-ROLL-220V-BK')
Insert Test (Col) VAlues ('SILFL-HPD-INT-ARCLT-150-WH')
Select * from Test
where Col >= 'SILFL-'
"Nadim Wakim" wrote:
> if i have the following data:
> Name
> --
> SILFL-CFL-ELI24-220-GR
> SILFL-CFL-ELI24-220-WH
> SILFL-CFL-TOP-GLASS
> SILFL-CFL-TOP-LOUVER
> SILFL-CFL-TOP218-WH
> SILFL-CFL-TOP226-WH
> SILFL-FLU-EST18-220-WH
> SILFL-FLU-EST36-220-WH
> SILFL-FLU-FLA08-220-WH
> SILFL-FLU-FLA13-220-WH
> SILFL-FLU-MAR/P-218-220
> SILFL-FLU-MAR/P-236-220-EB
> SILFL-FLU-MAR/P-236-220-EES
> SILFL-FLU-MAR/P-236-220
> SILFL-FLU-STY108-220-WH
> SILFL-FLU-STY113-220-WH
> SILFL-FLU-STY15-220-BK
> SILFL-FLU-STY15-220-WH
> SILFL-FLU-STY18-220-BK
> SILFL-FLU-STY18-220-WH
> SILFL-FLU-STY30-220-BK
> SILFL-FLU-STY30-220-WH
> SILFL-FLU-STY36-220-BK
> SILFL-FLU-STY36-220-WH
> SILFL-GLS-GLOB-220-BK
> SILFL-GLS-GLOB-220-WH
> SILFL-GLS-ROLL-220-WH
> SILFL-GLS-ROLL-220V-BK
> SILFL-HPD-INT-ARCLT-150-WH
> - When i run the following query no data is returned:
> Select *
> from TableName
> where Name >= 'SILFL'
>
> - If I add a dash the correct data is returned.
> Select *
> from TableName
> where Name >= 'SILFL-'
> Why is SQL Server seeing the string 'SILFL' as smaller than 'SILFL-'
>
>
Showing posts with label returning. Show all posts
Showing posts with label returning. Show all posts
Monday, March 19, 2012
Wednesday, March 7, 2012
Error in execute sql task
I get the following error when trying to execute an sql statement in oracle and returning the results into an object variable with the execute sql task.
Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "select <columnlist> from <tablename>" failed with the following error: "The SelectCommand property has not been initialized before calling 'Fill'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
It executes fine if I select no results or first row but I can't get full result set to work. The query and connection string are valid. Any ideas?
Hi,
Have you selected the "Full Result Set" in the ResultSet option? If so, then create a variable of datatype "Object" and link that variable in the ResultSet tab. In that, enter "0" in the Result Name and in the Variable Name, select the variable you created as Object.
Pls try this and let me know if you have any issues.
Sorry for the delayed response. I just gone thru this issue.
Prakash Srinivasan
|||I have the same issues with the Script task in the control flow. I have the result set to full and assigned to a datatype of object. I also have 0 for the name of the result set but it still give me the same error. " selectcommand was in initialized before Fill" It would be a paid to enter 300 column names in the script component in the data flow side just because this the Script task isnt work. I will be glad if someone could help me.|||How are you doing this? The Script Task isn't really supposed to be used for extracting SQL data. Why does Execute SQL Task not work for you?
-Jamie
|||I am pulling data through an ado.net connection connected to a DB/C 4 database (odbc database). I needed to pull data based on the last date run so i need a way to insert a date into my sql command where clause. I am using an expression to set the sqlcommand of the Script task to "select .....from tableA where timestamp > = " @.[datetime::mydate] ". I have the resultset set to Full result set. I also have my resultset variable as Object::rs_data and the name set to 0 for Full resultset. I still get the error so I am think its probably the fact that the script task does not work for ado.net odbc connnections.
|||I am still left wondering why you are not doing this in an Execute SQL Task. And yet you say "I have the resultset set to Full result set." Are you really using a script task?
-Jamie
|||Sorry, i wasnt paying attention. I meant to say Execute SQL Task instead of Script task. With that said, is there any ideas for fixing the situation and once to assign a resultset to a variable. How do you use that resultset(variable) as datasource in a Data flow.|||Hi,does anyone have the solution to the error:
The SelectCommand property has not been initialized before calling 'Fill'."
for Execute SQL Task problem? I am also stuck there...
Daren
|||
I'm facing the same problem while I'm extracting data from an "SQL Task" using a result set "full result set".
Also can someone tell me how to read the temp result set created by the SQL task ? The documentation found is very poor for a novice like me and doesn't explain how to read the System.Data.Dataset in order to feed a SQL server destination table.
Thanks
Error in execute sql task
I get the following error when trying to execute an sql statement in oracle and returning the results into an object variable with the execute sql task.
Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "select <columnlist> from <tablename>" failed with the following error: "The SelectCommand property has not been initialized before calling 'Fill'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
It executes fine if I select no results or first row but I can't get full result set to work. The query and connection string are valid. Any ideas?
Hi,
Have you selected the "Full Result Set" in the ResultSet option? If so, then create a variable of datatype "Object" and link that variable in the ResultSet tab. In that, enter "0" in the Result Name and in the Variable Name, select the variable you created as Object.
Pls try this and let me know if you have any issues.
Sorry for the delayed response. I just gone thru this issue.
Prakash Srinivasan
|||I have the same issues with the Script task in the control flow. I have the result set to full and assigned to a datatype of object. I also have 0 for the name of the result set but it still give me the same error. " selectcommand was in initialized before Fill" It would be a paid to enter 300 column names in the script component in the data flow side just because this the Script task isnt work. I will be glad if someone could help me.|||How are you doing this? The Script Task isn't really supposed to be used for extracting SQL data. Why does Execute SQL Task not work for you?
-Jamie
|||
I am pulling data through an ado.net connection connected to a DB/C 4 database (odbc database). I needed to pull data based on the last date run so i need a way to insert a date into my sql command where clause. I am using an expression to set the sqlcommand of the Script task to "select .....from tableA where timestamp > = " @.[datetime::mydate] ". I have the resultset set to Full result set. I also have my resultset variable as Object::rs_data and the name set to 0 for Full resultset. I still get the error so I am think its probably the fact that the script task does not work for ado.net odbc connnections.
|||I am still left wondering why you are not doing this in an Execute SQL Task. And yet you say "I have the resultset set to Full result set." Are you really using a script task?
-Jamie
|||Sorry, i wasnt paying attention. I meant to say Execute SQL Task instead of Script task. With that said, is there any ideas for fixing the situation and once to assign a resultset to a variable. How do you use that resultset(variable) as datasource in a Data flow.|||Hi,
does anyone have the solution to the error:
The SelectCommand property has not been initialized before calling 'Fill'."
for Execute SQL Task problem? I am also stuck there...
Daren|||
I'm facing the same problem while I'm extracting data from an "SQL Task" using a result set "full result set".
Also can someone tell me how to read the temp result set created by the SQL task ? The documentation found is very poor for a novice like me and doesn't explain how to read the System.Data.Dataset in order to feed a SQL server destination table.
Thanks
Sunday, February 26, 2012
Error in execute sql task
I get the following error when trying to execute an sql statement in oracle and returning the results into an object variable with the execute sql task.
Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "select <columnlist> from <tablename>" failed with the following error: "The SelectCommand property has not been initialized before calling 'Fill'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
It executes fine if I select no results or first row but I can't get full result set to work. The query and connection string are valid. Any ideas?
Hi,
Have you selected the "Full Result Set" in the ResultSet option? If so, then create a variable of datatype "Object" and link that variable in the ResultSet tab. In that, enter "0" in the Result Name and in the Variable Name, select the variable you created as Object.
Pls try this and let me know if you have any issues.
Sorry for the delayed response. I just gone thru this issue.
Prakash Srinivasan
|||I have the same issues with the Script task in the control flow. I have the result set to full and assigned to a datatype of object. I also have 0 for the name of the result set but it still give me the same error. " selectcommand was in initialized before Fill" It would be a paid to enter 300 column names in the script component in the data flow side just because this the Script task isnt work. I will be glad if someone could help me.|||How are you doing this? The Script Task isn't really supposed to be used for extracting SQL data. Why does Execute SQL Task not work for you?
-Jamie
|||I am pulling data through an ado.net connection connected to a DB/C 4 database (odbc database). I needed to pull data based on the last date run so i need a way to insert a date into my sql command where clause. I am using an expression to set the sqlcommand of the Script task to "select .....from tableA where timestamp > = " @.[datetime::mydate] ". I have the resultset set to Full result set. I also have my resultset variable as Object::rs_data and the name set to 0 for Full resultset. I still get the error so I am think its probably the fact that the script task does not work for ado.net odbc connnections.
|||I am still left wondering why you are not doing this in an Execute SQL Task. And yet you say "I have the resultset set to Full result set." Are you really using a script task?
-Jamie
|||Sorry, i wasnt paying attention. I meant to say Execute SQL Task instead of Script task. With that said, is there any ideas for fixing the situation and once to assign a resultset to a variable. How do you use that resultset(variable) as datasource in a Data flow.|||Hi,does anyone have the solution to the error:
The SelectCommand property has not been initialized before calling 'Fill'."
for Execute SQL Task problem? I am also stuck there...
Daren
|||
I'm facing the same problem while I'm extracting data from an "SQL Task" using a result set "full result set".
Also can someone tell me how to read the temp result set created by the SQL task ? The documentation found is very poor for a novice like me and doesn't explain how to read the System.Data.Dataset in order to feed a SQL server destination table.
Thanks
Error in execute sql task
I get the following error when trying to execute an sql statement in oracle and returning the results into an object variable with the execute sql task.
Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "select <columnlist> from <tablename>" failed with the following error: "The SelectCommand property has not been initialized before calling 'Fill'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
It executes fine if I select no results or first row but I can't get full result set to work. The query and connection string are valid. Any ideas?
Hi,
Have you selected the "Full Result Set" in the ResultSet option? If so, then create a variable of datatype "Object" and link that variable in the ResultSet tab. In that, enter "0" in the Result Name and in the Variable Name, select the variable you created as Object.
Pls try this and let me know if you have any issues.
Sorry for the delayed response. I just gone thru this issue.
Prakash Srinivasan
|||I have the same issues with the Script task in the control flow. I have the result set to full and assigned to a datatype of object. I also have 0 for the name of the result set but it still give me the same error. " selectcommand was in initialized before Fill" It would be a paid to enter 300 column names in the script component in the data flow side just because this the Script task isnt work. I will be glad if someone could help me.|||How are you doing this? The Script Task isn't really supposed to be used for extracting SQL data. Why does Execute SQL Task not work for you?
-Jamie
|||I am pulling data through an ado.net connection connected to a DB/C 4 database (odbc database). I needed to pull data based on the last date run so i need a way to insert a date into my sql command where clause. I am using an expression to set the sqlcommand of the Script task to "select .....from tableA where timestamp > = " @.[datetime::mydate] ". I have the resultset set to Full result set. I also have my resultset variable as Object::rs_data and the name set to 0 for Full resultset. I still get the error so I am think its probably the fact that the script task does not work for ado.net odbc connnections.
|||I am still left wondering why you are not doing this in an Execute SQL Task. And yet you say "I have the resultset set to Full result set." Are you really using a script task?
-Jamie
|||Sorry, i wasnt paying attention. I meant to say Execute SQL Task instead of Script task. With that said, is there any ideas for fixing the situation and once to assign a resultset to a variable. How do you use that resultset(variable) as datasource in a Data flow.|||Hi,does anyone have the solution to the error:
The SelectCommand property has not been initialized before calling 'Fill'."
for Execute SQL Task problem? I am also stuck there...
Daren
|||
I'm facing the same problem while I'm extracting data from an "SQL Task" using a result set "full result set".
Also can someone tell me how to read the temp result set created by the SQL task ? The documentation found is very poor for a novice like me and doesn't explain how to read the System.Data.Dataset in order to feed a SQL server destination table.
Thanks
error in Enterprise Manager while returning all or few rows.
Hi, Everyone
I use SQL Server Enterprise Manager to access DB server.
I can connect and see the tables fine. But when i tried
to open table returen all rows or open design table, I
got an error saying:
An unexpected error happend during this operation.
[MS Desgin Tools] -- Not enough storage is available to
complete this operation.
Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
Thanks
Adi ..adi wrote:
> Hi, Everyone
> I use SQL Server Enterprise Manager to access DB server.
> I can connect and see the tables fine. But when i tried
> to open table returen all rows or open design table, I
> got an error saying:
> An unexpected error happend during this operation.
> [MS Desgin Tools] -- Not enough storage is available to
> complete this operation.
> Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
> Thanks
> Adi ..
>
Don't use Enterprise Manager to view or modify data - use Query Analyzer.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I appreciate your advice. But what I am looking for is a solution for the
problem I mentioned.
"Tracy McKibben" wrote:
> adi wrote:
> > Hi, Everyone
> >
> > I use SQL Server Enterprise Manager to access DB server.
> > I can connect and see the tables fine. But when i tried
> > to open table returen all rows or open design table, I
> > got an error saying:
> >
> > An unexpected error happend during this operation.
> > [MS Desgin Tools] -- Not enough storage is available to
> > complete this operation.
> >
> > Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
> >
> > Thanks
> > Adi ..
> >
> Don't use Enterprise Manager to view or modify data - use Query Analyzer.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||adi wrote:
> I appreciate your advice. But what I am looking for is a solution for the
> problem I mentioned.
>
Start reading:
http://www.google.com/search?q=%22enterprise+manager%22+%22Not+enough+storage+is+available+to%22
You could avoid the whole mess by using the proper tools, i.e. using
Query Analyzer instead of Enterprise Manager.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Adi,
The nature of the problem mentioned is using the wrong tool for the job.
Enterprise Manager is NOT the 'right' tool to use for table alteration, data
manipulation, or, as you noticed, even viewing large amounts of data.
Tracy's advise is good advise. Continuing to use EM sets you up for
numerous, as of yet, inexperienced, problems -of which this is just the tip
of the iceberg.
Your question is like asking how to hammer a nail with a screwdriver. And
when someone mentions that a hammer would be better, your response is like
saying "I don't care, I am going to hammer the nail with the screwdriver."
You won't find many skilled SQL Server folks actively encouraging or
abetting the use of Enterprise Mangler.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"adi" <adi@.discussions.microsoft.com> wrote in message
news:4BFDAB54-4ED5-48C7-A19A-2CEAFBA31E02@.microsoft.com...
>I appreciate your advice. But what I am looking for is a solution for the
> problem I mentioned.
> "Tracy McKibben" wrote:
>> adi wrote:
>> > Hi, Everyone
>> >
>> > I use SQL Server Enterprise Manager to access DB server.
>> > I can connect and see the tables fine. But when i tried
>> > to open table returen all rows or open design table, I
>> > got an error saying:
>> >
>> > An unexpected error happend during this operation.
>> > [MS Desgin Tools] -- Not enough storage is available to
>> > complete this operation.
>> >
>> > Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
>> >
>> > Thanks
>> > Adi ..
>> >
>> Don't use Enterprise Manager to view or modify data - use Query Analyzer.
>>
>> --
>> Tracy McKibben
>> MCDBA
>> http://www.realsqlguy.com|||Arnie,
Now, I'm not against your advice or anyones for that matter. In fact that's
what we are looking for through these forums. I agree with what you said as
I've been managing SQL Servers since v6.5 days. But if I come accross this
problem and google or MS KB not being able to shortlist the problem
resolution then my search is always for the possible answer to the question.
Thanks again for your wise words. have a good day.
Adi ..
"Arnie Rowland" wrote:
> Adi,
> The nature of the problem mentioned is using the wrong tool for the job.
> Enterprise Manager is NOT the 'right' tool to use for table alteration, data
> manipulation, or, as you noticed, even viewing large amounts of data.
> Tracy's advise is good advise. Continuing to use EM sets you up for
> numerous, as of yet, inexperienced, problems -of which this is just the tip
> of the iceberg.
> Your question is like asking how to hammer a nail with a screwdriver. And
> when someone mentions that a hammer would be better, your response is like
> saying "I don't care, I am going to hammer the nail with the screwdriver."
> You won't find many skilled SQL Server folks actively encouraging or
> abetting the use of Enterprise Mangler.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "adi" <adi@.discussions.microsoft.com> wrote in message
> news:4BFDAB54-4ED5-48C7-A19A-2CEAFBA31E02@.microsoft.com...
> >I appreciate your advice. But what I am looking for is a solution for the
> > problem I mentioned.
> >
> > "Tracy McKibben" wrote:
> >
> >> adi wrote:
> >> > Hi, Everyone
> >> >
> >> > I use SQL Server Enterprise Manager to access DB server.
> >> > I can connect and see the tables fine. But when i tried
> >> > to open table returen all rows or open design table, I
> >> > got an error saying:
> >> >
> >> > An unexpected error happend during this operation.
> >> > [MS Desgin Tools] -- Not enough storage is available to
> >> > complete this operation.
> >> >
> >> > Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
> >> >
> >> > Thanks
> >> > Adi ..
> >> >
> >>
> >> Don't use Enterprise Manager to view or modify data - use Query Analyzer.
> >>
> >>
> >> --
> >> Tracy McKibben
> >> MCDBA
> >> http://www.realsqlguy.com
> >>
>
>
I use SQL Server Enterprise Manager to access DB server.
I can connect and see the tables fine. But when i tried
to open table returen all rows or open design table, I
got an error saying:
An unexpected error happend during this operation.
[MS Desgin Tools] -- Not enough storage is available to
complete this operation.
Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
Thanks
Adi ..adi wrote:
> Hi, Everyone
> I use SQL Server Enterprise Manager to access DB server.
> I can connect and see the tables fine. But when i tried
> to open table returen all rows or open design table, I
> got an error saying:
> An unexpected error happend during this operation.
> [MS Desgin Tools] -- Not enough storage is available to
> complete this operation.
> Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
> Thanks
> Adi ..
>
Don't use Enterprise Manager to view or modify data - use Query Analyzer.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I appreciate your advice. But what I am looking for is a solution for the
problem I mentioned.
"Tracy McKibben" wrote:
> adi wrote:
> > Hi, Everyone
> >
> > I use SQL Server Enterprise Manager to access DB server.
> > I can connect and see the tables fine. But when i tried
> > to open table returen all rows or open design table, I
> > got an error saying:
> >
> > An unexpected error happend during this operation.
> > [MS Desgin Tools] -- Not enough storage is available to
> > complete this operation.
> >
> > Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
> >
> > Thanks
> > Adi ..
> >
> Don't use Enterprise Manager to view or modify data - use Query Analyzer.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||adi wrote:
> I appreciate your advice. But what I am looking for is a solution for the
> problem I mentioned.
>
Start reading:
http://www.google.com/search?q=%22enterprise+manager%22+%22Not+enough+storage+is+available+to%22
You could avoid the whole mess by using the proper tools, i.e. using
Query Analyzer instead of Enterprise Manager.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Adi,
The nature of the problem mentioned is using the wrong tool for the job.
Enterprise Manager is NOT the 'right' tool to use for table alteration, data
manipulation, or, as you noticed, even viewing large amounts of data.
Tracy's advise is good advise. Continuing to use EM sets you up for
numerous, as of yet, inexperienced, problems -of which this is just the tip
of the iceberg.
Your question is like asking how to hammer a nail with a screwdriver. And
when someone mentions that a hammer would be better, your response is like
saying "I don't care, I am going to hammer the nail with the screwdriver."
You won't find many skilled SQL Server folks actively encouraging or
abetting the use of Enterprise Mangler.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"adi" <adi@.discussions.microsoft.com> wrote in message
news:4BFDAB54-4ED5-48C7-A19A-2CEAFBA31E02@.microsoft.com...
>I appreciate your advice. But what I am looking for is a solution for the
> problem I mentioned.
> "Tracy McKibben" wrote:
>> adi wrote:
>> > Hi, Everyone
>> >
>> > I use SQL Server Enterprise Manager to access DB server.
>> > I can connect and see the tables fine. But when i tried
>> > to open table returen all rows or open design table, I
>> > got an error saying:
>> >
>> > An unexpected error happend during this operation.
>> > [MS Desgin Tools] -- Not enough storage is available to
>> > complete this operation.
>> >
>> > Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
>> >
>> > Thanks
>> > Adi ..
>> >
>> Don't use Enterprise Manager to view or modify data - use Query Analyzer.
>>
>> --
>> Tracy McKibben
>> MCDBA
>> http://www.realsqlguy.com|||Arnie,
Now, I'm not against your advice or anyones for that matter. In fact that's
what we are looking for through these forums. I agree with what you said as
I've been managing SQL Servers since v6.5 days. But if I come accross this
problem and google or MS KB not being able to shortlist the problem
resolution then my search is always for the possible answer to the question.
Thanks again for your wise words. have a good day.
Adi ..
"Arnie Rowland" wrote:
> Adi,
> The nature of the problem mentioned is using the wrong tool for the job.
> Enterprise Manager is NOT the 'right' tool to use for table alteration, data
> manipulation, or, as you noticed, even viewing large amounts of data.
> Tracy's advise is good advise. Continuing to use EM sets you up for
> numerous, as of yet, inexperienced, problems -of which this is just the tip
> of the iceberg.
> Your question is like asking how to hammer a nail with a screwdriver. And
> when someone mentions that a hammer would be better, your response is like
> saying "I don't care, I am going to hammer the nail with the screwdriver."
> You won't find many skilled SQL Server folks actively encouraging or
> abetting the use of Enterprise Mangler.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "adi" <adi@.discussions.microsoft.com> wrote in message
> news:4BFDAB54-4ED5-48C7-A19A-2CEAFBA31E02@.microsoft.com...
> >I appreciate your advice. But what I am looking for is a solution for the
> > problem I mentioned.
> >
> > "Tracy McKibben" wrote:
> >
> >> adi wrote:
> >> > Hi, Everyone
> >> >
> >> > I use SQL Server Enterprise Manager to access DB server.
> >> > I can connect and see the tables fine. But when i tried
> >> > to open table returen all rows or open design table, I
> >> > got an error saying:
> >> >
> >> > An unexpected error happend during this operation.
> >> > [MS Desgin Tools] -- Not enough storage is available to
> >> > complete this operation.
> >> >
> >> > Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
> >> >
> >> > Thanks
> >> > Adi ..
> >> >
> >>
> >> Don't use Enterprise Manager to view or modify data - use Query Analyzer.
> >>
> >>
> >> --
> >> Tracy McKibben
> >> MCDBA
> >> http://www.realsqlguy.com
> >>
>
>
error in Enterprise Manager while returning all or few rows.
Hi, Everyone
I use SQL Server Enterprise Manager to access DB server.
I can connect and see the tables fine. But when i tried
to open table returen all rows or open design table, I
got an error saying:
An unexpected error happend during this operation.
[MS Desgin Tools] -- Not enough storage is available to
complete this operation.
Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
Thanks
Adi ..adi wrote:
> Hi, Everyone
> I use SQL Server Enterprise Manager to access DB server.
> I can connect and see the tables fine. But when i tried
> to open table returen all rows or open design table, I
> got an error saying:
> An unexpected error happend during this operation.
> [MS Desgin Tools] -- Not enough storage is available to
> complete this operation.
> Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
> Thanks
> Adi ..
>
Don't use Enterprise Manager to view or modify data - use Query Analyzer.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I appreciate your advice. But what I am looking for is a solution for the
problem I mentioned.
"Tracy McKibben" wrote:
> adi wrote:
> Don't use Enterprise Manager to view or modify data - use Query Analyzer.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||adi wrote:
> I appreciate your advice. But what I am looking for is a solution for the
> problem I mentioned.
>
Start reading:
http://www.google.com/search? q=%22...
vailable+to%22
You could avoid the whole mess by using the proper tools, i.e. using
Query Analyzer instead of Enterprise Manager.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Adi,
The nature of the problem mentioned is using the wrong tool for the job.
Enterprise Manager is NOT the 'right' tool to use for table alteration, data
manipulation, or, as you noticed, even viewing large amounts of data.
Tracy's advise is good advise. Continuing to use EM sets you up for
numerous, as of yet, inexperienced, problems -of which this is just the tip
of the iceberg.
Your question is like asking how to hammer a nail with a screwdriver. And
when someone mentions that a hammer would be better, your response is like
saying "I don't care, I am going to hammer the nail with the screwdriver."
You won't find many skilled SQL Server folks actively encouraging or
abetting the use of Enterprise Mangler.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"adi" <adi@.discussions.microsoft.com> wrote in message
news:4BFDAB54-4ED5-48C7-A19A-2CEAFBA31E02@.microsoft.com...[vbcol=seagreen]
>I appreciate your advice. But what I am looking for is a solution for the
> problem I mentioned.
> "Tracy McKibben" wrote:
>|||Arnie,
Now, I'm not against your advice or anyones for that matter. In fact that's
what we are looking for through these forums. I agree with what you said as
I've been managing SQL Servers since v6.5 days. But if I come accross this
problem and google or MS KB not being able to shortlist the problem
resolution then my search is always for the possible answer to the question.
Thanks again for your wise words. have a good day.
Adi ..
"Arnie Rowland" wrote:
> Adi,
> The nature of the problem mentioned is using the wrong tool for the job.
> Enterprise Manager is NOT the 'right' tool to use for table alteration, da
ta
> manipulation, or, as you noticed, even viewing large amounts of data.
> Tracy's advise is good advise. Continuing to use EM sets you up for
> numerous, as of yet, inexperienced, problems -of which this is just the ti
p
> of the iceberg.
> Your question is like asking how to hammer a nail with a screwdriver. And
> when someone mentions that a hammer would be better, your response is like
> saying "I don't care, I am going to hammer the nail with the screwdriver."
> You won't find many skilled SQL Server folks actively encouraging or
> abetting the use of Enterprise Mangler.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "adi" <adi@.discussions.microsoft.com> wrote in message
> news:4BFDAB54-4ED5-48C7-A19A-2CEAFBA31E02@.microsoft.com...
>
>
I use SQL Server Enterprise Manager to access DB server.
I can connect and see the tables fine. But when i tried
to open table returen all rows or open design table, I
got an error saying:
An unexpected error happend during this operation.
[MS Desgin Tools] -- Not enough storage is available to
complete this operation.
Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
Thanks
Adi ..adi wrote:
> Hi, Everyone
> I use SQL Server Enterprise Manager to access DB server.
> I can connect and see the tables fine. But when i tried
> to open table returen all rows or open design table, I
> got an error saying:
> An unexpected error happend during this operation.
> [MS Desgin Tools] -- Not enough storage is available to
> complete this operation.
> Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
> Thanks
> Adi ..
>
Don't use Enterprise Manager to view or modify data - use Query Analyzer.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I appreciate your advice. But what I am looking for is a solution for the
problem I mentioned.
"Tracy McKibben" wrote:
> adi wrote:
> Don't use Enterprise Manager to view or modify data - use Query Analyzer.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||adi wrote:
> I appreciate your advice. But what I am looking for is a solution for the
> problem I mentioned.
>
Start reading:
http://www.google.com/search? q=%22...
vailable+to%22
You could avoid the whole mess by using the proper tools, i.e. using
Query Analyzer instead of Enterprise Manager.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Adi,
The nature of the problem mentioned is using the wrong tool for the job.
Enterprise Manager is NOT the 'right' tool to use for table alteration, data
manipulation, or, as you noticed, even viewing large amounts of data.
Tracy's advise is good advise. Continuing to use EM sets you up for
numerous, as of yet, inexperienced, problems -of which this is just the tip
of the iceberg.
Your question is like asking how to hammer a nail with a screwdriver. And
when someone mentions that a hammer would be better, your response is like
saying "I don't care, I am going to hammer the nail with the screwdriver."
You won't find many skilled SQL Server folks actively encouraging or
abetting the use of Enterprise Mangler.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"adi" <adi@.discussions.microsoft.com> wrote in message
news:4BFDAB54-4ED5-48C7-A19A-2CEAFBA31E02@.microsoft.com...[vbcol=seagreen]
>I appreciate your advice. But what I am looking for is a solution for the
> problem I mentioned.
> "Tracy McKibben" wrote:
>|||Arnie,
Now, I'm not against your advice or anyones for that matter. In fact that's
what we are looking for through these forums. I agree with what you said as
I've been managing SQL Servers since v6.5 days. But if I come accross this
problem and google or MS KB not being able to shortlist the problem
resolution then my search is always for the possible answer to the question.
Thanks again for your wise words. have a good day.
Adi ..
"Arnie Rowland" wrote:
> Adi,
> The nature of the problem mentioned is using the wrong tool for the job.
> Enterprise Manager is NOT the 'right' tool to use for table alteration, da
ta
> manipulation, or, as you noticed, even viewing large amounts of data.
> Tracy's advise is good advise. Continuing to use EM sets you up for
> numerous, as of yet, inexperienced, problems -of which this is just the ti
p
> of the iceberg.
> Your question is like asking how to hammer a nail with a screwdriver. And
> when someone mentions that a hammer would be better, your response is like
> saying "I don't care, I am going to hammer the nail with the screwdriver."
> You won't find many skilled SQL Server folks actively encouraging or
> abetting the use of Enterprise Mangler.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "adi" <adi@.discussions.microsoft.com> wrote in message
> news:4BFDAB54-4ED5-48C7-A19A-2CEAFBA31E02@.microsoft.com...
>
>
Subscribe to:
Posts (Atom)