The FROM part of your select query is starting with table name "desktop_other_d"

I guess this is causing an error

from (

desktop_other_d o

...

Maybe after the FROM (...) a table name is required

select

distinct(d.MAC_address) as MAC,

d.hostname, c.username,

substring(d.login_name,0,charindex('\',d.login_name)) as dom,

d.pc_make, d.pc_model, d.ip_address,

substring(d.login_name,charindex('\',d.login_name)+1, len(d.login_name)) as login_id,

d.os_name, d.service_pack, d.ram,

convert(varchar(19),d.system_uptime, 100) as...

You can check the https://connect.microsoft.com/[/url] web site where you can submit your feedback about various Microsoft products

Here is a list where many submitted their comments : https://connect.microsoft.com/SQLServer/SearchResults.aspx?SearchQuery=denali

For database attachment you map all data and log files in one screen.

Each db has at least one primary data files, and might have secondary data files.

When you select the...

You know now the RTM products are released with SP1 🙂

Hi da-zero,

In the Setup support rules screen, were there any info useful?

Did you send the error report to Microsoft, perhaps using Connect you can give feedback about this error.

I installed...

My solution would be creating a stored procedure with table name as input parameter.

And within the SP, I would create a dynamic sql which will delete dublicate rows. You can...

Instead of using a Windows service, perhaps you can delegate this task to SQL Server Agent

SSIS can do the same job that your SP will do.

I believe SSIS will do...

For altering database mode from multi user mode to single user mode please refer to How to Alter a SQL Server Database as Single User Mode and as Multi User...

Thanks alot Subbu for your feedback.

I hope to hear good news from you

Hello Tim,

Sorry for misunderstanding

Here is an alternative script

CREATE FUNCTION udfSample

(

@STR nvarchar(400)

)

returns nvarchar(400)

begin

declare @i int, @j-2 int, @w nvarchar(400)

select @i = 1, @j-2...

Hello,

I once created a general changed data logging mechanism and created dynamic triggers for that solution.

You can check the article Change Data Capture Structure for MS SQL Server 2005

There you...

Hello you an try the following split script

create table Exceptions (ShortText nvarchar(100))

insert into Exceptions values (

'QualificationsLength'),(

'DepthMustBeNumeric'),(

'HeightMustBeNumeric'),(

'WidthMustBeNumeric'),(

'DepthNotValid'),(

'HeightNotValid'),(

'QuantityIsMandatory'),(

'QuantityNotValid'),(

'WidthNotValid'),(

'FactorNotValid'),(

'DimensionNotNumeric'),(

'DimensionNotValid'),(

'StartDateEarlierThanCurrentDate'),(

'CostCodeIsMandatory'),(

'QuantityMustBeNumeric'),(

'InvalidRatioNumeric'),(

'MissingRatio')

select * from Exceptions

cross apply dbo.CaseSensitiveSQLSplitFunction(Exceptions.ShortText)

You can find the sql source of case sensitive sql...

Hi Sridevi,

I hope you are looking for a solution like below

DECLARE @sql nvarchar(max)

DECLARE @server nvarchar(100) = N'hrad'

SET @sql = N'

Insert Into dbo.Server_Details_Table

select A.*

FROM

OPENROWSET (''SQLNCLI10'',...

CTE does not mean always a recursive query. But it is very powerful when recursive queries are required.

If your application require recursive process, then CTE is the first tool to...