Viewing 15 posts - 37,381 through 37,395 (of 39,511 total)
If it doesn't have to be realtime, then I usually insert the data into a table and have a job come create those users every minute.
I had a similar issue...
June 21, 2002 at 9:53 am
Couple things:
1. You do not need to stop SQL to detach or attach. It is an online op.
2. I would just do the log files, be sure you adjust the...
June 21, 2002 at 9:45 am
I cannot speak directly to your issue, but I am wary of having servers that communicate on different Service Packs. I would plan on mirating them all to the same...
June 21, 2002 at 9:39 am
SQL 2000? If so, you can use a dyanmic properties task inside the package to get your parameters. Otherwise, I believe you can pass them in from a command line,...
June 20, 2002 at 3:55 pm
June 20, 2002 at 1:18 pm
You could run profiler, but that might result in gobs of information. I would expect that shared locks were being placed on the perm tables. You should be able to...
June 20, 2002 at 1:10 pm
June 20, 2002 at 1:06 pm
Tend to agree with Andy. BOL, while not always accurate, does provide a nice reference point for someone to check in addition to the post. I just wish we could...
June 20, 2002 at 10:58 am
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
Viewing 15 posts - 37,381 through 37,395 (of 39,511 total)