Viewing 15 posts - 42,001 through 42,015 (of 49,562 total)
Jayakumar Krishnan (1/4/2009)
Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 120.2.7.30]
That looks like a Kerberos issue. Are there any other errors in...
January 4, 2009 at 2:24 pm
As the error says, siteID cannot be in the order by clause, because it's not contained in the group by and it's not an aggregate.
What's the point of having it...
January 4, 2009 at 1:51 pm
peter.chafin (1/4/2009)
There has to be some way to read the TRN files to see what types of transactions were taking place.
There are, but they are not cheap. SQL has undocumented...
January 4, 2009 at 1:23 pm
nbourre (1/4/2009)
Can someone tell me what's wrong with this syntax?
SELECT @lastSite = MAX(siteID)
FROM sites
WHERE fkSectorID = @sectorID
ORDER BY siteID DESC;
January 4, 2009 at 1:16 pm
nbourre (1/4/2009)
Now let's take that a step further. Let say I would like to generate the site with the last number from the same...
January 4, 2009 at 12:47 pm
It's very hard to tell why after the fact.
Were there any reindex jobs running during the period the log grew?
Having deleted tran log backups, you should do a full back...
January 4, 2009 at 12:42 pm
Untested, but I think something like this should work.
IF EXISTS (SELECT 1 FROM inserted WHERE siteID IS NULL)
UPDATE Sites SET siteID = sectorCode + CAST(pkSiteID AS NVARCHAR(5))
FROM
Sites INNER...
January 4, 2009 at 12:07 pm
Jody Claggett (1/4/2009)
Actually, what I have come to find out is that 2008 and 2010 are minor releases, which means the major portion of the engine hasn't changed.
SQL 2008...
January 4, 2009 at 11:34 am
DBADave (1/4/2009)
We have a 100+GB database that eventually with grow to 500GB+.
A 100GB database is not large. Even a 500GB doesn't qualify as very large.
Reindexing takes a...
January 4, 2009 at 9:06 am
parth83.rawal (1/4/2009)
Hope this will do.
Please read the article that I posted about how to post sample data and table structure.
January 4, 2009 at 6:42 am
John Marsh (1/4/2009)
Hello,Was there not a “State: NN” part to the Error Message? The value for State is important in determining the exact reason for Logon failure.
State'll be in the...
January 4, 2009 at 4:06 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 4, 2009 at 3:38 am
george sibbald (1/3/2009)
January 4, 2009 at 3:36 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 4, 2009 at 2:48 am
iqtedar (1/3/2009)
but wat should he do if he needs to reduce the log file size..thanks in advance and wish you all a very happy and prosperous new year..thanks
A once off...
January 4, 2009 at 2:35 am
Viewing 15 posts - 42,001 through 42,015 (of 49,562 total)