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...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
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...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 23, 2003 at 9:03 am
Hi Allen,
maybe this one will do what you need
http://www.vb4all.net/products.asp?ID=50
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
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.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 23, 2003 at 8:18 am
Hi Allen,
quote:
EXEC sp_MSforeachtable 'sp_spaceused ''?'''
I wasn't aware of this. Thanks!
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
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...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
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...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 23, 2003 at 8:02 am
Thanks Jay,
I thought MS handles things similar across its products
ROTFL
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
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
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 23, 2003 at 7:01 am
Hi Robert,
try sp_defaultdb
sp_defaultdb [ @loginame = ] 'login' , [ @defdb = ] 'database'
Also see BOL
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 23, 2003 at 6:10 am
sqlservr.exe parameter e.g
sqlservr.exe -m
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
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...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 23, 2003 at 5:49 am
-m ?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 23, 2003 at 5:41 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...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
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...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 23, 2003 at 5:32 am
Viewing 15 posts - 5,176 through 5,190 (of 5,356 total)