First, make sure that a valid Login is the owner of the database. For instance, in my environment, I belong to a DBA Active Directory group which is a...

To keep your CLR Assembly scalable, you might consider using a Enum of acceptable file types. Then your procedure could validate that the filetype provided is in the acceptable...

The multi server query is actually executed as separate batches on each server, so any statements being run are still batch scoped which means they will complete inside their respective...

This statement is...

You can try to add the -g384 or -g512 startup parameter to see if it is a memory leak causing the problems. I have one CLR object that interacts...

Thomas LaRock (8/18/2008)

---

hi denby,

we try to limit the use of CLR here, simply because it does not seem to be necessary. however, one caveat that i have seen has to...

Did you change the safety level of the Assembly on the Deploy tab to External_Access? You can check this from SQL Management Studio by expanding the database, Programability, Assemblies,...

It will be in the projects solution folder in the bin\Debug or bin\Release folder as appropriate for the type of build you did. You have to then copy the...

The Login and user that you create from the certificate have nothing to do with the permissions that the CLR runs under. They exist solely to allow you to...

It is really simple to do in Visual Studio, and the steps in 2008 are the same as 2005. When you create the database project, it will ask for...

The problem is that you have @phone declared as a char(20), which means it is going to have trailing spaces for a phone number. Either explicitly cast/convert it to...

Hmm, I have to go play with your code now Jeff. I am not surprised that you once again replaced a loop with a Tally/Numbers table. I...

That is correct, and you can easily modify the code to accept another input and return a scalar value back for a specific part only.

You can do this with TSQL very easily with a split function. You can find one on the following link:

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=StringArrayInput&referringTitle=Home

declare @namestring varchar(1000), @thirdvalue varchar(1000)

set @namestring = 'Smith, John'

SELECT @thirdvalue...

For this particular question, here is the example code.

DECLARE @InstanceName varchar(100),

@InstanceLocation varchar(100),

@InstancePath varchar(100)

SELECT @InstanceName = convert(varchar, ServerProperty('InstanceName'))

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

@key='Software\Microsoft\Microsoft SQL Server\Instance Names\SQL',

@value_name=@InstanceName,

...