With the jobs set for snapshot generation on the hour and subscription jobs on the quarter hour I have had no errors all night.

Chris

OK, here's what I have, after some more testing.

I now believe that if the subscription jobs are running at the same time that a NEW snapshot is being created, the...

To test my question in the last post, I have changed the schedules to generate the publication on the hour, and the subscriptions run at quarter after, every hour.

Thanks,

Chris

This morning the publication was generated at 7:00 and the subscriptions were run at 8:00. I got the following errors:

2012-02-16 13:05:01.919 Bulk copying data into table 'Zip'

2012-02-16 13:05:01.919 Bulk copying...

Jeff Moden (2/7/2012)

---

As a sidebar, I'm loath to use the master DB as the default for any login because people forget they're there and end up saving tons of garbage...

No, there are no schema issues here. Everything is in DBO. I do wish I could replicate the issue so we could try different things to figure out what happened.

Chris

That's the curious thing. The truncate table seems to have selectively deleted records, as if I had issued a Delete statement with criteria. I have been using Truncate since the...

The first time around the proc was executed from an SSIS package, but when I started researching it I was executing from a query window.

Normally, if you select Top X...

Try this:

SELECT DATEPART(YEAR,DATEADD(year,-1,GETDATE())) [2010]

I don't know that dynamic column headers is wise, as SSIS is very particular about metadata, and will likely have a problem with header names that change.

Chris

The error, which comes from SQL Server, and does show in SSMS, but does not keep records from returning, is:

Warning: Null value is eliminated by an aggregate or other SET...

That was the ticket!

Essentially:

declare @command nvarchar(4000)

set @command = 'Use [?];

Select ''?'', R.TABLE_SCHEMA, R.TABLE_NAME, T.TABLE_TYPE, R.COLUMN_NAME, R.DATA_TYPE, R.CHARACTER_MAXIMUM_LENGTH, COLUMNPROPERTY(OBJECT_ID(R.TABLE_NAME), R.COLUMN_NAME,''IsComputed'') From ?.INFORMATION_SCHEMA.COLUMNS R

Inner Join ?.INFORMATION_SCHEMA.TABLES T On R.TABLE_CATALOG = T.TABLE_CATALOG

And...

OK, things are getting a little better. This:

Select R.Column_Name, OBJECT_ID(R.TABLE_CATALOG + '.' + R.TABLE_SCHEMA + '.' + R.TABLE_NAME )

From MSDB.INFORMATION_SCHEMA.COLUMNS R

returns the name and object ID when run from Master.

This...

OK, simplifying things a bit, I am running this query:

Select Column_Name, OBJECT_ID(TABLE_NAME)

From MSDB.INFORMATION_SCHEMA.COLUMNS

From a different DB than MSDB. With the above query, it runs but returns Null for the...

Here's my query, without the Where clause. I am trying to get figure out if a column is a computer column, and while I have figured out how to do...

Excellent. When I looked for the right way to determine existence of tempdb objects last year that was all I could find that worked, and it did work until today....