run sp_configure 'show advanced options', 1

reconfigure with override

Then sp_configure will display the settings, what is set for the value of 'remote access' is it set to 1

Its a bit difficult from your example, looks like you have an un-normalised database. If you continue in this fashion you will be forced to duplicate information all over the...

You shouldn't necessarily need 2 tables why not one table with something like

Field Type

Item - ...

I am assuming the email field is a varchar, adding a primary key to such a field might not be the best thing. I hope you have a test system...

Another gotcha you need to add the hotfix for filestream regardless of whether you select to use it (Windows 2003) http://support.microsoft.com/kb/937444/.

Also on a new install of a 2008 cluster no...

If this is just a table for Japanese data, then just alter the collation of the field.

ALTER TABLE [Japanese] ALTER COLUMN b NVARCHAR(500) COLLATE Japanese_Unicode_CS_AS NULL

If the field is to...

Just done a quick test and I think you may be having the problem because of the collation of the database you are writing to. I set up a database...

Have a look a the fill factor on the table it may be better if this was adjusted to prevent page splits and fragmentation.

It's not a permissions issue is it? in that the table cannot be seen because the user hasn't got permission to view it?

Very timely I was looking for something very similar to this, thanks.

I would input to a temporary table that allows nulls, then pass data into a new table handling the Nulls with a query using say COALESCE.

Ask what the main issues you will have to deal with in the role, if they tell you its something like deadlocks, you'll get a fairly good impression that you...

You can do a quick fix - though not normally recommended to amend system tables, but the following sets all agent jobs to log to table.

UPDATE [msdb].[dbo].[sysjobsteps]

SET flags = 15

You could use Osql wrapped in a stored procedure to run a script stored on a file system against all the instances held in a table somewhere:-

SET quoted_identifier off

SET nocount...

I use a function and just add in the ASCII character of the item I wish to replace:-

/*-- =============================================

-- Author:Carolyn Richardson

-- Create date: 16th February 2009

-- Description:Clears selected characters from...