Recent content by smedvid

Certainly a strange one for me... I am getting an Undefined Error from Provider; when I attempt to execute an Oracle Stored 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...

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...