Search results for query: *

Ok, how would I perform the lookup? Does it matter if it's cross-tab?

Hi all, I have a spreadsheet with two sheets, where the first sheet has a column (Product Profit) that relies on a cell in sheet 1-1 for a value as follows: =((I2-G2*'Sheet 1-1 - Table 1'!C2)) On Sheet 1-1, Column B and C are Product and Cost respectively, sample data: Product Cost Aciclov...

S'ok, I've got the resolution now.

Hi all, I've got a Sproc I'd like to alter so that it will accept input parameters, at the moment it ignores the dates I pass in (exec uspfraudreport '04-mar-2008', '05-mar-2008') and returns rows. Here's the code I've got so far, I've left out the irrelevant stuff at the end; USE...

Hi all, I've got a script that I want to alter, so it retrieves servername and edition faithfully from each SQL Server. This retrieves servernames, but only gives me the edition of the local server. Anyone know how to adjust? Thanks, Jaybee. -- Show sql servers in a domain -- --...

Hi all, I created a DB (called Iris) and need to give an NT local group ownership of the DB. Now, at the moment my own personal-named login is listed the login for DBO in the Users list, and all my permissions boxes are ticked. So, I executed a sp_changedbowner 'OurDomain\OurNTLocalGroup'...

Hi all, we've got a Replication problem, and I'm very new to replication. Here's the message: MSG TEXT: EventID: 0x4000429C (17052) - Error: 14152, Severity: 10, State: 1 Replication-Replication Distribution Subsystem: agent OURSERVER- On the advice of another board I've checked for blocking...

Hi all, How do I find the physical name of a server registered in EM? Thanks, Jaybee

I'll use blue!! SET NOCOUNT ON ; Select DISTINCT (tblAccounts.accountID) , tblAccounts.accountFirstName , tblAccounts.accountLastName, tblServicesTree.serviceName, tblcommunicationsSent.SentTo FROM dbo.fn_getValidSubscriptions() as vs JOIN tblAccounts on tblAccounts.accountID = vs.accountID...

Hi all, I've got some code here that runs for about a minute without the red entries, but for 100 minutes (and more) with them - any ideas, people? Thanks, Jaybee. SET NOCOUNT ON ; Select DISTINCT (tblAccounts.accountID) , tblAccounts.accountFirstName , tblAccounts.accountLastName...

How do I expand an index in MS word? I have an index that needs to be expanded to accomodate a lot of extra content, it'll triple the size of the document. After I paste the content, how do I: 1) Create new index entries; 2) Link each paragraph with the corresponding entry? 3) Ensure each...

I thought the Group By should be placed at the end and I was right!! Thanks for your help! Jaybee

The most important thing is that I get back a list of Servicenames for AccountID's. Each AccountID has an average of 27 ServiceNames. This will be a lot of redundant data, but it's for reporting purposes. I'm going to dump it out to an .xls and relay it as requested, what happens to it after...

Hi all, I need a final tweak I need for this code, what I need now is for firstnames, surnames, servicenames and some other generic data to be returned (again, this data is ALL contained within the function and tables - I checked!) and grouped by distinct accountID. I'm sure it'll involve a...

Background - this is dependency service for DTC (Distributed Transaction Co-ordinator) in SQL Server. When I attempt to start, Service Manager reports, "Error 1075: the dependency service does not exist or has been marked for deletion". I checked RPC, the dependency service, it's running...

Hi, I'd like to search an entire table for a term, rather like, SELECT * FROM [dbo].[tablename] where columname like '%blade%' Except the term could exist in ANY column of the table... Cheers, JB

Hi all, Can anyone tell me whether the syntax will work for renaming a logfile by appending the current date/time to the end, and what the "112" specifies? Thanks, JB /****************************************************************************/ declare @s varchar(8000) select @s = 'rename...

What info should a SQL Server Audit contain? -------------------------------------------------------------------------------- That is to say, from a management perspective? I've been asked to provide one, as I'm the first DBA there ever, but I'm not sure what depth of info they want. And...

No, the examples on that site are generic VB, as I said I need it database specific.

Hi all, I'm going to be getting involved with the creation and reconfiguration of DTS jobs, however I've noticed that they'll require VB Script, which I'm not familiar with. Without reading an 1000pp book on learning all uses of VB Script, are there any articles/resources that focus...