Viewing 15 posts - 61 through 75 (of 205 total)
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
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 17, 2012 at 5:38 am
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 16, 2012 at 12:30 pm
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
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 16, 2012 at 6:36 am
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 16, 2012 at 6:13 am
Jeff Moden (2/7/2012)
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 8, 2012 at 7:40 am
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
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 6, 2011 at 1:20 pm
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 5, 2011 at 7:27 am
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 1, 2011 at 7:05 am
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
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
November 1, 2011 at 12:14 pm
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 24, 2011 at 12:40 pm
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 11, 2011 at 11:45 am
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 10, 2011 at 10:37 am
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 10, 2011 at 9:32 am
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 7, 2011 at 1:57 pm
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....
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 3, 2011 at 8:27 am
Viewing 15 posts - 61 through 75 (of 205 total)