Viewing 15 posts - 136 through 150 (of 182 total)
Choose create new instance and it will give you the option to install a default intance (if one is not present) or uncheck that option and create another named instance....
October 26, 2005 at 7:38 am
Understanding the application is a more practical approach than brute force, especially if a connection pool keeps openeing connections as you kill them.
Exmaple: If it is an web application using...
October 26, 2005 at 7:33 am
Yes, it can be used to connect to an FTP server on UNIX. I believe you are talking about the destination path ,which has nothing to do with the FTP...
October 26, 2005 at 7:22 am
Are you taking adavntage of AWE? There is a bug with SP4 and AWE! What was the symptoms that caused the vendor to make this recommnedation? Was the server becoming...
October 25, 2005 at 8:26 pm
What version of OS and MS SQL Server are you running?
October 25, 2005 at 5:49 pm
Did you check in the msdb.dbo.sysdbmaintplan_history table to see if the delete old transaction logs job had an entry? Please define the maint plan you have set up for transaction...
October 25, 2005 at 5:46 pm
Are you saying the text file step does not work after you change the extension?
October 25, 2005 at 2:45 pm
Is it a valid .csv file? Have you opened it with a text editor or excel after you ftped it? try using a regular text file step and define it...
October 25, 2005 at 2:18 pm
Watch Avg. Disk Queue Length in perfmon! How many SCSI controllers did you purchase with it 1 or 2? Does it go over 1 or 2 and stay over 1 or...
October 25, 2005 at 2:12 pm
Only if you can get to the file from windows. Is the file on windows or UNIX?
October 25, 2005 at 1:09 pm
If WIN2003 or XPSP2 it may be a problem with MS DTC.
October 25, 2005 at 1:03 pm
Is the .csv file located on the UNIX box after it is dumped? If so, you will need to ftp the file to the local host or a Windows server...
October 25, 2005 at 12:54 pm
What are you trying to accomplish? Depending on the type of activity on a table the statistics can become stale in seconds. The ONLY accurate wat to get a rowcount...
October 25, 2005 at 12:49 pm
Is it always the same object that has locks that block the DBCC command? It could be a central table to the application and the isolation level of the sql...
October 25, 2005 at 12:47 pm
DBCC INDEX DEFRAG is going to want to do some type of exclusive locking more than likely at a page level. If the application holds an in-compatible lock the DBCC command...
October 25, 2005 at 11:40 am
Viewing 15 posts - 136 through 150 (of 182 total)