SQL Server Express

Scheduling Jobs in SQL Server Express

  • Article

As we all know SQL Server 2005 Express is a very powerful free edition of SQL Server 2005. However it does not contain SQL Server Agent service. Because of this scheduling jobs is not possible. So if we want to do this we have to install a free or commercial 3rd party product. This usually isn't allowed due to the security policies of many hosting companies and thus presents a problem. Maybe we want to schedule daily backups, database reindexing, statistics updating, etc. This is why I wanted to have a solution based only on SQL Server 2005 Express and not dependent on the hosting company. And of course there is one based on our old friend the Service Broker.

2008-09-23

3,241 reads

SQL Server 2005 Express Edition - Part 20 - Authenticating Merge Web Synchronization

  • Article

We have been discussing SQL Server 2005 Express Edition replication-specific features, investigating authentication mechanisms that are available in order to accommodate connection attempts from remote clients interacting with SQL Server-based distributor via Internet Information Services. We will continue coverage of this topic here.

2008-04-21

1,679 reads

Blogs

Social: Going Along to Get Along

By

It’s the eve of the Fourth of July, when the Declaration of Independence is...

Daily Coping 3 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using Docker Volumes for SQL Server in Linux

By

No, not that kind of volume! Over the past couple of blog posts, I...

Read the latest Blogs

Forums

Connecting To Quickbooks via SSIS

By stricknyn

Hello everyone, Been doing some googling trying to find some info on connecting to...

Adding NOT NULL to column with existing rows causes page bloat

By timoq

Hi, I'd like to know why the page count is almost exactly doubled for...

Stretch database

By mtz676

Is there anything similar to a stretch database in mysql where an on-premise mysql...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers