Search results for query: *

Hey guys, I was hoping that you guys could point me in the right direction with my problem. I have a table with multiple other variables which I believe to have an impact on variable x. I need to know which of these other variables have the strongest impact on variable x. X = 0 or 1. I...

Hey guys, I'm having trouble searching for this particular topic.. basically I'm interested in limitting or adjusting resource consumption such as cpu or memory for particular users.. Does anyone know where this is done in sql 2005? Cheers

Hi there, So I know it's possible to access a remote SQL Server without setting up an ODBC connection, but I'm not sure how to configure the server to allow that to happen? Basically I would like to login to the server remotely with SSMS without having to setup an ODBC SQL Server connections...

Hey, I was wondering if there's a way to enable/disable the compact and repair option via vba? this doesn't seem to be working.. CommandBars("Menu Bar").Controls("Tools").Controls("Options").Controls("General").Controls("Compact on Close").Enabled Any help is much appreciated. TIA

Hi.. I'm fairly new to php.. I was hoping to add a popup window to one of my scripts.. so that when the php loads with will also open a secondary fixed sized window.. I understand I have to use javascript for this? Can anyone help me with some syntax? TIA

Hi, I'm trying to make a Province and City form with select lists. For example, based on the Province selection.. will change the available values in City list. I have the lists boxes pulling from SQL backend .. I just dont know how to apply the criteria.. I understand I have to use an...

Hi, I'm trying to make a Province and City form with select lists. For example, based on the Province selection.. will change the available values in City list. I have the lists boxes pulling from SQL backend .. I just dont know how to apply the criteria.. I understand I have to use an...

Hi, I'm really trying to solve why my server is performing slowly after I run this SSIS package. I'm wondering if this is the cause, amongst other tasks, basically I have a large SQL task that produces a number of temp tables in order to produce one large table with a join insert. I then drop...

Hi guys.. we have id numbers.. example: 93785542352 the third digit resembles region.. I need to change the 1's to 5's and 2's to 6's all in the third digit.. I know access sql has mid() function.. how do I do this efficiently on a SQL server? TIA

Hi, I have a SSIS package which generally runs for about 1.5 hours before it is complete... Just recently there is one Data Flow Task within the package that runs terribly slow... I don't know why, because it's a very simple SQL that transfers data over from a source server.. I had the...

Hi, I'm reading the help files included in the SQL Server which have proven to confuse me more than actually help... :/ So I was hoping that you guys could help me with something that should be very basic.. Package scoped variables and using them in Execute SQL Tasks. Here's what I have under...

Hi everyone.. Just looking for a little help with regards to retrieving a character string. I'm trying to get the 3 characters after a "." within a string.. just like a MID() function in VBA.. just not sure how to look for the period and then pick up the 3 chars. any help or advice is...

Hey guys, So is there a way to allow for Access functions to come through to excel when importing a data source via ODBC.. I have some calculations on a couple of cells that require access to do some computing.. Any help is appreciated.. Thanks.

Hey guys.. I can't get this to work http://support.microsoft.com/?kbid=210598 it keeps giving me a false.. when I debug.. it crashes here: Set C = DB.Containers(ObjectNum) Find_Object = C.Documents(ObjectName$).Name "Item not found in this collection" It's something to do with...

Hey guys, I'm creating a dynamic update manager.. I would like to check if an object exists on a remote file.. I found the following site which explains how to check if an object exists on a local file.. http://support.microsoft.com/?kbid=210598 any thoughts or ideas on how to make this...

Hey guys, I'm using the following code to upload files to a server and it doesn't seem to be working correctly. You should know that register_globals is deactivated... I'm not sure, but I think that might be preventing this script from working... I was hoping there was something I can do with...

Hey, I want to use subforms for all of the major forms in the project.. ie input, read only, report options.. I want to use the main form as a "container" for all of the other forms.. I'm considering using this method throughout the company (15 or so databases) but I wan't to know the...

Hey guys, what exactly is wrong with this? print "<meta http-equiv=\"refresh\" content=\"2; URL=javascript:window.open('ok.htm','framer')\">";

Hi guys, So I came accross this piece of code and it seems to work fine when I want to import or just view records via access.. Does anyone know if it's possible to actually have full read and write control of the tables? So that I can have forms actually running off of them? Public...

Hey guys, trying to get " character to pass through a string.. does anyone know how to send special characters through string varaibles? TIA