Search results for query: *

thanks I'll give it a go.

I know its possible t discover the current users NT user name with VBA, but it it possible to also discover what NT User Groups they belong too? hope someone can help? jj

I'll check it.. thanks for te advice. there is obviously more to Google Maps than I thought. cheers.

hi yea thanks for that. I did think of it but i need youse a specific image as my map, tht has its own unique informatio on it. any more ideas most welcome.

Hi All, I'm not sure how best to ask this question.. or even iif I am in the best place to ask but here goes... I am trying to integrated into an asp.net web page a dynmically scrolling / zooming map. I'll try to explan what I mean... esentially a user will be able to list of interesting...

thanks guys i was afraid that was the answer. Unfortunatly i dont have access to the code there are 20 or so apps + 100s of DTS packages running on dozens of different servers.. + views and SPs from other DBs on other servers that could be calling into the DB im working on... its a proper mess...

Is there an easy way to find out when a stored proc or a view was last run in sql server 2000. I am trying to clean up a database but dont want to remove views, procedures and functions that other applications or dts packages may be calling upon for data. Ideally i was kinda hoping that there...

Thanks AdaHacker, I did discover the ndiswrapper and it seems to have done the trick although the internal card does not start up stright away on boot... so i still have some work to do. cheers, jj

I have just dumped windows in favour of Suse Linux 10.0. i decided to install it on the above laptop to see how it went. On the whole all seems well but I cant get it to run the in-built Wirelss capability. Does anyone have any ideas how I can get it to work / where I can get a driver from...

thank you. all sorted.

high i hope someone can help me.... within a DTS package i use some vb script to kick off a stored procedure. The problem is that sometimes the stored proc has to run for maybe 5 minutes. becuase of this i often get a timeout error on this task when running the DTS pacakge. is there a way to...

Is it ossible to store a multiple dimenaional array as a global variable. Basically have an Active X scipt task that uses VBscript to ceate an array with 2 dimensions. I want to store this Array so that it is avialable to other steps in the package. I want to do something like...

I want The first task to fully complete before the second one kicks off as they rely on the same data. I have tried both the on Success and On Completion to run the first Task then the second. But get the same error. I have also tried to execute via VBScript the second task.. from within the...

I have a problem in a DTS package that i cant narrow down. Basiccally my package has two main steps in it both are Active X script tasks that use ado to maniuplalte and transform some data. If i open the package right click each task and run just that task they both execute just fine. But as...

How do I; A: Run another DTS package from within an ActiveX Script task in a package. B: Run a Step within a DTS Package from an ActiveX script task within the same pacakge. Any help grately received... jj

Many thanks for this amazing what sleeping on an issue can do for you!!! I had already tried to do as you suggest but.. just realised that I was passing the Day and month in the wrong order hence I was gettting and error cant pass varchar as date! Cheers.

I am having trouble getting a stored prcedure to run with vbscript, that has 2 parameters the first is a string for a table name and the second is For the current date. Now the SP i know works ok as if I run the following in Query analyser it runs ok EXEC sp_UpdateTable 'Properties'...

...'Transform Data Task' which is associated to a DB ection and a Text File destination. Currenty it has a fixed SQL select statement which = 'Select * from Buildings' i want to set this select statement dynamically usuing my new Global Varaible ie. 'Select * from Table_Name'. I am thinking...

J Kusch. .you diamond !!! thanks. I think i am getting there now.

Hi i am very new to DTS but have a little experience of Stored Procs... so sorry if i am asking a silly question. Esentially i need to execute a stored procedure from within a DTS pacakge the Stored Procedure will return a Table_Name. Within my DTS Package I want to store this Table_Name as a...