Thanks for the link to further details on how to set this up. As it turns out, security on the objects in the Access database were not being enforced. I was able to map to 'Admin' with a NULL password without having to point to the system.mdw file in the registry.CSDunn
2004-02-13
From BOL:"A local temporary table created in a stored procedure is dropped automatically when the stored procedure completes. The table can be referenced by any nested stored procedures executed by the stored procedure that created the table. The table cannot be referenced by the process which called the stored procedure that created the table."As for […]
2004-01-15
1 reads
We have a system that tracks required employee trainings. I need to send emails to the employee's manager once a month that details what trainings each employee needs to do and by when. I have a nice report in Access (raw data are in Oracle) Is there a nice way to generate this email in access. I see the sendobject command, […]
2004-01-07
2 reads
It's been a long while, but I seem to remember performance decreasing when I upgraded from NT 4 to Windows 2000. Performance increased when I upgraded from Windows 2000 to Windows 2003. The databases I had at the time were fairly small (under 5 GB) and not very heavilly utlizied. Your experience may be different.
2003-12-17
You can create SQL string and than execute it in a stored procedure, like this: Create PROCEDURE varcolSearch @colname varchar(30) = 'DefaultCol' AS declare @U nvarchar(1000) set @U='Select T1.col1, t1.col2, t1.' + @colname + 'From table as t1 Where X ' EXECUTE sp_executesql @U GO
2003-12-02
There are so many problems with SP3a. MS is going to talk more about SP3. I would suggest wait for some more time. If you decided to install here is a link you can find very good info about the clustering and service packs http://www.sql-server-performance.com/clustering_resources.asp
2003-06-26
You can explicitly grant statement permission rights within a database. For instance: GRANT CREATE TABLE TO HostedCustomer However, prohibiting acccess to system tables and system stored procedures is a bit more problematic. By default, the public role has access to many of these, especially in the master database. Since the guest user must be present […]
2003-06-17
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers