Viewing 15 posts - 826 through 840 (of 1,065 total)
They should have different ports.
They may not have been automatically assigned, because the first instance wasn't running at the time you installed the second instance etc etc.
I think you'll find that...
July 7, 2005 at 1:19 am
Are you returning the results to a grid or text in Query Analyzer?
The grid takes a lot longer to poulate, and uses a lot more cpu on the client than returning...
July 4, 2005 at 8:19 am
What about addresses that just have a house name instead of a house number, or have a house number of 35a etc.
July 1, 2005 at 3:15 am
You could reduce your exposure slightly by doing a full backup only once a week, and doing differential backups the other days of the week, which should take less time...
June 24, 2005 at 1:26 am
The GO statements in the middle of the BEGIN....END are causing the problem.
This should work (you may need to put an IF EXISTS.... around your create table as well:-
June 22, 2005 at 8:44 am
I'm not sure if this applies to index rebuilds, but ....
When you load data (using BCP or BULK INSERT) into a database that is set to BULK_LOGGED, SQL Server only writes the...
June 21, 2005 at 1:22 am
Grasshopper,
I eliminated any possible caching differences by running dbcc freeproccache and dbcc dropcleanbuffers first.
ramanuj,
I am running the procedure on a machine that is only used by me, so locking and...
June 17, 2005 at 12:07 am
That information lives in the MSdistribution_history table. If you run the SQL below in the distribution database (after entering your publisher and subscriber database names), it will list the next transaction...
April 26, 2005 at 1:40 am
The progress bar on EM tracks the data produced by doing a restore using the 'STATS = ' option, and is accurate, however....
If you are restoring a database that doesn't already...
April 22, 2005 at 6:26 am
This is a known bug in SQL Server 2000, for which there is now a hotfix (not sure what the KB article etc is).
This happens because there...
April 20, 2005 at 2:19 am
In this case, I was only testing the production of the transaction log backups, and transmission of the logs to another site, not the full recovery mechanism.
As you suggested, it...
April 19, 2005 at 10:35 am
I've used it a few times when testing log shipping on a very large database, when I haven't had enough disk space to do a full backup.
Backing up to the...
April 18, 2005 at 1:07 pm
It backs up the database to the NUL device, i.e. it throws the backup away, but as far as SQL Server is concerned, it has just done a full backup...
April 18, 2005 at 8:01 am
I had a similar problem problem some time ago, with a simple system stored procedure I had written (i.e. it was in the master database, and the name began sp_)....
January 5, 2005 at 1:27 am
When SQL Server starts up, if it cannot use the port it has been assigned, then it will dynamically allocate itself a different port.
I've seen this on several occasions. Most...
November 29, 2004 at 1:07 am
Viewing 15 posts - 826 through 840 (of 1,065 total)