Viewing 15 posts - 36,346 through 36,360 (of 39,720 total)
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
you need a table datatype to return to. Or a temp table. You can do an
insert MyTable exec spOne
as well to get a result set into a table.
Steve Jones
April 17, 2003 at 10:49 am
SQL Server will stabilize at some point, but it usually expects and likes to be the only app on the server. Is this a shared server? Other applications running?
How much...
April 17, 2003 at 10:44 am
Great idea. We want more demographics. Interesting to some people, but advertisers love it. Helps us keep the community growing.
One issue is that we get relatively few responses to...
April 17, 2003 at 10:41 am
Viewing 15 posts - 36,346 through 36,360 (of 39,720 total)