In our shop, we have an application that uses either a SQL Server or Oracle database. As a result, we have lots of dev servers with SQL or oracle, or dev...

i'm under the impression that SQL7 must be installed first as a default instance.

after that is installed, you could install either/both SQL2000 and SQL 20005 as named instances on the...

i think any error raised with a level above 16 would fail, so in any script, you could simply add this line:

 RAISERROR ('Testing to see if a job fails for...

it also looks like the variables required are available in the third function; in that case it might look more like:

FROM (SELECT * FROM dbo.

the problem is your FROM statements in function 3:

FROM dbo.fnWTRCenPrtDivData INNER JOIN

dbo

.fnWTRTerrierData ON fnWTRCenPrtDivData.

create function ufn_test(

@name1 varchar(30)='Walmart',

@name2 varchar(30)='cookies')

returns varchar(255)

BEGIN

return 'I go to ' + @name1 + ' to buy ' + @name2

END

GO

SET NOCOUNT ON

select dbo.ufn_test (default,default)

select dbo.ufn_test ('Sears',default)

select dbo.ufn_test ('Sears','wrenches')

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,...