Viewing 15 posts - 181 through 195 (of 816 total)
if your main concern is sql agent problem/error then why you interested in the error of SSAS.you should be getting some error when you try to start sql agent job....
August 1, 2011 at 3:35 am
If you saying that your first step is still running and you able to see the status of that step as as "Running" but still step 2 sending mail, then...
August 1, 2011 at 3:31 am
Anyone know how to stop the execution of subsequent tasks until the agent job has completed please?
Why don't you configure the send mail task in your package itself, instead of...
August 1, 2011 at 3:03 am
are you sure its sql 2005? For me, it seems like you defined some facets and defined them in policy using which is available only in SQL server 2008 onwards
August 1, 2011 at 2:54 am
create proc testproc (@testval nvarchar(50))
as
begin
select @testval
end
when i executed "exec testproc 'ashish'"
result in profile in column TextData :-
exec testproc...
July 27, 2011 at 3:24 am
if we have the code then it will be easy to comment.
But as of now, I think one value if you dont want then you can make it to...
July 27, 2011 at 2:09 am
The above mentioned settings give the name of the variable used not the value.
I have just created the below procedure and tested it in profiler.
create procedure t111 @id int
as
select...
July 27, 2011 at 1:44 am
Or one more alternate is to archive old data to new filgroup and then schedule filegroup backup which will be much quicker and less space consuming.
July 26, 2011 at 5:45 am
The Recovery model is Simple, so there a no log backups.
thanks, I should read it in your earlier mail. Why cant you switch it to full recovery?
Also as you...
July 26, 2011 at 5:14 am
Our full backup takes up to 10 hours, and a diff maybe 15 minutes.
it seems like there is not much modification in your database and thats why your diff finish...
July 26, 2011 at 4:37 am
you can run profiler using filters for the database specific and user specific(to make less entries in profiler) and then run the stored procedure using the user you mentioned in...
July 26, 2011 at 4:29 am
I have got much simpler process for moving the data files from old disk to new disk.
1) Stop the sql services.
2) Copy the files from old disk(a) to new disk(b)
3)...
July 26, 2011 at 3:54 am
there is a person on this earth for me whom I follow for this type of maintenace task and his name is Ola. He is kind enough to keep updating...
July 23, 2011 at 2:09 am
When its coding, i dont hit my head in it. I simply use google for it and then customise the solution as per requirement.
this article will give you clue --...
July 23, 2011 at 2:05 am
I need to get rid of all potential duplicates so the merge can go through. What technique can I use to find all the rows, which satisfy the T.animal...
July 23, 2011 at 1:19 am
Viewing 15 posts - 181 through 195 (of 816 total)