Search results for query: *

Just found the following interesting, although its only semi useful because the formatting is lost when saved. Run something similar to the following in grid mode: select top 1 name from syscolumns for xml auto, elements you will then get the usual results window, which u can click on and...

is it possible to install this in an active-active cluster setup? and has anyone done it?..got notes info on it? general advice on 2k5 clustering?

Hi All Can someone confirm the following syntax/proceedure for me. I need to backup the entire contents of an oracle database, and then copy the files to a another directory in a linux environment. Assumptions: I need control file and all tablespaces backedup. 1. Check files I need...

case id of 1, has been oustanding for 15 days and therefore rate table B must apply a cost of 20. My question is what is the most effective and elegant way to return this rate without using: Create Table A ( CaseID int, mydate datetime ) go insert into a values (1,getdate()-15) go Create...

I have a asp page that uses the following connection stored in a file called connection.asp. e.g i use <!--#include file="connection.asp"--> at the top of my main page and use below stored in connection.asp <% set cnn = server.createobject("ADODB.Connection") cnn.open "PROVIDER=SQLOLEDB;DATA...

Create Table mytable ( AlphaNumericID varchar(10), renumber int ) insert into mytable values ('ZAA0062000',null) insert into mytable values ('AA00062000',null) insert into mytable values ('AA00062000',null) insert into mytable values ('AA00062000',null) insert into mytable values...

Hi all. Please can someone provide me with the sql which checks if a user has access to read the object createdate from the sysobjects table in all the databases on the server. I presume they just need to have read access or greater on the database.

ok we have basically created a function which uses the existing undocumented xp_fileexist to check for a file but wrapped it in an existing function. e.g dbo.fnFileExists (filepath) which returns a bit The first time this runs it takes 4-6 seconds, but the second time it is almost...

Hi All Has anyone got a script to export all server jobs to individual files? so that they can be recreated later

Hi All Ive been trying to get a list of the jobs and their details on various servers etc, and have trawled the net for bits and pieces to compile the below job script. Has anyone got a better one? or perhaps tips to improve this one? SELECT 'Job Type' = CASE server_id WHEN 0 THEN...

dt Requests 19/09/2004 10:00:04 10 20/09/2004 07:00:06 161548 21/09/2004 00:00:07 164190 21/09/2004 12:00:07 100000 21/09/2004 12:20:07 100000 19/09/2004 01:00:06 155289 Can someone help me pivot the date in this wait table. I need it in the following format: Sum requests as the...

I am a complete beginner so please bear with me and any offers of advice and/or tips would be much appreciated! I have a list which has been inputted by the user. The numbers are any positive and negative integers and zero. I want to include a function where they can turn all the numbers in the...

Program: Outlook 2003 Hi Instead of using the import/export wizard, has anyone got a macro (that I can then assign to a button) to export emails to a windows csv, and also import others from another csv?

ok I got a table ID,NAME 1,JO 2,BOB 3,JIM I select design a form, insert chart. select the table, select both fields. pick bar chart, i put 'name' in the axis box, and count of name in the data box. When I preview I see the correct graph...but when i finish and get the final graph... it...

How do you go about doing this:- if i got several emails some with and somewithout 'urgent' somewhere in the message subject...how would i got about selecting these and addint a priority marker. if .subject like %urgent% then priority ...

If i get a variety of emails in I want to change it to a set format. In particular I want the emails to be rich text, which I got by using .BodyFormat = olFormatRichText However how do you set font and size? Can anyone give me a hand with this>? cheers (outlook 2002 btw)

<?php require_once('Connections/jxpDREAM.php'); ?> <?php mysql_select_db($database_jxpDREAM, $jxpDREAM); $query_data_grab = "SELECT `data` FROM datadump"; $data_grab = mysql_query($query_data_grab, $jxpDREAM) or die(mysql_error()); while ($row = mysql_fetch_array($data_grab, MYSQL_BOTH)) {...

Ok basically I need to copy the details of a main client to a new sub client related to that client. so updating the address details of one Sub client (say with a code S1) with that of a Main client (M1) UPDATE User_file SET address1 =(SELECT Address1 FROM User_file WHERE (Code =...

Basically if l1 is greater than the str_len then i need to take a part of the string and set str_len to 0. (Repeating this for several other fields) If it is less than str_len I want to take all the string and set str_len to str_len - l1. At the moment this is multiple IF statements. How do I...

The remote site has had a complete loss of data. The master database sql 2000 db is still intact. I need to get this going again,soon. Will diabling Microsoft replication on the main db, and then scripting it to a new db work? Or will there be loads of stuff to configure/remove/change? How...