Viewing 15 posts - 91 through 105 (of 137 total)
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...
April 16, 2003 at 9:38 am
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...
April 16, 2003 at 9:27 am
I'm guessing it's possible but this would show poor coding. Do you have a script that is currently doing this?
Darren
April 16, 2003 at 9:16 am
Are you using Filegroups? That's my only thought.
Darren
April 16, 2003 at 9:14 am
Are you logged on under the local admin group login? Seems like a permissions problem. Sorry I can't be of more help.
Darren
April 15, 2003 at 4:07 pm
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...
April 15, 2003 at 3:07 pm
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...
April 15, 2003 at 2:43 pm
Take a look at Help on Microsoft Internet Information Services (IIS).
Darren
April 15, 2003 at 1:55 pm
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...
April 15, 2003 at 1:32 pm
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...
April 15, 2003 at 12:32 pm
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...
April 15, 2003 at 11:48 am
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. ...
April 14, 2003 at 2:26 pm
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...
April 14, 2003 at 1:20 pm
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...
April 14, 2003 at 1:16 pm
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...
April 14, 2003 at 12:27 pm
Viewing 15 posts - 91 through 105 (of 137 total)