is "named pipes" enabled in sql configuration manager

Brilliant query guys , i am poor .. good learning

it is my miss , how about this.

set nocount on

CREATE TABLE #Test

(ID int NOT NULL IDENTITY(1,1) Primary key,

TranID int NOT NULL,

OriginCode varchar(5) NOT NULL,

DestinationCode varchar(5) NOT...

if you want the result like this

TranIDCode

201205AMDDOH

201206IXJRMI

then the query should be

select TranID , OriginCode + DestinationCode 'Code' from #Test

if this is not as per your output post a detailed explaination.

--begin tran

use master

declare @DB varchar(50)

select @DB = 'DB_Name'

CREATE TABLE #TMPFIXEDDRIVES (

DRIVE CHAR(1),

MBFREE INT)

INSERT INTO #TMPFIXEDDRIVES

EXEC xp_FIXEDDRIVES

CREATE TABLE #TMPSPACEUSED...

i go with suresh.

select convert(varchar,date_time,101), sum([Database Size in(MB)]) 'DB_Size inMB', [DB Name]

from #t1

group by convert(varchar,date_time,101),[DB Name]

order by convert(varchar,date_time,101)

try this.

SET NOCOUNT ON

DECLARE @hr int

DECLARE @fso int

DECLARE @drive char(1)

DECLARE @odrive int

DECLARE @TotalSize varchar(20) DECLARE @MB Numeric ; SET @MB = 1048576

CREATE TABLE #drives (drive char(1) PRIMARY KEY, FreeSpace int NULL,...

alternatively restart the agent using services.msc

check the sql error log and windows security log and post the errors if you found any after you access configuration manager.

select distinct @@servername, convert(varchar,a.backup_start_date,101) 'Date', a.database_name 'DB Name',

convert(decimal(7,2),round(sum(b.file_size/1024/1024/1024),3)) as 'Database Size in(GB)'

frommsdb..backupset a

inner join msdb..backupfile b on a.backup_set_id = b.backup_set_id

whereconvert(varchar,a.backup_start_date,101) = convert(varchar,getdate(),101)

and a.database_name in ( select name from...

Hello,

database_name is a nvarchar, how can you pass it to SUM?

alter the query.

what about management studio connection?

is Windows Management Instrumentation service running?

If you set Log Size in rows and rows per...

Thanks joy,

just a doubt will the service packs changing the build dates?

Scott,

it is giving '2011-09-24 00:00:00.000' still not correct, we have installed it on august/september 2007 after that no re install /rebuild.