FWIW ... early 2008 I joined a webcast regarding mysql and performance.

The main eye catcher was "to avoid joins"... because that was apparently considered for the niche "oracle /...

IMO sqlserver in finally entering companies because msaccess no longer suites their needs (performance / size).

"insert disk and run" now gets some shop it guy to the point they...

system xprocs or sprocs are equal for 32bit and 64bit.

As mentioned by the urls, you'll have to build your own version.

If doing it using xp_cmdshell, encapsulate it in a sproc...

presentation ....... should be handled by the front end application !

(and preferably client side)

Do not bother sqlserver with how you want things actually presented for the human eye.

One of...

it's gone in sql2005 ... it was undocumented .... so shouldn't have been in use ...

check out :

- http://forums.databasejournal.com/showthread.php?t=41753

- http://www.simple-talk.com/sql/learn-sql-server/building-my-first-sql-server-2005-clr/

This is the same like having an insurance ...

As already stated, this may be a straight $$ matter.

Some companies want to cut costs NOW.

The only thing you can do...

Mani Singh (11/17/2008)

---

Remember, the trace is recycled based on the transaction level of you SQL Server. So you might end up filling up the trace in 1/2 a day or...

double check the path to the xp is correct.

Check its path on the "old" server or maybe even restore an old mastedb (to an alternate dbname !) to find out...

One of the flaws in SQL2005 partitioning, is that you need to add the partitioned key to any unique or primary key, if you want that index applying the partitioning...

IMO you'll have to simply order it all

select ProductID ,

min(ProductName) as ProductName,

min(ProductCode) as ProductCode

from #Product

group by ProductID

I'm completely with Fernando on this xp_cmdshell attitude !

It's a registry key !

have a look a this script ...

-- Alter Local Default Backup Directory

-- xp_fixeddrives

Declare @NewDrive nchar(1)

Declare @RootDirectory2Add nvarchar(512)

Declare @NewDirectoryPath nvarchar(512)

Declare @Override char(1)

select @NewDrive = N'F'

,...

did you check sp_helprolemember ?

btw with sql2005 you can use:

select *

from sys.database_permissions

where class_desc = 'schema'

and grantee_principal_id = DATABASE_PRINCIPAL_ID ('Urole_Appl')

no, not using a system stored procedure.

also with...

you've posted in a sql7- sql2000 forum ??

- are you using the correct cluster server ?

double check you opened clusteradmin to the correct cluster configuration (perferably "." (i.e....