Viewing 15 posts - 166 through 180 (of 186 total)
One more question...
Database_Name|| File_Type|| File_Sizein_MB|| Space_used_in_MB||Space_left_in_MB
MyNewDB2||datafile||54423||29037||25385
MyNewDB2||LogFile||21819||81||21737
What does Space_left_in_MB mean? IS it the current db size 54g will not grow unless the space 25G is filled up?
Is it the...
August 10, 2011 at 2:41 pm
We keep daily back ups of the database but unfortunately we don not keep the msdb history.
August 10, 2011 at 10:14 am
Thank you for the reply.
My database is about 50 G for right now, if I presize it to say 60G for next 12 months. I assume end of the 12...
August 10, 2011 at 9:51 am
Yes, both are configured for remoted access. If it was not configured right then the job should fail all the time but it's failing with the distributed transaction error once...
August 3, 2011 at 2:14 pm
SELECT c.ACCOUNT as 'identifier', 'RCV' as 'Type',
( SELECT '' AS 'Code',
a.comment AS 'Text'
FROM #TEMPTBLCNA a
WHERE a.ptno = c.ptno
FOR XML PATH(''), TYPE) AS 'Comment'
FROM...
July 29, 2011 at 12:24 pm
I got it working this far....but still need help for one more step
CREATE TABLE #TEMPTBLCNA
(
RECORD_NUM INT NULL,
C1 VARCHAR(1) NULL,
COMMENT_CODE VARCHAR(100) NULL,
STATUS_CODE INT...
July 29, 2011 at 11:07 am
Thank you ALL for the tips....I went with the following solution ..worked like a charm!
SELECT hospital,account,
max(CASE when batchid = 'G001OSXG' then 219 ELSE NULL END) AS V1,
max(CASE when...
July 20, 2011 at 2:02 pm
I am not an expert, but sometimes I have used this to find out what database users are conencting to...
In SQl server management studio
running sp_who2 active
and...
June 3, 2011 at 10:36 am
Can you please review my query ?
This is what I am trying to do.
I have a TABLE1 and TABLE3 on svr1 and TABLE2 on svr2. Now I am trying...
June 3, 2011 at 10:32 am
CREATE PROCEDURE proc_ClientDetails_select(@ClientId int)
AS
SELECT ClientID ,StatusStartDate ,StatsuEndDate,[Status]
FROM [Status]
WHERE ClientID = @ClientId
GO
Now, to execute this stored procdure you would pass the parameter as follows
exec proc_ClientDetails_select 100
Hope this helps!
**Your...
May 27, 2011 at 7:36 am
@ninja : My bad ..overlooked where the '%' was ..yes will give it a try. Thanks
@mydoggiejessie : Definitely will give it a shot.
May 26, 2011 at 12:35 pm
@ninja : My bad ..overlooked where the '%' was ..yes will give it a try. Thanks
@mydoggiejessie : Definitely will give it a shot.
May 26, 2011 at 12:34 pm
I could have done hat but the records in the comments a table are as follows
220- We receieved the data
219 - Patient match found
218 - This is only going...
May 26, 2011 at 11:28 am
Viewing 15 posts - 166 through 180 (of 186 total)