Viewing 15 posts - 1,591 through 1,605 (of 1,790 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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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)....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2002 at 10:27 am
Viewing 15 posts - 1,591 through 1,605 (of 1,790 total)