Fairly new to DBA work. In error log receiving message Error 1105 Can't allocate space for object 'Syslogs' in database 'msdb' because the logsegment is full.
I've looked in books and is this a serious problem, as I've tried to increase the size of the MSBD device but it will not allow me it says the Max size allowed is -1197MB...Is this right
Any help would be good...
Started work at a new company and relatively new to a SQL server 7.0 DBA role. Need to double check something. Looking at a Database where the database, transaction logs and overnight backups are saved to the same hard disk and 2 backups a week (MONam & THURSam) are made to a DLT tape. Surely this cannot be correct, as if there was a hard disk failure you could only restore from the DLT tape & this maybe a few days old. Is the way forward to save the overnight backups and transaction logs to another server. Any help/advice would be very much appreciated.
View 2 Replies View RelatedHi
I had sql server 2005 standard edition and express edition and sql 2000 desktop edition all installed on my xp notebook.
Whe i tried to create a maintenance plan in sql 2005 standard edition i got an error saying that it couldn't load something (which looked like it might be dll) so I tried to reinstall sql 2005 standard edition over the top to replace the dlls. However the install wizard told me that it can't do anything as all components are already installed!
So i decided to remove SQL 2005 and start again.
In add remove programs i removed various components (like vss writer, and one or two others) then when i clicked on SQL 2005 to remove it I got a message saying that it had already been removed and would i like to remove it from the add remove programs list.. so i said yes.
It actuallly appears that it is installed (after a fashion) although i can't connect to it anymore in ssms. If i put the cd in to try to reinstall it still tells me that it's already installed....i'm stuck now!
So.. i need to do something drastic to remove sql 2005 (as i can't remove it from the add remove programs and the CD won't let me reinstall over the top)
Can anyone help me with any suggestions to physicall remove it
I am trying to verify and create new user based on Billing Statement information. The user may not be the ID of the statement but has a
relationship to that ID.
Here is the data I will be passing:
Statement PrepDate
Statement PatBal
BillTo Address
BillTo Name
Patient DateofBirth
Patient Name
relevant table info:
BILTOS
BillToID, Name (user match), Address1(user match)
STMTHIST
BillToID, PrepDate (user match), PatBal (user match)
PATIENTS
BillToID, Name (user match), BirthDate (user match), Email, PatientsID
PATWEB
PatientID, UserName (user input), PIN (user input), Question (user input), Answer (user input)
I also check to make sure the username doesn't already exist in the PATWEB table
here is what I have so far that is not working (table reference not unique - BILTOS)
INSERT INTO PATWEB (PatientID, UserName, PIN, Question, Answer, LastAccess)
SELECT PATIENTS.PatientID, 'bcolladay@pdsmed.com', 'osx5ief7*', 'What', 'green', CurDate()
FROM PATIENTS, BILLTOS
JOIN PATIENTS BILLTOS ON PATIENTS.BillToID = BILLTOS.BillToID
WHERE not exists (select * from PATWEB Where PATWEB.PatientID = PATIENTS.PatientID)
AND PATIENTS.BirthDate = '1971-05-03'
AND PATIENTS.Name LIKE 'lui%'
AND STMTHIST.BillToID = PATIENTS.BillToID
AND STMTHIST.PatBal = '215.00'
AND STMTHIST.PrepDate = '2008-03-05'
AND BILLTOS.Address1 = '987 Worley St'
AND BILLTOS.Name LIKE 'Lui@'
so I am checking to see if the billing statement and other info they supplied matches before I create the account in PATWEB.
I appreciate any help, thanks
Say for example I have the following 2 database tables, the first one contains the old employee data, and has the fields shown below:
oldEmployeeID
FirstName
LastName
DateOfBirth
HiringDate
TerminationDate
and another one containing the new employee data with similar fields but instead of oldEmployeeID, it is showing the newEmployeeID.
During the conversion process, something were messed up and instead of putting in the original hiring date of the workers into the new employee database, the conversion date was put in, which, depending on the mood of HR ladies, could be any date, and at the same time, of course, new employee join the company, and we assume their hiring dates were entered correctly. On top of that, there are some employee who were terminated before the conversion took place but we still need to keep a record of that.
And I created a third table, say, emplyeeAll with similar fields to the employee data tables.
So here is what I need to do: if the firstName, lastName and DateOfBirth in the old employee data table and the new employee data table matches, I would assume they are the same employee, hence I would put the information for the employee obtained from the new employee data table to the employeeAll table, with the Hiring Date changed to the Hiring Date of the old employee data table (and do not copy the record from the old employee table to prevent duplicates), otherwise, I would simply copy and paste the data in new and old employee table to my employeeAll table.
I know this is really confusing, but...well...hope you know what I am saying...
Is it possible to have a SQL statement for all these? If so, how should the statement looks like?
Thanks a lot!
Regards,
Anyi
"" Then MM_LoginAction = MM_LoginAction + "?" + Request.QueryString
MM_valUsername=CStr(Request.Form("userId"))
If MM_valUsername "" Then
MM_fldUserAuthorization=""
MM_redirectLoginSuccess="/private/private.asp"
MM_redirectLoginFailed="/private/privatelogin.asp"
MM_flag="ADODB.Recordset"
set MM_rsUser = Server.CreateObject(MM_flag)
MM_rsUser.ActiveConnection = MM_conConsumer_STRING
MM_rsUser.Source = "SELECT LastName, Password"
If MM_fldUserAuthorization "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
MM_rsUser.Source = MM_rsUser.Source & " FROM dbo.PLStaff WHERE supervisor != 570 and LOWER( left(firstname,1)) + LOWER(lastname) ='" & Replace(MM_valUsername,"'","''") &"' AND Password='" & Replace(Request.Form("password"),"'","''") & "' and Emp_state = 1 "
MM_rsUser.CursorType = 0
MM_rsUser.CursorLocation = 2
MM_rsUser.LockType = 3
'response.Write(MM_rsUser.Source)
MM_rsUser.Open
If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then
' username and password match - this is a valid user
Session("MM_Username") = MM_valUsername
session.Timeout = 30
If (MM_fldUserAuthorization "") Then
Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value)
Session("manager") = 1
Else
Session("MM_UserAuthorization") = ""
End If
if CStr(Request.QueryString("accessdenied")) "" And false Then
MM_redirectLoginSuccess = Request.QueryString("accessdenied")
End If
MM_rsUser.Close
Response.Redirect(MM_redirectLoginSuccess)
End If
MM_rsUser.Close
Response.Redirect(MM_redirectLoginFailed)
End If
%>
Where do I find out the name of the table being accessed to authenticate the user?
Hi,
I've been asked to sort out a mess as follows:
two dbs on one server...
first db has a user called 'bob'.. that's the login on the server and also the login name on the db in question.
this db has several SP's owned by 'bob' which need to copied to the second db.
Here's where the problem starts.
Somehow, this second db has the standard users it needs, however the db User has a LoginName of 'bob'..
So basically if I try and create a user of 'bob' on the second server which will then allow me to copy these SP's across it says it already exists.. but if I just go ahead and try and copy the SP's it says the User does not exist.
Just to clarify what I mean..
I go into the 2nd db using EM.
go to users:
the visual that appears shows me several users in order with their
Name | Login Name | DB Access
the dbo user is set as:
dbo | bob | 2nd db
basically what I need (I think) is for that login Name to be removed from the dbo user and applied to specific user called bob...
how do I do that?
hi
i have a SSRS report where matrix is embedded into table.
when i view the deployed report in IE, it works fine
But when i view the report in FIREFOX browser.. the report for toss..
the alignment of the report is completely screwed up :-(
My client badly requires Firefox support for all their reports
Any suggestion and help would be appreciated
Thanks
DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.CREATE PROCEDURE [dbo].[spu_Import_Export_Image](@srvr varchar(50),@db varchar(50),@usr varchar(15),@pwd varchar(50),@tbl varchar(50),@col varchar(50),@mod varchar(1),@imgpath1 varchar(1000),@pk varchar(50))ASBEGINdeclare @path varchar(50)declare @whr varchar(200)declare @fil varchar(100)declare @cmd varchar(1000)declare @imgpath varchar(800)declare @ext varchar(5)--declare @pk varchar(50)declare @KeyValue varchar(8000)declare @image varchar(50)--declare @imgpath1 varchar(1000)declare @imgpath2 varchar(1000)declare @sellist varchar(2000)set @path = 'c: extCopy.exe'select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM '+ @tbl + ' ORDER BY ' + @pkexec (@sellist)OPEN curKeyFETCH NEXT FROM curKey INTO @KeyValueWHILE (@@fetch_status = 0)BEGINset @whr = '"where '+ @pk +' = "' + @KeyValueset @fil = @imgpath1 + '' + @KeyValue --+ @extset @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr+ ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' + @col + ' /W ' + @whr + '/F ' + @fil+ ' /' + @modexec Master..xp_cmdShell @cmdFETCH NEXT FROM curKey INTO @KeyValueENDCLOSE curKeyDEALLOCATE curKeyENDGOAbove srcipt runs fine with image data type in one table but when irun for some other table it gives me Error MessageTEXTCOPY Version 1.0DB-Library version 8.00.194SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'.(Concerning line 1)DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.ERROR: Could not use database 'test1'NULL-----------Aslo it only runs on server console if i run it from workstation uingsame files and tables it gives me an error again. Can anybody help meand reply me at Join Bytes! asap.thnx,dharmesh
View 1 Replies View RelatedI have three problems related to Sql Server
a.I am developing a database application using VB5/VB6, SQL server 7 and Crystal reports.When I try to generate reports I get the message 'Automation error'. Please help-urgent.
b. I am using temperorary tables to generate reports.ie Table is created by user.Tables are generated runtime ie created as well as deleted. Sometimes
Sometimes i get the message 'SQLServer error' What should I do.What are the rights to be assigned to LOGINS?.
c.Is there precaution while installing SQLserver in WIN98.
Hi All,
I am getting the following error in DTS.
I request you to help me in this regard.
Error: -2147467259 (80004005); Provider Error: 3023 (BCF)
Error string: Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
Thanks in advance.
Regards
Kalyan Kumar
I get the following error when I try to run distributed queries. I added the 2 linked servers.
[OLE/DB provider returned message: Client unable to establish connection]
[DBNMPNTW]ConnectionOpen (CreateFile()).
Is there anything else I need to check. Let me know
Any clue on what this error is?I am getting this error when I am trying to save after modifying an existing DTS package which transfers 290 tables.
Error: Encripted stream can't exceed 124k
Thanks!
Can anyone help with the following error message?
The column prefix 'TEST_REPORT.dbo.BUS_REQ_DESCRIPTION_TST' does not match with a table name or alias name used in the query.
I removed the constraint and update the table and after that I enforced the constraint again and got following error.
I check the data in both table is fine and both the table have a primary key on it.
Thanks for help in advance
Server: Msg 547, Level 16, State 1, Line 1
ALTER TABLE statement conflicted with TABLE FOREIGN KEY constraint 'fk_ikw_indexed_form_approved_ikw_indexed_uri'. The conflict occurred in database 'rns_indexed', table 'ikw_indexed_form_approved'.
I have set up a job to extract records everyday from a remote server.It has extracted the records but it says the job failed!Any idea what is happening?
Following is the error message.
thanks!
''... DTSRun: Executing... DTSRun OnStart: Create Table Request1999 Step DTSRun OnError: Create Table Request1999 Step, Error = -2147217900 (80040E14) Error string: There is already an object named 'Request1999' in the database. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217900 (80040E14); Provider Error: 2714 (A9A) Error string: There is already an object named 'Request1999' in the database. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: Create Table Request1999 Step DTSRun OnStart: Copy Data from Results to Request1999 Step DTSRun OnProgress: Copy Data from Results to Request1999 Step; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: Copy Data from Results to Request1999 Step; 1628 Rows have been transfo... Process Exit Code 1. The step failed.''
I use the Microsoft Site Server interface to import web log files into a SQL database (db1). The raw logs are around 2GB per day in size. I have been trying to delete a date range from the database, but I keep getting the following error:
50004
37000: [Microsoft][ODBC SQL Server Driver][SQL Server] Could not allocate space for object 'tblImportUser' in database 'db1' because the 'PRIMARY' filegroup is full.
Error adding indexes.
Also, the performance of this machine has greatly decreased from just 2-3 weeks ago. I had been doing some performance testing, so I know that I was able to import a full day of log files (either zipped or unzipped) in just under 2 hours. It is now taking close to 8 hours
Hi,
We are using SQL 6.5 and maintaining a application written in Delphi 3.0. While executing the one of the stored procedure(Cover period) we are getting following error msg:
"Unable to create Query Error in Calculating Cover period General SQL Error. Can't allocate space for object '-333' in database 'tempdb' because the 'system' segment is full" with a warning "Fatal Error 1510 occured"
We have increased the space for DB, but still we are getting the same problem.
We would appreciate, if you respond asap
Regards
We are installing the final release of SQL 2005 On our main SQL server.
View 10 Replies View RelatedI've been working on a project that exchanges data with 2 different mssql dbs. Today I compiled my website and test it locally on remote databases. Everything seemed ok. Then I uploaded all files to the server and after an hour something strange has happened, I do not know why. I could still reach the website locally using remote connstrings but when I try to visit One of the databases could not be connected, ASP.NET said.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Interesting thing is that website can authorize the request (I mean I can login) after that it throws this error.
Thanks
hi frenz:
This is my query:it shows the following
error:Incorrect syntax near the keyword 'as'.plz let me know my error, and how to correct it.
My Query:
SELECT EH.EmpID, EL.UserName,EL.Password, E.FirstName, E.LastName, E.DesignationID,
E.DepartmentID, E.Sex, E.DOB, E.Age, E.Address, E.Email,
'ContactNo'= Case When E.phone is not null Then E.phone When E.phone is null
Then E.Mobile End ,E.DateOfjoining, D.Designation, DE.Department,E.HobbyID
where E.HobbyID in
(select EH.HobbyID from EMP_Tbl_EmployeeHobbies EH inner join EMP_Tbl_Hobby H on EH.HobbyID=H.HobbyID) as item1,
From dbo.EMP_Tbl_Employee E
Inner Join dbo.EMP_Tbl_Designation D On E.DesignationID=D.DesignationID
Inner Join dbo.EMP_Tbl_Department DE On E.DepartmentID=DE.DepartmentID
Inner Join dbo.EMP_Tbl_EmployeeHobbies EH On E.EmpID=EH.EmpID
Inner Join dbo.EMP_Tbl_EmployeeLogin EL On E.Sno=EL.Sno
We run a site through asp.net (programmed in visual studio.net) and the site's beginning to get a lot of problems (as the site grows)
Here is the latest error message. I was wondering if someone could help me troubleshoot this.
Server Error in '/' Application.
--------------------------------------------------------------------------------
Transaction (Process ID 145) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Transaction (Process ID 145) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: Transaction (Process ID 145) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +44
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
Saltwaterfishing.Components.DB.RankResults.SearchAllSites(String query, Int32 currentPage, Int32 pageSize) in
***************ComponentsDBRankResults.cs:43
***************.Controls.RankResultsGrid.BindDataGrid() in ***************\ControlsRankResultsGrid.ascx.cs:82
***************.Controls.RankResultsGrid.ShowResults() in ***************ControlsRankResultsGrid.ascx.cs:68
***************.Main.ShowPage() in
***************\saltwaterfishingmain.aspx.cs:75
***************.Main.Page_Load(Object sender, EventArgs e) in ***************\main.aspx.cs:43
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Thank you
Hi...I have the codes below and it works fine...but there is another field called References and if I add that to the below codes ...then I get an error saying that 'Incorrect Syntax near the keyword 'References'......can someone help me out with this.....Thanks
---This sets the fields as current---
Set db = Server.CreateObject("ADODB.Connection")
db.Open "dsn=DemoBase;"
Set Current = db.Execute("SELECT TheDate, Code, Title, Author, Apparatus, Instructions, Comments, DCSReference, Location, ShortDescription, Video, Popular, Classification, Working FROM dbo.AllDemos WHERE Code = '" + Replace(CodeVar, "'", "''") + "'")
----This updates the database-------
Set UpDateDB = Server.CreateObject("ADODB.Connection")
UpDateDB.Open "dsn=DemoBase;"
Set UpDate = UpDateDB.Execute("UPDATE dbo.AllDemos SET Title = '" + title + "', Comments = '" + Comments + "', Author = '" + Author + "', TheDate = getdate(), Code = '" + Code + "', DCSReference='" + DCSReference + "', Classification = '" + classification + "', Video = '" + Video + "', Instructions = '" + Instructions + "', Apparatus = '" + Apparatus + "', Location = '" + Alocation + "', ShortDescription = '" + SDescription + "', Working = '" + Working + "' WHERE (Code = '" + OldCode + "')")
Hi there
I have this error message when I try to connect to a server SQL Server :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver] Client unable to establish connection
/include/ctt.asp, line 6
Thanks in advance
Hi,
I am trying to do DTS for transfering data from one server to other server,both are on T1 link,after some time DTS failed by giving error message saying that
" Error at destination for Row number 3357844,Errors encountered so far in this test:1,,,Invalid charector value for cast Specification "
that table have 24 million rows..
How can i solve this problem,Please help me in this.this is urgent please
Mark A
Hi,
I have this error message on the server event log. I don't know what it actually means and how it can be resolved.
Error: 644, Severity: 21, State: 1
Could not find the index entry for RID '36f072000300101a0434d54525830303237323038' in index page (1:28942), index ID 2, database 'gemprod'.
Thanks in advance.
Hello!
Yesterday my DTS designer was fine and today suddenly when I open the package in designer there is nothing there.
I tried to create new package and it gave me an error when I was trying to save it "It is insufficient disk space to complete operation".
What does this mean?
Thanks
Lena
Hello!
MSSQL Server 7.0 SP2
One of my users is running DTS packages on her computer using dtsrun utility.
I installed SQL client tools so she can run dtsrun utility.
It was working fine until we moved production database to the new server.
Local DTS packages were saved to the new server and recreated accordingly.
Now when she is running DTS packages in MSDOS using dtsrun she's getting error message "Can not create COM server to load DTS package. Class not registered".
Before this message she was getting different error "Paremeter is incorrect"
Then I applied SP2 to her client sql tools.Because new SQL Server has SP2.
After that we've got new message about COM server.
But dtsrun works on another client machine.
Any ideas what's going on?
Thank you
Lena
Error when i try to execute a SP with ADO connection, or ADO COMMAND
[ODBC SQL Server Driver][SQL Server]The identifier that starts (XXXXXX)is too long. Maximum length is 128.
can anyone help me.
--------------------------------------------
Declare @filename char(22)
Declare @cmd char(100)
Select @filename = '"' + 'D:Feedsest_' + substring(convert(char(12), getdate(), 12), 3, 4) + substring(convert(char(12), getdate(), 12), 1, 2) + '"'
Select @cmd = "xp_sendmail @recipients = 'test@test.com'
, @attachments = " + @filename + " "
exec(@cmd)
Go
--------------------------------------------
Above T-SQL step is causing the following error:
Server: Msg 103, Level 15, State 7, Line 6
The identifier that starts with 'xp_sendmail @recipients = 'test@test.com'
is too long. Maximum length is 128.
Any help??Thanks.
hI iam getting error as 08s01 from the application end to connect to my database.It says communication link failure (odbc error)
no users were able to get into the database. (other applications accessing other DB's on the same server are able to connect )
In my error log i hav this
ERROR 602: severity 21
coudntfind row in sysindexes for dbid,obj id , INDEX 1. Rund dbcc checktable on sysindexes.
I haf run dbcc commands evrything is showing fine. I haf non-clustered inbdex defined on that particular object.
In sysindexes i haf indid as 0 & 2.
i am running out of ideas. can anyone PLEASE suggest anything for me. sqlserver 6.5, standard security.
Thanks for ur help
Ravi
Hey everyone - I get the following error when I try to open up a DTS package that I ported from one machine to another as a file. The error is:
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: The parameter is incorrect.
Does anyone know what this error is and how to get the package to open? I really don't want to have to rewrite the package if I can avoid. Any help would be greatly appreciated.
hi ,
i am getting this error while executing,pls tell me the way..
Server: Msg 1101, Level 17, State 10, Line 1
Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT.
Space can be created by dropping objects, adding additional files, or allowing file growth.
--raj