Search results for query: *

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

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

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

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

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

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

Anyone else ever hit this problem? Thanks in Advance! I am using below code to hide/unhide toolbars. It works great, except, when "one" user (of 3) opens MS Access after exiting the application, the File Menu does not appear in MS Access unless openning in Safe Mode. I suspect corrupt DLL...

I have a need to review User permissions for a specific table to determine if I can enable UI buttons for Insert/Update/Delete... I have reviewed some T-SQL Call options online but they seem overly complex. My desire is to pass in a User Name and Table Name to a function and see if they have...

I have a button in an MS Access form that launches a SQL server SP Async. The users can the view the form for status update on a log table that is set to refresh per form Timer(). User can also open other MS Access forms to run other processes. Question: How can I properly close the ADO...

I am totally stumped! I have some T-SQL that is stored in a table that I loop through against a TEMP Table... And it appears I am getting a syntax error... Yet... When I run code manually it works A-Ok? Any Ideas are "greatly" appreciated! tia... T-SQL and Error Messages: UPDATE...

Our DBA Team has deemed that any/all SPs/Functions, that were previously public, now require a business justification for enabling permissions; even on Development Servers. Recently SP_Who2 was even deactivated. I am looking for a list of recommended system functions/procedures taht should...

SQL Server 2008: DB Displays 2011-03-31 I want 03/31/2011 as the default display. Is this some setting at a high-level within the DB? I know SQL Server 2000 displayed dates as I desire by default.... Thanks in advance, Steve Steve Medvid IT Consultant & Web Master

Maybe my brain thinks it is Monday... I can not devise a solution to following SQL puzzle... I have a primary data table and a lookup table. I am trying to validate that the primary data Year is contained for each and every category in the lookup table. In the example below, I am missing...

Help - I can not see the forrest through the trees today! Most likely a simple issue... Required to upgrade from SQL Server 2000 to 2008; and need to convert DTS to BULK INSERT since DBA Team does not support SSIS. alternative is to use semi-complex ETL Data-Stage (Unix). I have a BCP...

I have a group of individuals that share serveral PCs. These PCs presently use a common service account login (domain\svc_xxx). I plan to place a MS Access thin-client front-end on these shared PCs; and link to SQL Server 2008. Only issue is that DBA Team will not permit use of service...

I am 99.999125% sure, but I wanted to see if anyone had any firm docuemntation that MS Access 2007 can not open/use prior MS Access versions "without" first converting the file into the new file strucutre format. Basically, a user wants to use MS Access 2007; and open older MDB files without...

A new security rule is now in place where TRUNCATE TABLE must be replaced with DELETE TOP & a Loop. TRUNCATE TABLE appears to have some security risks per the DBA Team? Of course, we need to replace the 1 line statement with logic we develop for DELETE TOP & Loop. I am getting an error...

Just a little tid-bit related to an employer requiring employees to provide their Facebook Passwords as a requirement for employment. I have always followed the rule; becareful what you say/do/write online; since it may haunt you one day...

Is it possible to access an Oracle Data Source without using SQL Server Linked Servers? I am using SQL Server 2008... converting something from SQL Server 2000 where I used a Linked Server. I need to pull a small amount of data; and seems their is red tape that prevents me from using linked...