Viewing 15 posts - 1,171 through 1,185 (of 1,291 total)
Regarding Gail's Question, you have not clearly described what steps did you perform to move the System Databases, you have copy pasted almost the same post that you posted yesterday,...
November 3, 2009 at 8:30 am
Regarding your question on using replication from Views, You can replicate Views but the underlying tables must be present on the Subscriber.
November 2, 2009 at 6:25 pm
Can you post the Script for create Table and Insert Data into, so that we would be able to use that and setup the same at our end.
Use the...
November 2, 2009 at 5:40 pm
You can solve the problem using SSIS, I agree with Elliott, about the efficiency and Performance of SSIS packages doing this.
The only consideration I gave to BCP...
November 2, 2009 at 4:41 pm
In the past, I worked in a company which has a Vendor Application which uses SQL Server 2000 / 2005, but the Application is designed in such a way that,...
November 2, 2009 at 1:58 pm
You apparently have given a good description of what you have in place and what you intend to do, and also, you have pretty much figured out what are the...
November 2, 2009 at 1:48 pm
Krasavita (11/2/2009)
What should I do? how can I clean it?
You need to Shrink the Database.
Use DBCC SHRINKDATABASE or the Individual Data Files, using DBCC SHRINKFILE
Rather Use the Enterprise Manager
Right...
November 2, 2009 at 1:36 pm
Completely Agree with John, there is no chance to rollback the Service Packs.
November 2, 2009 at 1:19 pm
I moved model and msdb, since the master is in the command line arguments.
What do you mean by Master is in the command line arguments? Have you moved...
November 2, 2009 at 12:20 pm
It seems you are using Windows Server 2008.
Did you check with the Windows Admin / Engineer about the Security permissions for the New location (New Drive where you are moving...
November 2, 2009 at 12:01 pm
I Understand you are unable to login to SQL Server, but I was asking to look in the Error Log File
@ INSTANCE\MSSQL\LOG\ Location, may be that give more info.
November 2, 2009 at 11:36 am
Hi Pedro,
When you said moved the System Databases, did you follow the steps mentioned in MSDN about Moving System databases in SQL 2008. (Since there is a change in procedure...
November 2, 2009 at 11:02 am
mahesh.vsp (10/31/2009)
Hi Bru,So, SP3 would have an impact if it is an clustered environment.
Here, in my environment there is no clusttered environment.
Can i do the SP3 install directly?
My Suggestion...
November 1, 2009 at 7:54 am
Before Installing Service Pack on the Production / Staging Servers where Data is Crucial, Try installing on a test server and test the functionality of the applications / programs...
October 31, 2009 at 10:01 pm
Lanny Irwan (10/31/2009)
Use add/remove program windows in the control panel.
You cannot uninstall only the SP3 for SQL Server 2005.
You have to unistall the entire Product (SQL Server Instance)
October 31, 2009 at 12:21 pm
Viewing 15 posts - 1,171 through 1,185 (of 1,291 total)