Viewing 15 posts - 5,176 through 5,190 (of 5,356 total)
Hi matt1,
basically, you have to cut and paste the whole code into QA, select the correct db (in my case master) from the combobox and hit F5 to run the...
May 26, 2003 at 12:34 am
Ok,
I'm going in first. First of all a little of my bio.
I was a developer with a small software company with responsibility for implementing algorithms for risk management and derivatives...
May 23, 2003 at 9:03 am
May 23, 2003 at 8:41 am
Hi SQLBill,
quote:
Brian,This page could not be found (23 May 1000 EST): http://www.sqlservercentral.com/testcenter
And I'm curious to see how I did against others.
May 23, 2003 at 8:18 am
Hi Allen,
quote:
EXEC sp_MSforeachtable 'sp_spaceused ''?'''
I wasn't aware of this. Thanks!
Cheers,
Frank
May 23, 2003 at 8:13 am
I don't know if there is a builtin command for what you want.
I use this one:
CREATE PROCEDURE sp_rpttblspc (@dbname varchar(30) = null, @tblname varchar(31) = null)
as
/********************************************************************************/
/*Created BY :Umachandar Jayachandran(UC)*/
/*Created ON...
May 23, 2003 at 8:11 am
I don't if this matches you need. In my spare time I spent a lot of time at http://www.sourceforge.net. I've seen there a lot of projects about reports and report...
May 23, 2003 at 8:02 am
Thanks Jay,
I thought MS handles things similar across its products
ROTFL
Cheers,
Frank
May 23, 2003 at 7:59 am
Any reasons why a SQL Server BIT value of 1 is displayed in an Access db as -1 ?
Cheers,
Frank
May 23, 2003 at 7:01 am
Hi Robert,
try sp_defaultdb
sp_defaultdb [ @loginame = ] 'login' , [ @defdb = ] 'database'
Also see BOL
Cheers,
Frank
May 23, 2003 at 6:10 am
sqlservr.exe parameter e.g
sqlservr.exe -m
Cheers,
Frank
May 23, 2003 at 6:04 am
Hi Hans,
quote:
I would prefer not to use excel automation inside an SQL task (which I am not sure is working as our...
May 23, 2003 at 5:49 am
Hi Hans,
quote:
I would prefer not to use excel automation inside an SQL task (which I am not sure is working as our...
May 23, 2003 at 5:34 am
Well, some thoughts on this.
What you can do, is write a small app in some language that checks your directory size and returns either 0 or 1. This return...
May 23, 2003 at 5:32 am
Viewing 15 posts - 5,176 through 5,190 (of 5,356 total)