Forum Replies Created

Viewing 15 posts - 16 through 30 (of 38 total)

  • RE: Call Excel functions from SQL stored procedure

    you have the option of creating a query in Excel or use DTS transform that brings the data into Excel. Then you can use any Excel function you want.

    NOTE: You...

    Don't count what you do, do what counts.

    SQL Draggon

    November 18, 2004 at 9:19 am

    #530690

  • RE: Daylight Savings time change effect on jobs

    To keep this from becoming an issue with any scheduled job or process, I never schedule a job to start between 12:55AM. and 2:05 AMDon't count what you do, do what counts.

    SQL Draggon

    October 28, 2004 at 8:32 am

    #528306

  • RE: Remote distributor for clustered S2K 2000 publisher

    I've been running replication on a clustered server for over 1 year >>> No Problems. Got a great performance boost too .

    Go for...

    Don't count what you do, do what counts.

    SQL Draggon

    October 22, 2004 at 1:06 pm

    #527708

  • RE: Droping the Database in emergency mode

    When the db was in "suspect" mode, did you run the "sp_resetstatus" stored procedure?

    Don't count what you do, do what counts.

    SQL Draggon

    October 8, 2004 at 10:24 am

    #525984

  • RE: Unable to Restore Master db backup copy on another server

    What is your reasoning for restoring the master database from one server to another, be more specific in what you are trying to accomplish >>> if you are migrating SQL...

    Don't count what you do, do what counts.

    SQL Draggon

    October 1, 2004 at 3:14 pm

    #525091

  • RE: Scheduling DTS Problem

    When you right click on the package and schedule it that way >>> the system creates a job that runs the package. If you do it again you won't see...

    Don't count what you do, do what counts.

    SQL Draggon

    October 1, 2004 at 2:54 pm

    #525090

  • RE: Replicate / Mirror DB Structure and Data

    the "best" way depends on what you want to accomplish.

    Log Shipping: Any changes made on the production DB including all schema modifications are reflected on your test box. SQL Server...

    Don't count what you do, do what counts.

    SQL Draggon

    September 21, 2004 at 9:09 am

    #523837

  • RE: log shipping problem - can not use recent backup

    I'v tried to do that lots of times, receiving different errors (from timeouts to access violations >>> same source/destination servers.) >>> with no luck. Don't waste your time with that option >>>...

    Don't count what you do, do what counts.

    SQL Draggon

    August 26, 2004 at 9:45 am

    #520745

  • RE: email notification of # of records

    Before the e-mail task >> create a task that counts the number of records and create a text file >> then attach the file to the e-mail.

    KISS >

    Don't count what you do, do what counts.

    SQL Draggon

    August 17, 2004 at 10:00 am

    #519385

  • RE: Stored Procedures dont come across in DTS

    Are the stored procedures encrypted ?? they won't come across and you can't script them >> you can only restore from a backup. I have had ~50% success in using...

    Don't count what you do, do what counts.

    SQL Draggon

    August 17, 2004 at 9:17 am

    #519372

  • RE: Relication V Log Shipping

    You can use either "Tranactional"/"Snapshot" replication depending on your connection to the subscribing server. Log shipping maintains the stand-by database in recovery/read-only mode. in read-only mode the users get disconnected...

    Don't count what you do, do what counts.

    SQL Draggon

    August 11, 2004 at 12:11 pm

    #518558

  • RE: Backup & restore - Who should do?

    Do a native SQL Server backup to disk, have tha admins backup that file/directory. DON'T use any 3rd party SW that stopes SQL Server to do a backup, if a...

    Don't count what you do, do what counts.

    SQL Draggon

    August 11, 2004 at 12:04 pm

    #518556

  • RE: Can you truncate a published table?

    I don't beleive that replication will allow you to truncate a table.

    Why don't you create a transactional/snapshot publication with the tables that you want to archive, and schedule it to...

    Don't count what you do, do what counts.

    SQL Draggon

    August 9, 2004 at 9:33 am

    #518206

  • RE: Shrink file on stand by server with log shipping

    Have you tried shrinking the log shipping database using the shrink database via enterprise manager ? If a db is in recovery mode, you have very limited access to the...

    Don't count what you do, do what counts.

    SQL Draggon

    August 9, 2004 at 9:23 am

    #518201

  • RE: Adding all articles in T-SQL?

    Create the publication in EM.

    Once created, right click on the publication and select "Generate SQL Script".

    this will give you a script that you can modify and run using "query analyzer"...

    Don't count what you do, do what counts.

    SQL Draggon

    July 6, 2004 at 9:59 am

    #513474

    • Viewing 15 posts - 16 through 30 (of 38 total)