One more option is to use a third party tool that knows how to backup and compress that backup file. There are few tools that can do that...

Johann Montfort (11/5/2008)

---

Dear All

I have a table Pages and it has the following fields

PageId smallint

PageName nvarchar(250)

PageTitle nvarchar(250)

fk_buildId int

Now normally, how I do it, set the PageId as int and make...

Coalesce function recives values separted by column and returns...

latingntlman (11/3/2008)

---

I'm trying to return the last 100 or so records that were entered on a table. I guess by primary key or identity key, but I'm not sure I'm...

The fallowing is taken from the XML specification

[Definition: Each XML document contains one or more elements, the boundaries of which are either delimited by start-tags and end-tags, or, for empty...

I think that an XML should have at least one element. ...

Jerry Hung (10/29/2008)

---

I suppose it's just a choice by Microsoft, which I am okay with

If you want to enforce valid XML, either throw in a tag or add a schema...

michael (10/28/2008)

---

Hi, is it possible in T-SQL to check if a database is running in mirroring mode? Maybe there is some system SP that can tell me, but I haven't...

Leo (10/28/2008)

---

Hi Gail,

Well, I have aware of that but as you know when you set the maintenance plan I selected for ALL DATABASES so that I can do all in...

abhisek karki (10/27/2008)

---

I went to sql server log configuration and put the maximum error files upto 6. But my question is how to make smaller size of error log files,...

I’m sorry, but I don’t understand. Do you want...

Chris (10/27/2008)

---

hey adi..

when i ran this query with like even i got '000609876159' which should be in not like

select Col1

from YourTable

where YourCol not...

Chris (10/27/2008)

---

Jeff...thkz for the response could plz clarify this....

so how should i consider it .....

select isnumeric(order_number+'.do') from tbl1..

is this the syntax...

i dont understand this query

SELECT ISNUMERIC('3D2'+'.d0'), ISNUMERIC('3E2'+'.d0'), ISNUMERIC('1,000'+'.d0'), ISNUMERIC(CHAR(13)+'.d0'), ISNUMERIC(CHAR(9)+'.d0')...

psangeetha (10/27/2008)

---

Hi all, Application team just reported a problem they are getting that 'The log file for database 'mbt' is full. Back up the transaction log for the database to...

jennifer_l_hogan (10/24/2008)

---

Looking at the data they provided we have 6000 of the 7000 records added with the same date time. They returned the data as dd/mm/yyyy hh:mm:ss AM formatting....