SQL 2012: SERVERPROPERTY

Total Database Information At Your Fingertips Part - II

This article will help to get some basic information from your databases that may help you in different situations.

RE: xp_cmdshell & ODBC WrapperRead() error...

hi,It seems to be either an old MDAC or a security problem ( is the user granted to execute xp_cmdshell and does he have privs to access the files ). If not it can be a network issue.BTW; how dit you establish to connect the SAN to a Standard Edition. Regarding the documentation on this […]

RE: Parse Full name into first and last name.

This should do it with some assumptions... the assumptions are that you will have no title (Mr., Mrs., etc) and no suffic (Jr. Sr. II, III, IV, etc)./****** Object:  Table dbo.CustomerNameTest    Script Date: 05/21/2004 08:17:40 AM ******/ if exists (select * from sysobjects             where id = object_id('dbo.CustomerNameTest')               and sysstat & 0xf = 3) […]

RE: SQL Server script

Hi, I am in an in house project, so fund allocated for this. I am sorry ! Any alternative? Thanks Jac