Viewing 15 posts - 706 through 720 (of 1,655 total)
Not sure what exactly you want to kill. If your looking for old processes which are no longer active, you can use the sys.processes table or in SQL 2005 the...
November 10, 2008 at 5:59 am
Keir,
there are loads of reasons why SQL mail is not working properly and without more details it's almost impossible to tell what is wrong in your case.
But here you...
November 6, 2008 at 2:24 am
I'm not aware of any relationship between dual/quad-core and the SQL Edition you should choose. Both work fine on dual and quad-core systems and both support all (logical) CPU's as...
October 29, 2008 at 3:55 am
You don't have to define the port number for a linked server. The main reason for this is that named instances by default use a dynamic port which can change...
October 29, 2008 at 3:14 am
Very good article.
Maybe I should start re-testing my defragmentation routines.
October 29, 2008 at 3:08 am
Why can't you use the standard transactional replication? This type of replication reads from the transaction log, so it should provide everything you need.
October 28, 2008 at 2:06 am
There's not standard way of finding out when a user/login was used the last time.
What you can do is either enable Login auditing for succesful logins and then check the...
October 27, 2008 at 3:04 pm
The CREATE/ALTER TRIGGER statement has a "Not for Replication" clause. Just add this to your triggers.
October 27, 2008 at 3:01 pm
Without working on the system myself I can't say for sure why the user doesn't have enough permissions anymore.
ISince you use the Local\System account my guess would be that someone...
October 27, 2008 at 3:12 am
Obviously the account under which the maintenance plan is executed has not enough permissions. Check which account is used.
October 27, 2008 at 2:19 am
Can anybody tell me if it's normal for the mssqlsystemresource files to be dated 10/14/2005?
If I remember correctly the date of the files depends on your Servicepack/Hotfix level. A date...
October 24, 2008 at 2:37 am
You cannot deny (or grant) Drop permissions only.
In order to be able to drop a object you need to have at least ALTER permission on the object. Unfortunately for...
October 24, 2008 at 2:25 am
If you have reporting enabled in your maintenance plan, there should be a logfile with more details about the error.
The error you gave us is just a general error which...
October 24, 2008 at 2:09 am
Wandrag (10/22/2008)
No - you can't update and return results in the same query.What do you want returned? The records before update, or after the update?
In SQL 2005 you actually can...
October 22, 2008 at 2:25 am
Sounds like you're trying to install a 64-bit version on a 32-bit machine (or the other way round).
October 20, 2008 at 4:03 am
Viewing 15 posts - 706 through 720 (of 1,655 total)