Viewing 15 posts - 856 through 870 (of 1,219 total)
bukester (8/16/2013)
2) Similarly - If I add up SP:StmtCompleted for a give proc. I would expect SP:Completed to equal all of the statements. Its the sum of all the parts.
Not...
August 16, 2013 at 4:16 pm
Boris Pazin (8/16/2013)
August 16, 2013 at 4:12 pm
I would guess that if you goto Object Explorer -> Security -> Linked Servers -> Providers -> IBMDA400 and right-click and select properties, you will find that Disallow adhoc access...
August 16, 2013 at 3:53 pm
But now you have changed the stored procedure, so there is no dynamic SQL, and you should have to use quotestring. What I had in mind was:
EXEC msdb.dbo.sp_add_job @job_name=N''' +...
August 16, 2013 at 3:49 pm
Yes, it is common to have such columns, but you need to take precuations to have them filled in. Commonly, a column called modifytime would have a default of getdate()...
August 16, 2013 at 3:33 pm
READ_COMMITTED_SNAPSHOT is an excellent idea, but it will not apply in this case, as UPDLOCK implies REPEATABLE READ.
August 16, 2013 at 8:03 am
Yes, you can say:
CREATE USER Nisse WITHOUT LOGIN
Like any good feature, this has a multitude of use cases. Here are a few:
1) You don't want to grant end users direct...
August 16, 2013 at 4:40 am
dhananjay.nagarkar (8/15/2013)
If you can explain in simple words the difference to me would be...
August 15, 2013 at 4:14 pm
As you are only thinking aloud, it is difficult to know where to butt in, as information you have given is likely to be incomplete.
But if you are on Enterprise...
August 15, 2013 at 4:11 pm
Note sure that I understand. You talk about deleting duplicate rows, and in that case the solution would be:
;WITH numbered AS (
SELECT row_number() OVER (PARTITION BY Name,...
August 15, 2013 at 4:03 pm
I don't see any highlighting?
But I do see a syntax error. This is your stored procedure:
create procedure dbo.CreateBackupAgentJob @DatabasenameInput varchar(100) = null as
declare @JobCode varchar(max)
declare @thisserver nvarchar(100)
select @thisserver = (select...
August 15, 2013 at 3:54 pm
Any particular reason you expect this to work in the first place?
From where I sit, I can only encourage you to check that
1) You have spelled the database name correctly.
2)...
August 15, 2013 at 3:32 pm
How about reading the error message? It says that there is no column name for column 1. So you need to add one. Since there an operator (COLLATE) the column...
August 15, 2013 at 6:40 am
Try starting SSMS by right-clicking and select Run as Administrator.
August 15, 2013 at 2:45 am
So here is the answer you did not expect: in a relational database a table is supposed to model a unique entity, and each column is supposed to model a...
August 15, 2013 at 2:26 am
Viewing 15 posts - 856 through 870 (of 1,219 total)