Viewing 15 posts - 37,621 through 37,635 (of 39,757 total)
Clustered index stores the data in the order of the index (physically). Nice for columns used in range queries (like dates). Only one per table as you can only store...
June 21, 2002 at 12:52 pm
June 21, 2002 at 10:41 am
Not easy. You'd have to build a SQL join for each column you need. USually this is done with dynamic SQL as
select emp.emp-code, b.time as b.date, c.time as c.date
...
June 21, 2002 at 10:29 am
You can in T-SQL, but it's an ugly mail message you have to build. I too wish MS had included this.
Send it to sqlwish@microsoft.com ![]()
Steve Jones
June 21, 2002 at 10:22 am
When you use Windows Auth, the windows credentials (essentially a token) are passed to SQL Server, which then verifies this with a DC.
First, it's a security risk across the Internet...
June 21, 2002 at 10:19 am
Antares is correct. When you execute certain stored procedures (system ones) permissions are rechecked for security purposes. I think the solution proposed above is a great one.
Steve Jones
June 21, 2002 at 10:13 am
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
Viewing 15 posts - 37,621 through 37,635 (of 39,757 total)