As a remember it, there is no valid syntax for ALTER TYPE. only drop and create.

i know that once a user type is in use, to change it, it cannot...

could you have a script out there that tries to be bulletproof, and drops and recreates the linked server before it does any work, in order to guarantee, for that...

to fix @@servername, modify this example to the "right' name

while the changes are in the right tables, it will eventually require a stop and start of the SQL services...

it is not possible to rename an instance name. only the server itself.

so on my local machine named [LowellDev], i have LowellDev\SQL2014, LowellDev\SQL2012 and LowellDev\SQL2008R2 instances.

if i rename my...

here's my guess on the requirements,i thought of two ways to do it, but i was not sure if you could have the same Id multiple times, all with the[IS_NULL]...

no input, just consumable data to help:

;WITH EstimatedData([QuarterDate],[sf_115],[sf_315],[sf_415],[sf_515],[sf_615],[sf_915],[sf_1015],[sf_1115],[sf_1215])

AS

(

SELECT CONVERT(DATETIME,'01-15 -2015'),'1',NULL,NULL,NULL,NULL,'1',NULL,'1',NULL UNION ALL

SELECT '12-15-2015',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1' UNION ALL

SELECT '09-30-2015',NULL,'1',NULL,'1',NULL,'1',NULL,'1',NULL

)

SELECT QuarterDate,

sf_115,

...

can you make an assumption based on the length? your example using charindex of the left parenthesis doesn't match your sample you posted.

;WITH MyCTE([PostalCode])

AS

(

SELECT 'Derbyshire S42 5BX' UNION ALL

SELECT 'NN4...

Help us help you!

if you can provide your sample data in a consumable format(meaning copy and paste to SSMS and build the data)

as well as the queries you are running...

you can also use the dateadd/datediff functions to strip to the hour, and still keep the value as a datetime instead of a varchar.

select DATEADD(hh, DATEDIFF(hh,0,getdate()), 0) --2015-09-04 10:00:00.000

i just built this example from my notes about adding align in xml.

this quick example seems to generate valid xml/html snippets, using inline styles.

i would do as suggested and use...

this is working for me:

Import-Module ActiveDirectory

Get-ADGroup -Filter {Name -like '*SQL*'} -Properties * | select -property SamAccountName,Name,Description,DistinguishedName,CanonicalName,GroupCategory,GroupScope,whenCreated

i just checked the wayback machine over at archive.org, which only had part two of the three part series,a nd pointed to SQL Saturday #234, since it was a presentation...

no, it's a classic question on the...

this looks right to me, and is sytactically correct, but you didn't mentione what the new value was.

i would use the ansi 92 syntax to make it clear to my...

assuming your text editor is SQL Server Management Studio, SSMS itself is not case sensitive; however,...