Viewing 15 posts - 36,526 through 36,540 (of 39,903 total)
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
You can't do this AFAIK. This really is looking for stored procedures. Alteratively you could probably script something that could take the parameters and submit some dynamic sql.
Steve Jones
April 17, 2003 at 10:59 am
Great advice from Brian and I totally agree with choosing your strongest subject first, it will reduce the tension. I'd also plan on working over a short period of time...
April 17, 2003 at 10:56 am
When you say schema do you mean just the columns? Or do you need other information?
select * From information_schema.columns should help.
Steve Jones
April 17, 2003 at 10:51 am
Viewing 15 posts - 36,526 through 36,540 (of 39,903 total)