Viewing 15 posts - 601 through 615 (of 1,161 total)
You are trying to install a service pack SQL Server 2008 on an instance running SQL Server 2008 R2.
10.5.1600.1 = SQL Server 2008 R2 RTM is the one that is...
September 30, 2010 at 3:42 am
Run sp_helpdb and you would notice that the Database Owner for that database is NULL. Running sp_changedbowner 'OwnerName' would fix this issue. I had a similar issue and posted about...
September 30, 2010 at 12:23 am
Run a profiler trace with the event "Audit Login Failed" selected. The trace should give you the Application Name with which the login is trying to connect
September 29, 2010 at 1:39 pm
Double click the file and open it with C:\WINDOWS\SYSTEM32\REGSVR32.EXE
September 29, 2010 at 9:41 am
Missed to state that you need to register that DLL using REGSVR32.exe (located under c:\windows\system32)
September 29, 2010 at 8:28 am
You may try the following.
Copy the existing BatchParser.dll to a safe location
Locate an instance running the same build of SQL Server as the one having issues
Copy BatchParser.dll from that instance...
September 28, 2010 at 10:49 pm
You can do it either way. If you double click on it, after execution the command prompt window will close (unless there is a PAUSE command in the batch file)....
September 28, 2010 at 10:41 pm
You may use the @sensitivity parameter. Please refer this for more information.
September 28, 2010 at 10:38 pm
You can VERIFY it after the backup has completed. Below is an example.
FETCH NEXT FROM @cursor INTO @dbname
WHILE @@FETCH_STATUS = 0
BEGIN
SET @query = 'BACKUP DATABASE '+ @dbname...
September 28, 2010 at 10:35 pm
Also what does the SQL Server Error log has?
September 28, 2010 at 1:35 pm
T-SQL alternative to what Steve had mentioned. Execute
sp_readerrorlog 1
The last entry in the output would give you the time when the instance was restarted
September 28, 2010 at 1:31 pm
If you don't find anything in the ErrorLog, try starting the instance from the command line using sqlservr.exe
This should give you some indication as to why the instance is not...
September 28, 2010 at 1:25 pm
Viewing 15 posts - 601 through 615 (of 1,161 total)