Viewing 15 posts - 1,591 through 1,605 (of 1,789 total)
Christine,
If you are doing transformations during this process you will definitely slow things down. Best bet is to do a BCP of Bulk Insert type operation from source server to...
May 28, 2002 at 1:34 pm
Steve,
Great post. Like the suggestion of monitoring create date in sysobjects. I have my security well locked down in all areas except with a couple of legacy customers / developers...
May 23, 2002 at 6:59 am
Absolutely! I use the file backup and restore to another location nightly for several "replication" efforts and it works great. Simply backup the database to disk on your source server...
May 20, 2002 at 7:00 am
Since all transactions have to be completed prior to a successful detach then I would say that the truncate log step is not necessary.
Hope this helps.
David
May 17, 2002 at 3:12 pm
Can you have two versions of SQL Server running on the same server? It would seem that they would have to share services so, it doesn't seem possible. I have...
May 15, 2002 at 2:30 pm
There is a hot fix out for this that has been released to those that have called MS for support. I will check with the MS contact to see when...
May 13, 2002 at 11:07 am
Mike,
Check out the MS Articles Q263556 and Q315886. These give a good overview of what is required to set up SQL Mail and then common problems associated with it.
My...
May 13, 2002 at 10:46 am
I believe that you can install the client tools, however the problem is that if that 7.0 server is less that SP3 then the DTS versions you are creating are...
May 10, 2002 at 3:00 pm
You would have to use unc path to specify the location. Example would be \\YourServer\e$\Databases\Bakup
That should work just fine.
Hope this helps.
David
May 10, 2002 at 2:55 pm
It appears that the variable you are building does not match the name of the job you are trying to run. Is that the valid name?
David
May 10, 2002 at 2:37 pm
Melanie,
After having xp_sendmail cause many important jobs (either procedure based or DTS package based) to fail, I have moved to a homegrown way of using xp_sendmail(there are others I am...
May 9, 2002 at 6:01 am
The profile that is used by SQL Mail on the server needs to match the profile that is established in the mail task (default to currently logged on users profile)....
May 7, 2002 at 4:09 pm
Server Network Utility (Programs, SQL Server, Server Network Utility). Select TCP/IP and look at the properties. If on SQL Server 2000 you will need to select the properties button, 7.0...
May 2, 2002 at 11:57 am
Two things off the top of my head, either the object is owned by someone else i.e. ptarry.Products, or you have some type of case sensitivity that is hitting you...
May 1, 2002 at 10:34 am
Touch Typist at about 60 WPM on a good day. I would agree that most Touch Typers have the PDA problem as well. Not here though. Don't know why.
Out...
May 1, 2002 at 10:27 am
Viewing 15 posts - 1,591 through 1,605 (of 1,789 total)