The real puzzle here (for me at least) is why the stored proc runs fine when executed manually but fails as a job under the same user, and also that...
Another consideration; As you may already know; when you create a SQL Agent job, then you specify the job owner and the job runs using the...
I am somewhat puzzled why anyone would create a linked server that is linked to itself, especially one that is "Be made using the login's security...
How exactly are you "making an ODBC connection" ? You are probably using a System DSN or User DSN connection, is that correct ? When you configure a...
It does not look like an error that one would see in SQL Server Management studio. Are you seeing this error from a program application or a website...
--Create some test numbers in a table, include some duplicates; CREATE TABLE #temp1 (ID_number varchar(20)) GO insert #temp1 values ('12345') insert...
To create queries that comprehensively cater for all "date-time in" and "date-time out" scenarios, you would need to consider nightshift staff that...
Just as addition; Your initial post did not specify that your intended query was a DAL (select) type, which is why I proposed an UPDATE query. To...
I can say from my experience that I have also had a mixed environment of Windows 2003 / Windows 2008R2 servers, having client connections to a common...
You are somewhat vague regarding where to source the "another value (obtained from a subquery)" and this detail is an imporant part of creating the...
My bad. I definitely misunderstood the original post :) I had thought you were referring to the LSN numbers contained in the backup files...
Keep in mind that every row of a returned query result will always contain the same number of columns/fields and that each column will always have a...
The ROWLOCK hint only applies to UPDATE and DELETE statements. It does not apply to INSERT statements. During an INSERT; only the rows that you are...
If you are performing a 'standard' SQL Server 2005 backup, with default options, and if the physical disk media is healthy, then the backup will...
C++ (VS 2008), 'adAsyncExecute' and the 'raw_ExecuteComplete' event are not terminologies inherently used by SQL server. You are more likely to find...
Note that your syntax example above will not drop all database objects, it will only drop user-created tables ( because you specified type in (N'U')...
As I understand it; the number of i/o requests sent by SQL server largely depends on the the query execution plan calculated by the engine. For the...
Some useful links, perhaps;...
Thanks for sharing your solution. It would seem inconvenient though, to disable hyperthreading on the whole machine, for the sake of SQL Server, when...
Not really what I meant, no. I was saying that "multiple logs ship at the same time on separate jobs " might be causing the problem. If it is a...
Separate names with a comma.
