a bit o translation help from Google Translate

---

I want to do something programmed to monitor the connections of an instance of SQL Server 2008 R2 Standard Edition. But I would...

was google down?

explanations you should google yourself; specific questiosn are ideal for the forum.

http://stackoverflow.com/questions/999394/whats-a-real-world-example-of-acid

i use ihostasp.net[/url]

for some shared hosting, which also includes a SQL2005 database. You can connect to it via SSMS with a name, port schema (ie.server04.ihostasp.net,14430)

you can use MySQL as well...

one of the more obscure RESTOre commands can help you:

this command will present a row of data showing you the size and maxsize of the database, which is almost...

those two dll's, java.util.zip.dll? and java.io.dll? need to be in the same folder as the script you are calling.

they probably are not,and i'm not sure how to insert them...

i was just looking through the SERVERPROPERTY functions, and cannot seem to find anything that shows the operating system.

it is buried in @@VERSION, though, so i'd expect a serverproperty...

in 2008 and above, there is a new function called connection property, and you can get a lot of that information from that.

that can give you both the client ip...

APA0876 (11/21/2012)

---

Hi,

We will be migrating from SQL Server 2005 to SQL Server 2008 R2 (different physical server), and I'm wondering if I have to migrate the databases via Restore or...

a SQL 2000 database, or one that was in SQL 2000 in a previous life?

in that version, you could hand-edit the sys tables and drop objects without cleaning up the...

Good point Erin; I guess it depends on whether you need to search for whole words or not;

my example was just to show one way to match multiple search terms...

if you want to do it yourself, which is another big job let me tell you, this data type equivalents link can help:

http://docs.oracle.com/cd/B19306_01/gateways.102/b14270/apa.htm

I've done it the other direction: take...

SQLCrazyCertified (11/21/2012)

---

I need to create a sql database which works the same way in oracle....

Basically, I have to mimic a database from Oracle to SQL server.

I have the DDL commands...

without more detaisl, all...

nicholasferri (11/21/2012)

---

Hi, I have a database where every table has an id column (CID) once this value changes all the tables must be checked and updated with the new CID...

timestamp is poorly named; the correct datatype name is rowversion.

it's storing a number in there , not an nvarchar or varchar.

you could change your variable to be int, bigint, or...