Viewing 15 posts - 36,391 through 36,405 (of 39,771 total)
create trigger mytrigger for insert on mytable
update mytable
set field2 = i.field1
from inserted i
where i.mypk = mytable.mypk
Steve Jones
April 22, 2003 at 10:54 am
Windows 2K and SQL 2K do not understand hyperthreadind. To them it looks like extra CPUs exist, and since Std has a 4 CPU limit, that is why you cannot...
April 22, 2003 at 10:52 am
Pls do not cross post. Answered in "General"
Steve Jones
April 22, 2003 at 10:26 am
April 22, 2003 at 10:24 am
Dave,
Apologies if someone snagged your email from here, but as Andy mentioned, we do not sell our emails. All information presented to advertisers is aggregated, so 20% of DBAs do...
April 22, 2003 at 10:21 am
This looks ok. When you say the backup folder is being appended, what does that mean? Can you give an example?
Steve Jones
April 22, 2003 at 10:16 am
You can use DTS to export the data and xp_sendmail or the mail task to then mail it.
Steve Jones
April 22, 2003 at 10:12 am
Note those extensions are defaults. You can call them anything you want.
Steve Jones
April 21, 2003 at 2:20 pm
you don't, but it doesn't make sense otherwise. You need something that is "grouped", which is the sum of something, count, etc.
Steve Jones
April 21, 2003 at 2:01 pm
No, this is by design. if you need to keep memory for your apps, limit sql to some amount.
Steve Jones
April 21, 2003 at 1:55 pm
I have not, though I know they are there. The single valued functions appear to come from the table.
Steve Jones
April 21, 2003 at 1:52 pm
With a 1GB box, I'd suspect SQL will get up to 800-850MB of RAM. That's normal as Brian explained.
Steve Jones
April 21, 2003 at 8:53 am
The BAK extension is usually a full backup. It contains the data and schema, not the mdf and ldf files.
Not sure why your backups are not being deleted. Which version...
April 21, 2003 at 8:51 am
This is in the wrong forum. I'd post this in the T-SQL forum
Steve Jones
April 17, 2003 at 5:43 pm
Not cross database. Permissions are rechecked the dbo in db1 might not be dbo in db 2. You need to grant rights in the 2nd db.
Steve Jones
April 17, 2003 at 5:42 pm
Viewing 15 posts - 36,391 through 36,405 (of 39,771 total)