Search results for query: *

Skip I cannot do the detail, because of security in my workplace, but the essentially I replaced WHERE e.[field a] LIKE 'Jspm*' with: WHERE LEFT(E.[field a],4) = 'JSPM' thanks. BlueCJH

SORTED. There was an offending piece of SQL: use of the LIKE expression. I'm not sure what it was offending, because the query ran fine in access, but there your are... BlueCJH

Hi Skip, No there is no parameter. Chris. BlueCJH

I have a fairly complex union query stored in access (INSERT INTO table etc...) This query runs fine inside Access inserting plenty of rows into my table. However, I want to be able to run the stored query from Excel. Using ADODB and a command object and after much trial and error the code runs...

I am using Office 2007. I have a saved query in Access which runs fine as a stand alone query. However, when I attempt to open the recordset in my Excel VBA procedure I receive an "Invalid SQL ... " error. I have managed to create very simple union queries and get the code to run as a test...

I managed to enter values in response to a prompt in Scheduler. However, the value 'All' returned nothing, where the report would normally deliver all results? BlueCJH

Driex, I will test this out. Many thanks BlueCJH

I have a read only version of impromptu, so I can't build reports. I am trying to help someone with the administrator version. (Trying to solve a problem with one arm tied behind my back.) We have a report with a picklist prompt (which includes an 'All' option.) My administrator says "this...

sql server 2005 SSIS Is there a way to script all (or some) database objects with SSIS? This would provide a way to automate the process, rather than using the database task ('generate scripts') thanks for any help. BlueCJH

Dave, I follow.... What I would like is really to change either the server language or the BIDS language setting (which ever is the correct route) so that all developers have the default setting to either User("language") or en-GB. I'm trying to get the default changed. thanks chris. BlueCJH

Okay.. i've been putting en <Language>en-GB</Language> i suppose that's really the same thing, but thanks for this BlueCJH

Hi Dave, where do i set the reports language property... i can't find this? it's not a 2008 property? i'm using 2005. thanks BlueCJH

RS 2005. Currently our report dates format by default in US format. i.e MM/DD/YY To obtain UK formats we have to apply formatting formulae in text boxes etc..., which is a bit cumbersome. I am aware that I can set the XML in the body of the report to English. i.e...

Iteresting, profiler identified NT AUTHORITY\ANONYMOUS LOGON as the culprit... so now i've either got to give this account rights or get windows authentication working. So i'm a step further, which is good news... i'm off to have a look at IIS. many thanks BlueCJH

SQL 2005. rsErrorExecutingCommand The stored procedure recides on a separate server from the Reporting Services server. "EXECUTE permission denied on object usp...." (a stored proc) I am Administrator on both. According to the data source, contact is made to the database with windows...

SQL SERVER 2005. (both remote and local) a linked server (OLEDB provider for sql server) exists which uses users current security context. I am sysadm on both boxes. A new database created on the remote server cannot be seen. I get the error "The OLE DB provider "SQLNCLI" for linked server...

turns out they have admin rights on the box. this supercedes sql permissions.. ahh BlueCJH

just one, i created MyRole which explictly denies access to a table e.g. DENY INSERT ON dbo.[t_PermissionsTest] to [MyRole] one user who is also a member of MyRole cannot insert into this table (as expected), but for the offending user they can...? thanks BlueCJH

sql server 2005, I have a user that seems to have rights shut down, yet still they seem to be able to delete tables in a database. I can only think there is some kind of aliasing going on, how do i get a list of any aliases to the dbo account? thanks for any help? BlueCJH

sql server 2005 GRANT REFERENCES ON TYPE::dbo.myExampletype to aRole but can i grant to all udt's on the database in one command? thanks BlueCJH