Recent content by Phil99

Hi, I'm looking for a script to find all tables, columns in a tablespace which use lobs and details of the lob settings, such as In Row etc. Thanks Phil

Hi From my site i'm displaying a html report to the user. Is it possible to save the html report as for example a word document or a pdf file? At the moment i can only save the page as a htm file using <a href="javascript:doSaveAs()">save this page</a> which isn't ideal. Many Thanks Phil

Hi I'm creating a stylesheet at the moment. I need to set the font size which seems ok using: font-size: 7pt; But i've also seen the following statement used: font-size: 1em; Please can you confirm when em should be used and what affect it has on the font size. Many Thanks Phil

Hi I finally got this connection to work. The issue was with the 4 part name. I was initially attempting to use select * from FERRET.aesoc.configdata.configdatatest (Server: aesoc) but I got the connection to work with select * from FERRET.configdata.informix.configdatatest (Linked...

Hi I'm trying to access a database, where the database name has a space in the name: ICore DB This is causing an issue is Query Analyser when I attempt to run a query such as select count(*) from ICore DB.dbo.tblCountry Is there a way to alias the Database name or can the syntax above be...

Thanks i've now set up the connection now and from the link server in Enterprise manager i can see the tables and views. Using the following in a query it returns an error as below: Linked Server = Ferret DB Name= aesoc Schema = Configdata tablename = Configdatatest Query select count(*) from...

Thanks for you reply i found this very useful. I now have a connection via DTS but also need to create a link so i can update the Informix server via SQL Server. So far i haven't been able to get the connection to work. I'm not sure in your example what you have used for the parameter values...

Hi, I'm attempting to configure a ODBC connection for connect to an Informix database, but i'm getting a driver error. Do I need to install the Informix client software on the sql server to make this work? Or is there an easier way to do this with SQL Server 2000? Thanks Phil

Hi I need to run the following script via an application whose service has to start via the Local System account. var url = "http://" + host + ":" + port + "/" + action + "/"; var query = "client_id=" + client_id + "&text=" + escape(text) + "&destaddr="+ destaddr + "&password=" + password...

Sorry slip of the finger....

Hi I'm able to successfully run the following script when logged on to a server with an admin account. var host = ""; var port = ""; var action = ""; var client_id = ""; var text = ""; var destaddr = ""; var password = ""; var url = "http://" + host + ":" + port + "/" + action + "/"; var...

Hi, Is it possible to run a database backup and exclude a particular table from the backup file. We have a large database but most of the space is taken up by one table which we would like to exlude from the backup. Thanks Phil

First change the owner to sa, you can then update the owner to the correct owner name. eg sp_changedbowner 'sa' sp_changedbowner 'New Owner' Hope this helps. Cheers Phil

The issue about was cause by a couple of old subscriptions which weren't working. After I removed them everything was fine. After you have restored the database you just need to reset the db owner. This can be done by first change the dbowner to sa and then changing it to the orignal owner...

Hi, I am currently setting up a new server and I want to copy our existing CE8 database onto our new server. This seems fine I have done a backup and then restored the CE8 database to the new server, this is based on SQL 2000. But I need to know how to update all of the references to the...