After doing a restore to migrate a SQL 2000 database to SQL 2008 we ran the
DBCC CHECKDB DATA_PURITY command which identified Invalid Rows in several
tables.
The data type of many of the identified columns was numeric(16,2), and we

I'm running a query on the sysjobhistory table on multiple servers. This
works fine, except that the results are not sorted by server name, which is
quite annoying. As the column "server name" is not part of the query, is
there a way to sort by this column ?

Folks:
We have SP queries like:
 UPDATE tbl
 SET @var = col = col + 1

Can anyone tell me if JTDS supports shared memory access?
I would like to access the DB with TCP and Named Pipe DISABLED
Appreciate your replies. Thanks
From http://www.developmentnow.com/g/118_0_0_0_0_0/microsoft-public-sqlserver-server.ht

What do you thing how slow will that be if string is used as primary key
field type?
I know most of the primary key defined as integer type (eg.auto-increment).
We are using string as primary key field type: VARCHAR(36).

Is there guidelines, suggestion or could somebody point me to articles which
discuss how to determine the optimum degree of parallelism?
I suppose the biggest factor is going to be cxpacket waits.  My problem is
how do I determine when cxpacket waits exceed the treshold.

I have a maintenance plan that runs every night.  Sometimes it takes too long to run and it affects production for the
following morning.  I can see and kill the process it is currently running but then the next task starts and i have to
kill that too.  How can i stop the thing ...

I've been investigating spatial data types in SQL Server 2008 for my
customers.
It appears only certain coordinate systems are supported by SQL Server 2008.
How do I request that the missing coordinate systems for my country (New

Is there a way to reduce the size of log.LDF file below.  We use Windows
SharePoint Services 3.0 installed on Server 2003 R2 Standard.  Used on a very
small scale.  I am running out of space on Drive C, and I notice that log.LDF
file is almost 10 GB.  The file increases about 1 ...

I'm trying to, but can't, access a MSDE (SQL server express) on a labtop
that it running Windows Vista Home 32-bit (SP2).  The machine I'm trying
to access it from is running Windows 7 64-bit.
Is this a know issue?  Do I need to setup something to make it work?

Muchos problemas de rendimiento y seguridad de tu computador son causados por
virus maliciosos, la mejor forma de combatir esto es tener instalado un
Antivirus reconocido y actualizado en tu computador
Descarga gratis Antivirus en:

I just tried to turn on the Windows Managment Instrumentation module in
management services and it said the module cannot be found.  How can I find
and install this Windows Management Instrument in Services?  I was able to
start the windows managment driver.

I installed SQL Server Express 2005 on Windows XP home with 512 mb memory but
when I click setup.exe I get this error.
The error is "The SQL Server System Configuration Checker cannot be executed
due to WMI configuration on the machine, myMachine Error:2147942526

Greeting All,
I really need some help. I have 400+ Vista workstations running SQLExpress
2005. Due to a recent change in business; I need to modify a single stored
procedure on each unit. Is it possible to script this change; if yes, how?

Can MSDE install on windows 7
Pls advise
Michael

I have an SBS 2003 R2 box with 1 default SQL MSDE instance and 3 named SQL
MSDE instances. We are considering installing Blackberry Professional Server
Express Edition, which requires SQL Express 2005. Is it possible to install a
single named instance of SQL Express 2005 in ...

i need to access to SDF database on Device from an application Desktop with
activesync. i did search but i didin't a applicable solution still.
Suggests?

I am trying to create a new Compact 3.5 database & tables in code so that my
user can create a new DB on the fly without my help. The problem is that I
cannot create 2 columns in the same table as a Primary Key pair this way.  
When I define the table or alter it using the SQL ...

许多性能问题和您的计算机安全造成 恶意病毒，最好的办法对付，这是要安装 防病毒确认和您的计算机上更新
杀毒软件免费下载：
http://antivirusfreecn.blogspot.com/
链接网站的内容：

I have a scenario where I have a Windows CE 5.0 device that will be used as
a small server in a industrial equipment.
The clients will use a SilverLight application (already hosted in the CE
device, what is already working).

Many problems with performance and safety of your computer can be solved
easily with an updated antivirus and recognized. Antivirus Free Download
Microsoft best practices in:
http://yourantivirusfreedownloadonthissite.blogspot.com/

Did you miss the Windows Embedded CE Live Chat yesterday?
Don't worry! We've put the transcript here
http://discovertheexperience.blogspot.com/2010/02/windows-ce-live-chat-transcrip
t-februar.html
Have fun reading!

i use windows ce 4.20 and sqlserver ce 3.5. When i test my program (vs 2008
and framework 2.0), i get an error  on SqlCeCommand.ExecuteReader :
A native exception has occured in... Select quit and then restart this
program, or select details for more information.

the functions first or TOP are not working with CE.
I have a table with a structure: Id integer, weight single, MadeOn datetime.
In this table the weights of persons are saved. Now I would like to get all
persons