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...

well you can filter it from...

Your application needs to use the techniques for Multiple Active Result Sets (MARS);

just dumping the resutls into a DataReader or DataTable will only get you one of potentially multiple...

the # depends on the SQL server version, and in some cases, the Service Pack version as well.

easiest way is to simply look in SSMS Object Explorer>>Expad Server>>System Databases>>master>>Views>>System Views

Or...

SQL...