Viewing 15 posts - 1,876 through 1,890 (of 2,486 total)
Client tools are licensed with the Server. They are useless without a Server installed somewhere. You can install as many copies as needed.
Make sure you do a custom install and...
December 11, 2003 at 4:33 pm
I'd say you've got 30 days to swallow a bitter pill and get chummy with the recently departed employee.
Then I'd set about setting up standards and procedures to ensure it...
December 10, 2003 at 9:23 pm
Have a look at xp_getfiledetails.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
December 10, 2003 at 9:18 pm
You don't specify how you are creating the CSV file, but if you put a single quote before the numeric value, Excel will automatically treat it as text.
Hope this helps
Phill...
December 10, 2003 at 9:17 pm
Do you have package logging enabled? Can you post the error messages?
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
December 10, 2003 at 8:54 pm
At the moment it looks like MS has aimed to provided the basics of an extensible platform. I think the real gold for RS will be the third-party add-ons.
We are...
December 10, 2003 at 3:52 pm
I don't do anything with VC++, mainly stick to VB and C#.
You could try these to see if they give you some ideas,
http://www.codeproject.com/database/dts.asp
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=6196&pg=2
http://support.microsoft.com/default.aspx?scid=kb;EN-US;319985
Hope this helps
Phill Carter
--------------------
Colt 45 - the original...
December 10, 2003 at 3:38 pm
Do you need the count before or after you import the data? If you need it after the import you can use an ActiveXScript task to return the RowsComplete value...
December 10, 2003 at 3:32 pm
quote:
I just wanted to know the strategy implemented by SQL when parsing and execute a query in general.
December 9, 2003 at 8:39 pm
Can you paste your query and table structure so I can base my suggestions on something?
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
December 9, 2003 at 6:41 pm
Try these queries,
-- 1. past 24 hrs( simple enough)
-- use seconds to take into account partial hours
SELECT * FROM requests WHERE DATEDIFF(ss, request_date_time, GetDate()) < 86400
--...
December 9, 2003 at 6:33 pm
What is the error message that the package fails with? Do you have Package Logging enabled? How does your ASP page connect to the SQL Server?
Hope this helps
Phill Carter
--------------------
Colt 45...
December 9, 2003 at 5:48 pm
For SQL Server to receive and process mail it requires a MAPI client installed on the server and a mail server that is extended MAPI-compliant.
Hope this helps
Phill Carter
--------------------
Colt 45 -...
December 9, 2003 at 5:45 pm
Are there any error messages in the Error Log? What are the specifications of the server? What are the sizes of the databases?
Check out the following topics in Books Online...
December 9, 2003 at 5:40 pm
Put your query in Query Analyzer.
Choose "Show Execution Plan" from the "Query" menu.
Execute the query.
View the excution plan by clicking the "Execution Plan" tab.
This will show you the steps SQL...
December 9, 2003 at 5:35 pm
Viewing 15 posts - 1,876 through 1,890 (of 2,486 total)