Search results for query: *

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

Hi, We want to swap our production server which is currently running SQL 7 with another server which runs SQL 2000. To move the data we were going to backup the production server and then restore the database to our new SQL 2000 server. I gave it a try but received the following error msg...

Hi, I need to create a Cross tab based on a field 'Step Name'. This is ok and is currently ordered alphabetically by the Step Name field. But I need the cross tab to be ordered by the field 'Step' which is an integer. The field Step should not be display in the cross tab. Current Cross tab...

Thanks everyone for your help. I used Sunil's suggestion which works really well.

Hi, I want to concatenate a list of variables which are then written to another field and display them in neat columns. I've used the tab character below but if one field is too long it shifts all other fields to the right. set @Ticket_Details = @Ticket_Details + @Ticket_No + char (9) +...

It was a mistake, i never meant for the post to be added to this topic. I am storing multiple information in one field because the field with the combined data is the picked up by a process and distributed in an email. And no, I don't want to pass all the seperate fields to the email process.