Viewing 15 posts - 2,671 through 2,685 (of 3,232 total)
I don't think your agent account is the problem here (although I do not recommend using an account with Domain Admin privledges). Check your scheduled jobs that run your DTS...
August 11, 2006 at 8:44 am
If you are wanting to view current users, use sp_who2. If you are wanting an ongoing log of user connections, you will have to set your SQL Server's security audit...
August 10, 2006 at 1:56 pm
Use Raiserror. Use with log if you want the error to appear in the log file.
select @count = count(*) from test_tbl
IF @count > 0
raiserror('Your Error Message Here',16,1) with...
August 10, 2006 at 12:18 pm
"Since SQL Server 2000 does not provide functionality like Row_Number(), I am taking a variable of type Table with an identity column. I am pusing all the relavent data into...
August 9, 2006 at 4:20 pm
Your biggest problem is that, not only are cursors inefficient, you are using nested cursors. I would suggest finding a set based solution to your problem. I will take a...
August 8, 2006 at 4:33 pm
Joe, Peter's set based solution is a much better approach to using a loop of any kind. There are many, many posts and articles on SSC detailing the benefits of set...
August 8, 2006 at 4:26 pm
What does your execution plan show? I would guess that it is doing an index seek based off of your WHERE clause and that the delay is the lookup of...
August 8, 2006 at 1:24 pm
It looks to me like your colleague has found a set based method to his UPDATE where most people would have created a cursor. While his code may be a...
August 8, 2006 at 1:16 pm
I'm a little unclear on what you are asking for. If you just want to limit your groupings by only grouping A, B when c = 3, then just do...
August 8, 2006 at 11:02 am
It is a little unclear on what you are asking. What do you mean by 'Transition'? What is your role in the 'Transition'?
August 7, 2006 at 4:24 pm
Not only is it unsupported, but I think it may even void your support for that licensed copy.
August 7, 2006 at 9:24 am
Yes, Vladan is correct. If you use your example data in my example, you will not get the results you show in your example.
August 7, 2006 at 9:06 am
declare @table table (mydate datetime)
insert into @table
select '01/01/2005' union all
select '02/20/2005' union all
select '03/20/2005' union all
select '04/01/2005' union all
select '05/04/2005' union all
select '01/01/2006' union all
select '02/01/2006' union all
select '03/04/2006' union...
August 4, 2006 at 11:09 am
What datatype are your columns? You are either using char() or you are using varchar()
and the application is inserting the trailing spaces. Either way, use trim to display them...
August 4, 2006 at 10:15 am
Viewing 15 posts - 2,671 through 2,685 (of 3,232 total)