Viewing 15 posts - 601 through 615 (of 1,157 total)
To enable PAE, use the /PAE switch in the Boot.ini file. Here is more info on that
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 30, 2010 at 9:03 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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 29, 2010 at 1:39 pm
Double click the file and open it with C:\WINDOWS\SYSTEM32\REGSVR32.EXE
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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)
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 29, 2010 at 8:28 am
AFAIK PAE switch is not enabled by default. This option is also applicable to Windows 2008. Please refer this
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 29, 2010 at 3:17 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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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)....
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 28, 2010 at 10:41 pm
You may use the @sensitivity parameter. Please refer this for more information.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 28, 2010 at 10:35 pm
Also what does the SQL Server Error log has?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 28, 2010 at 1:25 pm
Running a trace is a good option. But ensure that you are running a server side trace. Here[/url] is an example.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 28, 2010 at 1:18 pm
It worked for me on all versions of SQL server and both 32 bit and 64 bit. The TID that you were trying to use in select * from sys.processes...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 28, 2010 at 10:40 am
Viewing 15 posts - 601 through 615 (of 1,157 total)