Search results for query: *

ah thanks for your reply though raid1 not 10 :) The problem we might have with tempdb on the log drive is space we definately cant put it on its own drive, well we could in theory which would lose us 72gig of storage which we cant really trade off for the performance. I guess what I'm asking...

I've got this sproc we use for tracing orphaned users. I cant credit the author (was emailed it), though it has come in handy a fair few times CREATE PROC dbo.ShowOrphanUsers AS BEGIN CREATE TABLE #Results ( [Database Name] sysname COLLATE Latin1_General_CI_AS, [Orphaned User] sysname...

we're building 2 x new sql2000 servers and were wondering your thoughts on tempdb we dont have the luxury of being its own array, storage space is probably more important than total optimum performance at this time hence: we've got 8 x 72 gb drives and need to go c: (OS and programme files)...

hi I was wondering if anyone new about how to go about this I've received a request to received a file from a client each month (I believe a flat csv file), load it into our sql 2k, do some manipulation and then export it from DTS into "Unix Format" Now thats the bit I dont get, Unix isnt...

sorry, maybe for ths admin forum will leave it here for now... Matt Brighton, UK

anyone come across this or can help? Ok, I have server A with SQL2k, service pack4 The default collation on it is SQL_Latin1_General_CP1_CI_AS (SELECT SERVERPROPERTY ('Collation')) We need to move some databases to server B, which is a new install, and need to get the same server collation...

so you just want to copy tables from one database into another database, replacing the contents of the destination table? If so you should be able to do that easily with dts (what version of sql server are you using?) Matt Brighton, UK

right to clarify, so 'dn0r.dbu' is a full back up of your database dn0r. And you want to get this restored onto another machine, renamed as CISSite. Is it just the tables you want or the whole database? Matt Brighton, UK

How I'd done this before was to set up 3 x connection in dts 1 x sqlserver, and 1 to each csv file. on succcess of the 2 x exports merge them DECLARE @cmd varchar(1000) SET @cmd = 'copy \\share\file1 + \\share\file2 \\share\merged.csv' EXEC master..xp_cmdshell @cmd Matt Brighton, UK

does this work for you avg? SELECT dbo.ConsignVbaseF.STY_ROYL, dbo.ConsignVbaseF.IVD_STYLE, dbo.ConsignVbaseF.IVD_COLOR, dbo.ConsignVbaseF.CUST_TYP, dbo.ConsignShi.SHIPQTY, dbo.ConsignShi.SHIPDOL, dbo.ConsignRet.RETQTY, dbo.ConsignRet.RETDOL, dbo.ConsignNet.NETQTY...

it lets you connect with sa? does it let you do a stop/start of the service now and does this fix the SSPI context message (temporarily) Matt Brighton, UK

Further to the above, I've found out that asp renames the control when the page is rendered: TD style="WIDTH: 170px; HEIGHT: 38px"><table id="rblFullNameGiven" border="0" style="width:88px;"> <tr> <td><input id="rblFullNameGiven_0" type="radio" name="rblFullNameGiven" value="Yes" /><label...

I've just tried referencing it as "rblUKResident_0" and it works! Great tip. Thanks very much - I've been looking at this code for ages.. Matt Brighton, UK

Hi Thanks a lot for your reply. This is the actual code for the radio button list: <asp:radiobuttonlist id="rblUKResident" runat="server" RepeatDirection="Horizontal"> <asp:ListItem Value="Yes">Yes</asp:ListItem> <asp:ListItem Value="No">No</asp:ListItem>...

Hi I'm calling a javascript function from an asp.net page and need to test a value. I'm running this bit of code.. alert(document.getElementById("rblUKResident").Value); ..so that I can test the value of a .net radio button control. The control has the values "Yes" and "No", but whichever one...

try casting as decimal rather than float Matt Brighton, UK

Hi I'm calling a javascript function from an asp.net page. The function pops a confirmation box with some information: btnContinue.Attributes.Add("onClick", "score();") function score(){ //Calculate the score var points = 0; if(document.getElementById("rblFullNameGiven").Value...

doh you read my question fine and it works perfect! Friday lunchtime beer interference!! thanks for you help mate when I turn it into a money making forecast system I shall remember you [thumbsup2] Matt Brighton, UK

no mate unless I'm missing something, somethings afoot. Sorry, was wrong before it wasnt counting from the top. Here is the bottom section of the data, I'm using Birmingham as the test record and the function is giving me 2 instead of 9. cheers A,B,C,D,E,F div,date,ht,at,hg,ag...

cool its calculating now though I think its giving me the first 6 games of season not the previous 6. I tried ordering my list by date descending though it didnt calculate the proper figure thanks for your help on this Matt Brighton, UK