Search results for query: *

...Procedure in vb script and run from DOS via cscript. This code works for other SPs I execute via VBS. I confirmed I can run Proc in Oracle SQL*Developer, TOAD and SQL*Plus. -- > EXEC MYSCHEMA.MY_SP_NAME_HERE Any hints are appreciated. tia, Steve Set conn =...

Perhaps write some VBA Code that can create a cursor (record set) of tables from tabledef object, then look through that object and perform command(s) as needed. VBA Coding experience required... Just one thought... htwh.. Steve Medvid IT Consultant & Web Master

Guess it must be Friday... Data Issue where leading zero was truncated off Field_X... Solution was to use Right('0000000'+Field_y,10) everywhere... Worked like a charm... TGIF!!!!!!!!!!!!!! Steve Medvid IT Consultant & Web Master

Interesting one I have never seen before - a real puzzler for me... I am attempting to select a distinct value for Field_X; then the max value for field_Y. The select field_x, max(field_y) with group by field_x is returning duplicate rows. field_y is a varchar(20), and field_y is an INT...

In the past, when new versions of MS Access were released, I always tested everything 1st. I would test with a PC with just the new version, and no older versions held over. With few exceptions, I rarely had any issues. So... my suggesting is to identify if the issue is related to a specific...

Great when you solve your own problems... Done it before myself.... post a question, and then lightbulb goes on... :-) Steve Medvid IT Consultant & Web Master

Well - Kind of... Our IT group deploys an Image of software... I have SQL Server 2008 with only Configurations Tools listed as menu item and SQL Server 2008 SR2 - with what appears to be a full install. My 2008 SQL Server Instance I connect to appears to be at correct and latest patch...

First, I know using XP_FileExists is not the best solution, and that CLR is advised. This is a short-term solution, and CLR will not be possible at present. I have entitled a service account login to run xp_fileexists and xp_cmdshell via a DB Role. The xp_cmdshell works great, but...

I have searched for some some clues to this issue. When openning SSMS, I click on an object to say enter design mode for a table... PC will hang. I also had this when I tried to view properties of a Job. My SQL Server 2008 SR2 appears to have all latest patches. My PC has been re-imaged by...

Sometimes the dust clears from the brain after a walk away from the PC, and a fresh look at the issue is taken. I knew that SQL Server Defaults to Upper case, and then recalled you can override within SQL SELECT Statement by listing Collate information, and I have done it before many many...

Hi All, I need to strip out a version number from a string. The version number will always be a lower case "v" with a leading space. Appears that my SQL Server environment is ignoring lower case. I am searching for a setting, bout can't find it. I hope that is the issue; or I will need to...

yelworcm, Thanks so much for pointing at the obvious. Sometimes you can't see the forest through the trees. The real issue was that the vendor made changes to the import file and deployed it to production without notifying us; or even allowing us to review/test. I have since taken steps to...

Really scratching me head on this one, hope someone can help. I do not have SSIS, DTS or other ETL Tool (i.e. Data Stage) at present, and need to load large text file (174 Cols) into SQL Server on a Daily Basis. Used Bulk Insert TSQL (automated via a Job), and worked great, until vendor added...

Another very important point... Is this the job and career path you really expected to have after completing college? If so, then great... welcome to IT and you will learn on-the-job stuff which will allow you to get comfortable over next few months. If this is not the real job you desire...

Has anyone ever performed a benchmark against a MS Access 2007 table that has ~50,000 rows; 15 fields, most of which are Text(255)... versus re-sizing the fields to actual size (or slightly larger)? I did a quick test writing a query with group by; and saw only a ~1 second difference for...

Just some quick thoughts... You can also check which PC Name is connected/accessing DB. Be sure to develop a flush-the-queue rountine in case you have users/PCs connected for extended periods and they do not exit properly and appear to be connected still. htwh, Steve Medvid IT Consultant &...

Since it is just an EXE you run, perhaps it can be installed on a server location. I have not used it in many years... but I do not think it modifies the local PC registry... but please confirm that guess... Plus better to have a central location of BLAT instead of on local PCs in case an...

Just a thought... I have used BLAT a DOS Based SMTP Email tool, to send short/simple emails without use of CDO or Outlook. htwh, Steve Medvid IT Consultant & Web Master

Just a thought... Are you sure that in addition to an upgrade to Win-7, did anyother network related updates occur? I know that some companies have taken a path to encrypt local drives, monitor local drives for file activity, and other monitors/firewalls that impede processing time. hthw...

First, you need some VBA programming experience; knowledge of TableDefs and usage of AutoExec Macro that fires on Application open. There are sooooo many examples, of refreshing table links, I could not do it justice. It is a simple process with less than dozen lines of code for the basic...