Here it is: http://statisticsioparser.com/statisticsioparser/index.html

Ed Wagner (11/19/2013)

jcrawf02 (11/19/2013)

L' Eomot Inversé (11/14/2013)

Lynn Pettis (11/13/2013)

Just finished the interview, and...

No straight conversion script that I know of.

OpenOffice Base wraps HSQLDB, so you may just need to use its ODBC driver to connect to the database and extract data from...

Vast topic. Anything in particular you want to know?

Otherwise, Google "troubleshooting replication" and lots of resources should appear.

Auditing is a good place to start from.

Another way could be revoking privileges, but very difficult when the database is at the client's site.

How do you stop the service with the dbcreator login?

1. Is it possible to automate the report such that sql extracts the report from the database at a given time and also sends to specific receivers at a specified...

Looks like a perfect fit for implementing AlwaysOn Availability Groups with a readable secondary.

It's a shame you need a 2008 R2 secondary. Are you sure you can't go with...

Impossible.

Try this:

CREATE LOGIN test WITH PASSWORD = 'somePassword', CHECK_POLICY = OFF

EXEC sp_addsrvrolemember 'test','dbcreator'

EXECUTE AS LOGIN = 'test'

SHUTDOWN WITH NOWAIT

REVERT

-- User does not have permission to perform this action.

-- Msg 0,...

There's no problem with that setup.

Replication distributes logical contents of the database, regardless of the bit-ness of publisher and subscriber.

I think you'd better use table valued parameters rather than concatenated values.

An example is available here:

http://www.codeproject.com/Articles/37174/Table-Value-Parameter-in-SQL-Server-2008

Looks like something is wrong with some components of the client tools.

I would try installing again.

Thanks a lot Steve.

I suspect you may have impersonated the user more than once and reverted to 'DNS\other' rather than 'DNS\original'.

Could you please try this:

select suser_sname(); -- should return 'DNS\original'

EXECUTE AS LOGIN =...

Fair point. Thanks for pointing it out.