You should not connect directly between the mobile devices and the sql server over the internet.

If you did that it would expose sql server to the internet, which is not...

Other than following Remi's normalization advice,

This is how you would do it as is.

Create table #dataTable (caseNo int, Stage1Status int, Stage2Status int, Stage3Status int)

insert into #datatable(CaseNo, Stage1Status, Stage2Status, Stage3Status)

values(1, 2,...

I don't think you can enable it thru the logs.

But you can set a profiler trace, only showing Security audit information. and it will tell you the host machine etc.

"I'm having a problem with a form that is completely blank unless there is data in it."

Well my guess is that if there's no data in it, it must...

If your designing a new system, I would suggest having your company (no offense to you) get a True DBA, to get the application off the ground on the right...

I'm not sure mmc.exe, and mmcndmgr.dll are more part of windows than sql server.

EM uses the mmc node to manage sql server. It appears...

This is an unusual request indeed.

If you don't mind can you explain what you are trying to do?

What is the goal of writing a...

Well it depends on how reliable the data is.

I've worked on systems where it was spec'd as a numeric, only to find out 3 weeks into production they passed alpha's.

So...

I'm at least 3 minutes slower, if not more.

Go to Administrative Tools Event Viewer, Click on application.

Are there any Application errors? if so click on it, and post the actual error message.

when you have an error using dynamic sql try ouputting string to text so you can see the query that is being run

declare @sql varchar(1000), @x varchar(10)

set @x = 'field'

set...

as indicated by the error message you can only install reporting services on the following versions

• SQL Server 2000 Standard Edition with SP3 or later4

• SQL Server 2000 Enterprise Edition...

It seems like what you are looking for is a fuzzy search on top of an order by that is not supported.

you can try something like:

insert into #EmpAges (Name, Age)

select...

You may just run thru and double check the attributes for the report.

Click the report, then click the properties tab. Then click the data sources link on the left. Make...

What command exactly are you executing, and what is the exact error message?

Unless you are messing around with the primary key, I don't think replication cares about indexes.