Guess in all it sounded like the Guid options was a poor dissicion for the design teams side. Thanks for the replies thou.

Grant Fritchey (10/4/2007)

---

One key difference, ignoring the "myth" for the moment, is that the constraint can be used as part of a foriegn key if you choose while the index...

Thanks for all the replys.

Tend to agree, the index did not script when I selected Index

This was the SQL script generated by the type:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Customer](

[CustomerID] [int] NOT NULL,

[UserName] [varchar](50) NOT NULL,

[FirstName] [varchar](50) NOT NULL,

[Surname] [varchar](50) NOT NULL,

[IsActive] [bit]...

Normally the assemblies are stored as binary in the db, by default the server can only see its own resources and drives, meanining it can only read assemblies on a...

The execution plan is exactly the same

Good point Eric. I always use brackets but in your case  "select 1 as [Ugly [] Column] --Doesn't Work" it would make much more sense to use text.

l0n3i200n

Hi we had similar errors and the cause was that the agent user's password has changed and could not be started. Also make sure that sufficiant access is allowed for your...

Hi a quick and easy why of solving this problem is to tweak your excel drives a bit. Open regedit and find the following key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel'. Find the 'TypeGuessRows' and...

look under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC

using regedit. ( assume ur using windows ). This should atleast point you in the correct direction.

Try using some other compatible engine. Not sure to what datasource...

Since I didn't receive a reply, I thought I can post the solution I eventualy went with. I've created a webservice which exposes the businessrules and then I used a...

Thanks for the reply Shrikant. I learnt something 2day. Keep well

I agree with Mr. or Mrs 500 you should always use TSQL when doing data manipulation using DML, you should consider CLR functions when ur not doing DML, but...

DECLARE @PathName VARCHAR(1024)

SET @PathName = ''\\[Server]\Backups\[FileName]'' + CONVERT(VARCHAR,GETDATE(),112) + ''.bak''

BACKUP DATABASE [DATABASE_NAME]

TO DISK = @PathName

WITH

NOFORMAT,

NOINIT,

NAME = N''DBBackup'',

SKIP,

STATS = 10;

GO

SCRIPT TO BACK UP

I'm not sure what you need. Do you need code to do a CLR stored proc? I think the CLR is a bit of overkill for the kind of command...