Viewing 15 posts - 46 through 60 (of 583 total)
BS in pharmacy. Many years later, MS in Computing and Information Systems.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
October 19, 2007 at 9:54 am
This article lists the eventClass items and it says it was updated this month:
http://msdn2.microsoft.com/en-us/library/ms186265.aspx
Hope this helps,
Kathi
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
September 27, 2007 at 10:44 pm
I'm not using any encryption. Today things are working properly. I am in the process of changing the service accounts, so maybe just restarting the services made a difference.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
July 6, 2007 at 9:37 am
You can switch from tabbed windows to windows that can be minimized by going to Tools --> Options. Select General under Environment. Switch from Tabbed Documents to MDI Environment.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
June 23, 2007 at 8:22 pm
If you are talking about an Access form, you can use the Screen.ActiveControl object.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
May 31, 2007 at 7:51 pm
A connection manager is part of a SSIS package. It creates the connection to the data, a SQL Server database, Oracle database, flat file, etc.
When you say "my computer goes...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
May 30, 2007 at 7:27 pm
Do a search on this site for "Schedule SSIS package". There are several articles that describe how to do it.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
May 25, 2007 at 9:25 am
Do you get an error message or is the script option grayed out?
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
May 25, 2007 at 9:20 am
You can import tables using the import wizard in SQL or the upsize wizard in access. Access queries will import as tables.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
May 25, 2007 at 7:17 am
just had another thought. could these be extended stored procedures? also, you can also encrypt procs at creation
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
May 25, 2007 at 7:07 am
Are they system procs? What error message are you getting?
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
May 24, 2007 at 2:21 pm
Not sure what you are asking. Do you want to be able to store the data in SQL Server and link from Access? yes, you can do that. Do you...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
May 24, 2007 at 2:17 pm
I found an interesting thread on another site: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=9283
The solution here was to run the script in a DTS package and then schedule the DTS package.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
May 24, 2007 at 2:10 pm
My old laptop at work with 500 MB of RAM that will be replaced this week took 9 seconds. My newer laptop at home took less than 1 second. Actually, the...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
May 23, 2007 at 7:57 am
I'll attempt solution here based on what I think you are trying to say. By the way, it really helps out everyone if you can supply the create table statements...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
May 22, 2007 at 7:14 pm
Viewing 15 posts - 46 through 60 (of 583 total)