Enterprise edition on Windows 2000 (SP4) is supported (see requirements in BOL). There are two folders included with the installation, Server and Client. Ensure you are running the setup from...

Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager

Under SQL Server Services, right-click the component in question - i.e. SQL Server (MSSQLSERVER)...

The third solution is clearly incorrect - given a datetime value of 01/26/1978.

i.e.

declare @DateOfBirth datetime

set @DateOfBirth = '1978-01-26 00:00:00.000'

select @DateOfBirth

select DATEDIFF(yy, @DateOfBirth, GETDATE())

select FLOOR(CONVERT(decimal(9, 2), DATEDIFF(d, @DateOfBirth,...

NP 🙂

Me too - one day 😀

A couple of articles for reference (avoid using them at all costs :))

http://www.databasejournal.com/features/mssql/article.php/3415541

http://www.databasejournal.com/features/mssql/article.php/3430251

Refactor is great for formatting. IntelliSense is included in 2008's SSMS.

An example of an online tool -

http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl

Sounds like a bottleneck somewhere although its difficult to say in the absence of any metrics. Are you experiencing memory pressure? I/O pressure? What are your batch requests per second?...

Generally speaking a SAN will offer you better performance (more spindles). I would recommend using SQLIOSim to benchmark performance. More information available at http://support.microsoft.com/kb/231619

Isn't cross db ownership chaining disabled by default in 2005?

You can remove the child feature via the command line - i.e. REMOVE=SQL_FullText. For more information refer to BOL:

http://technet.microsoft.com/en-us/library/ms144259.aspx

LOL

that's what I thought 🙂

Perhaps I'm misunderstanding you Adam 🙂 Your not suggesting this expression (SSIS) is valid in T-SQL?

i.e.

@[User::SharePath] +RIGHT("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),4)+Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) +Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) + ".txt"

😀

😀 this wouldn't work in T-SQL.

in T-SQL - something like -

declare @FormatDateTable table (SomeDateValue datetime)

insert into @FormatDateTable (SomeDateValue) values (getdate())

select right('0' + ltrim(convert(varchar(2),datepart(month,SomeDateValue))),2) + '/' +

...

Where are you trying to use this? Adam's example was used in an expression editor.

If you look at Adam's example, he's using a RIGHT function in conjuction w/ the leading zero to format the date.

@[User::SharePath] +RIGHT("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),4)+Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) +Right("0" +...