Forum Replies Created

Viewing 15 posts - 91 through 105 (of 137 total)

  • RE: Executing DTS package

    Couple of things to try:

    1) Move DTSglobalvariables("PullFile")) out of the function and assign the value to a string before the call to FileExists.

    2) Put a msgbox before and after...

  • RE: Importing from Excel with date as table name?

    The rules for identifier names states:

    A letter as defined by the Unicode Standard 2.0. The Unicode definition of letters includes Latin characters from a through z and from A through...

  • RE: Kamikaze script

    I'm guessing it's possible but this would show poor coding. Do you have a script that is currently doing this?

    Darren

  • RE: Mysterious "master$4IDR" data files..

    Are you using Filegroups? That's my only thought.

    Darren

  • RE: File cannot be opened as write during SP3

    Are you logged on under the local admin group login? Seems like a permissions problem. Sorry I can't be of more help.

    Darren

  • RE: File cannot be opened as write during SP3

    Are you sure you don't have something running while this is upgrading? Maybe a job or a DTS package? Did you look in the instmsdb.sql file to see...

  • RE: Shrink Database problem

    It's not read-only is it? You can't auto shrink read only databases. What is the minimum size of the initial data/log files? Remember it can't shrink below...

  • RE: sql server & web server on diff computers..how?

    Take a look at Help on Microsoft Internet Information Services (IIS).

    Darren

  • RE: Log Shipping

    Log shipping isn't supported in the standard edition. However, replication IS so you may want to try transactional replication that runs every few hours. I'd try different delays...

  • RE: Log Shipping Copy Just Stops

    Are you running out of disk space? Are you running the logs with the NOINIT option so it's appending the logs and taking up excess space? Have you...

  • RE: DTS Sch. Job Fails -doesn't exist or access denied

    I'm guessing the user that runs the SQL Server Agent doesn't have access to one of the connections in the DTS Package. Check if the logon account for the...

  • RE: dts package

    That's a tough one. I looked around and couldn't find much in BOL. Other than modifying sysdtspackages to have a different owner and owner_sid, I don't know. ...

  • RE: _WA_ 'indexes'

    You may have done this already but you should but the log file on a different disk than the database file. This can help performance also. Good luck...

  • RE: log shipping rights

    So when you remove them from production the corresponding change never shows up in the remote server database? I was assuming that the log shipping would handle applying that...

  • RE: _WA_ 'indexes'

    Is the slow performance during reads or writes? If it's on reads then adding indexes can be beneficial, however this may hurt performance on writes. Also, is this...

Viewing 15 posts - 91 through 105 (of 137 total)