typically you get the results of a function like this:

select dbo.fnWTRCenPrtDivData(param1,param2)

if any of the parameters are supposedly optional, where they assume a value, you need to use the...

there's a few issues here:

a stored proc isn't going to return a set or records from a different database unless you explicitly refer to the database:

select * from master.dbo.cities

if itis...

almost, i replaced every </TD> with &nbsp;</TD> as there are a few places where the cells have no contents; they render as <TD></TD>, so they don't look right in the...

I found that to be a great script as well; the only change I made was adding a &nbsp; to the closing </TD> tag so that cells didn't appear wierd...

could you add a check constraint that says column2 must be less than or equal to column 1?

that would prevent 3,2 or 2,1 from inserting.

that way you enforce the order...

isn't this kind of situation used when you have multiple locations using the identical database, and you need to merge the databases back together at some point? also, i thought...

i read the question differently: can you execute sp_whatever, that exists on server1, on server 2.

my answer is that you must copy the proc to the other server. I think...

i THINK this sql will list all tables defined row size:  the LENGTH column in syscolumns has the #of bytes used for the column definition; a varchar(30) has 30, nvarchar(30)...

if you try to install the enterprise or standard versions of SQL server on your machine, it will automatically "dummy itself down" to the desktop version / MSDE.

the full verison,...

what happens when you need to tie all those tables together for a quarterly , semi-annual or yearly report?

you'll spend a ton of time writing reports or views which work...

neat; i found out that this is an extended stored procedure when i tried to sp_helptext sp_refreshview.

users become orphanded based on the SID tied to their login.

so if you create a user 'Bob' one one server, a unique ID (SID) is assigned to that login; if...

there is really nothing to it; you download the service pack , open it and it is a couple of NEXT>> buttons;

it will stop the server automatically,(so don't do it...

the issue is proably your CleanInput() recordset; if it is returning an empty string instead of NULL or ZERO for things that expect an integer value(like ATTEMPTS) then you'll get...

Query analyzer does not have the ability to prompt; you end up having to populate variables before you run the script like

declare @var varchar(50

set @var='somevalue'

select form sometable where val=@val

you...