there is a plug in for source safe on this site which keeps all the DDL in source sage for you; you could use that application as far as source...

here's another way to get them by using a cursor to enumerate the procs, and simply using sp_helptext:

declare

 @isql varchar(2000),

 @provname varchar(64)

 declare c1 cursor for select name from sysobjects where name not...

the GUI doesn't let you browse to, or paste a UNC path; so to use the GUI, you MUST map a drive; if the problem was a scheduled job, then you...

from http://www.windowsitpro.com/Article/ArticleID/14025/14025.html

there's a difference between a primary key, which technically can span multiple columns, and a column that has the identity function on it to auto generate the next value of...

i didn't think actual database backups were labeled with a version... i thought only the server had an @@version, and the data was always backed up to an 8.00 version,...

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