Viewing 15 posts - 1,666 through 1,680 (of 2,008 total)
SQLRNNR (11/11/2011)
And, it would...
November 11, 2011 at 11:19 am
Then the best you can do here is restore from that 5 day old backup and accept that 5 days of data has been lost due to the lack of...
November 11, 2011 at 11:14 am
cljolly (11/11/2011)
and the rest of it is blank.
Is there a way of displaying column names and data types from a...
November 11, 2011 at 11:03 am
cljolly (11/11/2011)
I wanted to pull a list of column names from my temp...
November 11, 2011 at 10:51 am
cljolly (11/11/2011)
I wanted to pull a list of column names from my temp...
November 11, 2011 at 10:49 am
mvijaykumar.mca (11/11/2011)
SELECT *
from Metatags WHERE
'|' + MetatagDesc + '|' LIKE '%|2|%'
If the field contains 2|23|4 , and am searching 23, its shud search only 23...
November 11, 2011 at 10:42 am
GilaMonster (11/11/2011)
assefam (11/11/2011)
Immediately after the back up, we created new log file and deleted the previous large log file keeping the mdf file as it is.
Sorry, what???? Detach, delete...
November 11, 2011 at 10:20 am
ok i found it under database but in different schema,how to change schema to dbo
Did you miss it last time?
If ALTER works, good else recreate it with new SCHEMA NAME.
November 11, 2011 at 10:18 am
Peter Brinkhaus (11/11/2011)
Agreed with Dev, but you can do it with a LIKE:
SELECT
*
FROM
(
SELECT '2|4|6' -- '3|24|4'
) SampleTable(ID)
WHERE
'|' + ID + '|' LIKE '%|2|%'
Can we...
November 11, 2011 at 10:10 am
ID
---
2|4|6
It's bad design. If you have control on database schema, re-design it.
November 11, 2011 at 10:01 am
I also want to know why this server is taking so much memory.
Why this server only is having this memory issue..
I am sorry but it won't be an easy...
November 11, 2011 at 9:52 am
daveriya (11/11/2011)
DEV,i tried it ,it showing over there,but it is under different schema,not dbo,thats y it is not showing,how to change schema to dbo
If ALTER works, good else recreate it...
November 11, 2011 at 9:43 am
daveriya (11/11/2011)
but i know i have selected correct database on...
November 11, 2011 at 9:40 am
assefam (11/11/2011)
Please Help: Is it possible to take buckup from Log file with out bring DB online. For your information, the real data is not available
Help us to help you.
What...
November 11, 2011 at 9:33 am
daveriya (11/11/2011)
i am connected to the right server,i am able to execute it,but its not showing in the list
Did you try what I suggested?
November 11, 2011 at 9:29 am
Viewing 15 posts - 1,666 through 1,680 (of 2,008 total)