Unfortunately, replication does not permit an object that is published to be dropped.

SQL 2005 does allow you to ALTER a stored procedure that is published and can replicate...

The biggest problem with log shipping for a reporting database is that every time you restore the logs to the reporting database, you need to kick everyone off that database...

I think that you are pushing the limits of what you can easily do with SQL Server Agent. Either use another scheduling engine that knows about these sort of...

One option is to use the system table "syscolumns"...

SELECT object_name(id) as TableName,* FROM syscolumns

where name = 'CustomerID'

you are trying to create to foreign key reference to the tenant table before the tenant table has been created. All you need to do is move the creation...

SQL Agent normally logs its activities. In Enterprise Manager, right click on SQL Server Agent and select Logs.

There may some some information in the SQL Server Log or possibly...

You definitely can use SSIS to achieve what you are after. The simplest approach is to use 2 data flows.

The first imports a unique (distinct) list of...

You cannot do this with a restore - all 3 files will need to be restored initially.

Once you have the files restored, the data in the 2 files that you...

Someone has configured SQL Server to accept Windows logins only (not SQL Server logins).

If you are needing to login using "sa" you will need to change the configuration...

If the users/roles exist in both the publishing and the subscribing databases, you can get replication to copy the permissions for the stored procedures. The @schema_option parameter is the...

Some source systems allow fact data to exist without the related reference data.

For example, you may allow the creation of an invoice for a particular customer before the...

You could try something like the following.

USE MASTER

declare databases cursor for select name from sysdatabases where name not in ('master', 'tempdb', 'msdb', 'model', ...any other databases you do not...

Database snapshots use a feature of the NTFS file system that not available with FAT32/RAW file systems.

Whilst I don't claim to understand exactly what NTFS is doing, it is something...

There is only one issue with restoring a SQL 2005 database into SQL 2000...it cannot be done. The physical structures between the 2 versions have changes and are not...

I am afraid that you really can't achieve what you are after. The code you include within your report actually executes on the web server (within reporting services) and...