Here is one solution:

create

table dbo.SalesLine (

docdate datetime,

product

varchar(

Kirk,

Thanks for the info on getting an error description out of an error code.  I was just starting on trying to figure out how to accomplish this ina package i...

You need to set the trace flag 1807 to configure SQL server to with network-based database files.  You can find a list of some of the documented and undocumented trace...

My plan is to maintain a database of services and their status.  If a change occurs to any services that are critical for a specific server then an email alert...

Here is my guess.  It doesn't like you using default as the value to the parameter.  Just a another guess, but it might work if you quote default ('default').  Don't...

Even if the proc is run 100 M times a day, using a code table is a good idea.  Remember that the requirement that will never ever change, can change. ...

Check BOL.  Per the requirements for indexed views, the view can not have an outer join.

Lynn'

Due to the space in the file name, you need to put it in double quotes:

exec master..xp_cmdshell 'copy H:\Data\MSSQL\Data\Lennar_CFT.mdf "\\ldc-dba-sql-ga\c$\Program Files\Microsoft SQL Server\MSSQL\Data"'

like that.

Lynn

Check this out.  It is a simple call to the datediff function (see BOL for more info):

declare @date1 datetime, @date2 datetime

set @date1 = convert(datetime, '8/29/1959')

set @date2 = convert(datetime, '6/2/1998')

select datediff(yyyy,...

You may also want to be sure to run a transaction log backup prior to any full backup.  The Full backup does not remove commited transactions from the log, even...

You may be getting a null result.  It would help to if you could provide at least a partial layout of the table App and some data to look at.