Viewing 15 posts - 2,806 through 2,820 (of 6,104 total)
Have you check Andy Warren's articles on this site? He has at least one on moving a database from one server to another.
K. Brian Kelley
@kbriankelley
July 25, 2005 at 3:16 pm
Start talking to yourself and then there will be two, at least from your perspective. ![]()
K. Brian Kelley
@kbriankelley
July 25, 2005 at 3:14 pm
This subject of Mr. Mohammed Sufian makes me think of the following kids' song. Yes, I'm serious, it really is a kids' song!
K. Brian Kelley
@kbriankelley
July 25, 2005 at 2:46 pm
See if any of the following applies:
How to troubleshoot error 15401 (324321)
Also verify that the time on the SQL Server is within 5 minutes of the...
K. Brian Kelley
@kbriankelley
July 25, 2005 at 12:52 pm
That shouldn't be needed for what the poster is trying to do. That registers the server in AD which allows others to find it. Also necessare to generate the SPN...
K. Brian Kelley
@kbriankelley
July 25, 2005 at 12:49 pm
OK, what about the SQL Server memory counters?
K. Brian Kelley
@kbriankelley
July 25, 2005 at 12:48 pm
Are you typing it in using:
<servername>\<instance>
For instance:
MySQLServer\SQL_Test1
Also, if you use isql (case sensitive on the switches) to connect locally to the instance, say:
isql -S \SQL_Test1 -E...
K. Brian Kelley
@kbriankelley
July 25, 2005 at 12:23 pm
There are no documented ways of doing so, short of modifying sysdepends itself. However, with that said, SQL Server doesn't rely on sysdepends for the processing of queries. Do you...
K. Brian Kelley
@kbriankelley
July 25, 2005 at 12:19 pm
What is doing the inserts? When you look at Performance Monitor, what do the Target Server Memory and Total Server Memory counters (under SQL Server::Memory Manager) look like?
K. Brian Kelley
@kbriankelley
July 25, 2005 at 12:11 pm
You're expecting these rows to appear in a certain order simply by the way you're inserting them? If that's the case, in general, with a relational DB you can't make...
K. Brian Kelley
@kbriankelley
July 25, 2005 at 12:09 pm
You have a "double hop" issue.
If you are in an Active Directory domain, you have the option of using Delegation, but this has security concerns. You'll probably want to get...
K. Brian Kelley
@kbriankelley
July 25, 2005 at 7:48 am
Yes, it is. There are some pre-requisites, however. They are listed in the following article:
HowTo: Backup to UNC name using Database Maintenance Wizard (555128)
K. Brian Kelley
@kbriankelley
July 25, 2005 at 7:37 am
What sort of application is it? Are users connecting to the application using Windows authentication?
K. Brian Kelley
@kbriankelley
July 25, 2005 at 7:32 am
You are right. SSCers should be nice and courteous. Posts should reflect a professional attitude.
With respect to Sufian, I think people were trying to be fair and trying to...
K. Brian Kelley
@kbriankelley
July 25, 2005 at 7:29 am
What are you being required to audit?
K. Brian Kelley
@kbriankelley
July 22, 2005 at 10:45 am
Viewing 15 posts - 2,806 through 2,820 (of 6,104 total)