Viewing 15 posts - 37,336 through 37,350 (of 39,456 total)
use GROUP BY and the ID fields
select count(*), id
from tableA
group by id
Steve Jones
June 20, 2002 at 10:40 am
user_name or suser_name() will help. Create a table to store the info in and insert this along with getdate() in a delete trigger.
Steve Jones
June 20, 2002 at 10:39 am
June 20, 2002 at 10:35 am
You cannot. System stored procedures come with the server. If you create it, it is User.
Why do you want to?
Steve Jones
June 20, 2002 at 10:30 am
June 20, 2002 at 9:57 am
Or put a delete trigger that rollsback any deletion. That will tell you if it's a delete table or a truncate.
Steve Jones
June 20, 2002 at 9:53 am
June 20, 2002 at 9:51 am
In general, if you grant permission to a stored procedure, and the owner of the stored procedure also owns underlying objects, it will run.
In the case of create table, the...
June 20, 2002 at 9:49 am
What is really funny is why you grant "CREATE TABLE" to someone different when the table already exists. 🙂 There isn't anything you can do with create table if the...
June 20, 2002 at 9:46 am
Not sure. I have a SQL2K box right here (not personal, std) and I use SQL_LATIN1_General_CP1_CI_AS as the server default. All the databases are set here. When I then create...
June 20, 2002 at 9:42 am
np and you are correct. SQL will manage the inserts by transaction. Works better with each version.
Steve Jones
June 20, 2002 at 9:38 am
I would create a temp table or a staging table of some sort on the external. Then transfer all custom messages (DTS, insert..select, whatever) to this table. Run a query...
June 20, 2002 at 9:37 am
2nd vote for Andy's thoughts. Is ROLE an application of some sort or do you mean application roles?
Steve Jones
June 20, 2002 at 9:26 am
All in all, I recommend backup and restore. Others may differ, but in the last ten years, it's been the easiest and more reliable.
Steve Jones
June 20, 2002 at 9:24 am
June 20, 2002 at 9:16 am
Viewing 15 posts - 37,336 through 37,350 (of 39,456 total)