philcart

Forum Replies Created

Viewing 15 posts - 1,876 through 1,890 (of 2,487 total)

RE: Pros & Cons of backups using Maint. Plans

Maintenance plans work well for most databases in SQL 2K. The exceptions are large multi-gb databases and databases with high-availability requirements.
If your database has to be available 24/7 and has...
--------------------
Colt 45 - the original point and click interface

December 14, 2003 at 3:46 pm

#486078
RE: Query Analyzer - Licensing

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...
--------------------
Colt 45 - the original point and click interface

December 11, 2003 at 4:33 pm

#485861
RE: DTS Password Recovery

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...
--------------------
Colt 45 - the original point and click interface

December 10, 2003 at 9:23 pm

#485645
RE: retrieve a filesystem's date and time from TSQL

Have a look at xp_getfiledetails.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface

December 10, 2003 at 9:18 pm

#485644
RE: SQL Mail

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...
--------------------
Colt 45 - the original point and click interface

December 10, 2003 at 9:17 pm

#485643
RE: DTS SCHEDULER

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
--------------------
Colt 45 - the original point and click interface

December 10, 2003 at 8:54 pm

#485642
RE: Designer Issues

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...
--------------------
Colt 45 - the original point and click interface

December 10, 2003 at 3:52 pm

#485625
RE: Using OnError in a custom task in VC++.

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...
--------------------
Colt 45 - the original point and click interface

December 10, 2003 at 3:38 pm

#485623
RE: Counting Records from Text Files

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...
--------------------
Colt 45 - the original point and click interface

December 10, 2003 at 3:32 pm

#485622
RE: How SQL-SVR Execute Query? Filter or Join First?

quote:
I just wanted to know the strategy implemented by SQL when parsing and execute a query in general.
--------------------
Colt 45 - the original point and click interface

December 9, 2003 at 8:39 pm

#485458

RE: How SQL-SVR Execute Query? Filter or Join First?

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

--------------------
Colt 45 - the original point and click interface

December 9, 2003 at 6:41 pm

#485450

RE: Help with date function

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



--...

--------------------
Colt 45 - the original point and click interface

December 9, 2003 at 6:33 pm

#485449