I have a table with values in a name field that are both lowercase and
uppercase. I want to select the records that only have uppercase names.
How do I do this?
I didn't see a sqlserver.query group so I figured this was the right

The mining model returns the following error while processing from
Analysis Manger-> Mining Model -> right click -> Process, but processing
from the edit screen does not give error.
'Cannot save object inside a Decision Support Objects (DSO)

Hello every one :
This is my case : I have a Latin collation database that contains data in
another sorting order using the enterprise manager it looks like garbage
mining data in ASP it looks ok my problem that i'm doing a data transform to

My problem is like the following I have an online databse with  a latin
collation, this database is using ntext and nvarchar values that was with our
previous admin ok the problem is in the data is stored should use another
collation (the arabic collation) ok ... now I want to ...

I'm currently developing a user registration prototype.
The aim is to classify certain types of users. However,
after the registration I query a decision tree model in
Analysis Services with DMX and I want to send the user

in order to connect to Analysis Server thru ASP.net, i
need msolap.asp to be copied to the default website.
however, my registry do not have msolap registered at
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Provider

Can I predict numerical column in SQL Server ? (Input columns are also
numerical).
Thanks

I want to update specific fields in a existing table in SQL database as
below example:
L240100001-LG
L240100002-LG    *serial number is difficult to update one by one

I have a query that is based on two other queries that are based on tables
in a database.
All of the queries that are used for this final query use grouping and
totals.

I have  SQL Server 2000. What add-ons do I need to try data mining, and
where do I best go for resources/references?

Can I execute from code refreshing of data and full processing of Mining
Model ?
And also execute prediction query on this mining model with client input ?
Thank you

Can anyone tell me how can I send email through stored procedure in sql
server ? I want to send attachment with this email too.
TIA

I want to update specific fields in a existing table in SQL Server with
values from an excel work book.  What is the best approach to do this?  
I've looked at using DTS but can't find any thing on updating specific
fields, there is loads of information on straight data ...

I have a curious situation which I have failed to resolve.
I have a program written in VB .NET which uses ADO.NET to populate a dataset
from MS SQL using a Sqlconnection and a Sqldataadpter.  For 99% of the time
it works fine.  For 1% of the time an exception is thrown on fill due ...

I am trying to join a view and a table that share common column names. I
have a view named SC_Computer_MaintenanceServerUptimeReport_View (I know,
can I make it any longer) and a table called uptime. The columns in
SC_Computer_MaintenanceServerUptimeReport_View are: