Viewing 15 posts - 37,396 through 37,410 (of 39,511 total)
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
Also, there are a few good articles on this site. Click "search" and enter encryption.
Steve Jones
June 19, 2002 at 5:24 pm
There is a check box on th Tranform Data Task (Assuming you used this) that specifies the load size of the transaction. Set it to 1 and see if this...
June 19, 2002 at 5:07 pm
Good advice from Antares. My personal list:
At least 3 physical Arrays (not drives)
: RAID 1 - OS and SQL
: RAID 1 - Logs
...
June 19, 2002 at 4:53 pm
Books On Line has some good information on each of these. I'd read about it there.
Steve Jones
June 19, 2002 at 4:48 pm
You are welcome. Glad it helped and it's the simplest way to do this. You can even use the Dynamic Properties task to "change" the statement based on some other...
June 19, 2002 at 4:47 pm
Viewing 15 posts - 37,396 through 37,410 (of 39,511 total)