I got rid of the apostrophes, but I'm a little confused at the connection name, Where do I find the connection name? I have a "Microsoft OLE DB Provider for SQL" and a "Text File (Destination)".What am I not looking at properly? I feel like such a goose.Thanks heaps in advance.
2004-07-12
Hello,I believe this is possible but I need to export all (SELECT * ) data from one TABLE and schedule an email to send every morning. Is this possible? I would like to create a stored procedure likeCREATE PROC dbo.CustomersASSELECT *FROM tblCustomersI would like this sproc Customers run a DTS every morning and email it to […]
2004-07-08
2 reads
Not a solution but you can test for parallelism by querying as:Select * from reasonablylargetable option (maxdop X) where X is the number of processors you would like used. If you specify a query which is likely to work the processors harder that would be better.Just watch the processor utilisation as you vary X.DB
2004-07-08
Thanks for the advice. I have split the function into 4 each returning a smaller SQL string which is concatenated before being run by EXEC.
2004-07-08
1 reads
Just thought of something. Why don't you set up views for each table, use the views to convert your datetime data into char data and use the ExportData method on the view instead of the table.Again, a lot of work depending on the amount of tables in your database.Anyone got any better options?
2004-07-08
Check the following: 1. Make sure the account that the sql server agent is running under has sufficient priveleges to perform the dts task. 2. Make sure any paths to files are through a mapped drive rather than the full unc path. 3. Run dcomcnfg.exe and add the SQL Service account to Default Access Permissions […]
2004-07-07
That's very possible. What kind of indexes do you have on the table?
2004-06-28
1 reads
From Books Online:PermissionsExecute permissions default to the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the object owner.
2004-06-28
1 reads
Hi Derrick,>>Can you not enforce that everyone use the same collation?No that is our problem we cant guarantee what the collation sequence will be or how the boxes are setup etc - it is a commercial app/db not an internal one.Rich
2004-06-28
The easiest thing to do would be to add an update_script column to the table. You can then just put the script that updated it in there. Triggers won't capture this level of detail.
2004-06-28
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