Take a look here for at a forum that asked the same

http://dbforums.com/t770846.html

and take a look here

http://www2.bus.orst.edu/faculty/brownc/lectures/db_tutor/database_languages.htm

and here

http://scis.acast.nova.edu/~jclevin/COURSE/DMS/database.html

Edited by - antares686 on 06/27/2003 05:07:21 AM

I suggest speaking with the vendors as to the loseless size they can achive. Also, if this is for compressing SQL Server backups then look at SQLZip (Lempel-Ziv compression) or...

Replication is enabled for specific databases and should not effect how the others operate. However, depending on push or pull an where the distributor is they can chnge the server...

You can use a temp table to retive the results into and use there (but can only return one resultset). Or OUTPUT variables if a fixed number of items return....

We test about once a month normally. Change the tapes out of cycle once every two years unless otherwise flaky. Have two backup sets (one local, one tape). And I...

Something like this developed into a function might do the trick.

Ex.

DECLARE @var varchar(40)

declare @tempVar varchar(40)



set @var = '48501239955.486'



set @tempVar = rtrim(ltrim(reverse(@var)))



select @var = reverse(left(@tempVar,charindex('.',@tempVar))), @tempVar =...

quote:

---

Hi Markus,

quote:

---

I know the forum has a little bit of this on the XML...

Take a look here at this KB article http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 it talks about moving databases. Moving logs are done the same way except you list the original position of the data...

Date time as expressed by BOL

quote:

---

Values with the datetime data type are stored internally by Microsoft SQL Server as two 4-byte integers....

Again check the Windows Event Viewer logs.

For example I get the same message you see when the tape needs to be cleaned. Checking in the Event VIewer logs give me...

Unless you createed and install script and script out to a restore there is no way. Is this going to be redistributable? If so then look into WISE, MS Installer,...

Because I am stepping in here now I would point it this way.

1) If the number of items will always be fixed or rarely add to then use a CONSTRAINT...

Do you have the original DB or a backup somewhere? If so try installing to another server and do an import using the IMPORT/EXPORT wizard. Sounds like something in your...