How To Handle System Database
Apr 29, 2015
I have assignment to do inplace upgrade from sql 2012 to 2014.for user database either i can restore or attach and change compatbility level. How to handled system database, my main concern is exiting job, if i restore sql 2012 msdb database, will this bring all existing jobs or do i need to script jobs before uninstall? also need to know, how to handle replication. The server, i am going to upgrade is replicating data to different server and also act as subscriber ,
View 3 Replies
ADVERTISEMENT
Apr 14, 2006
I am trying to insert a large amount of data from a web form I created into a "text" field in my DB. Problem is its oly entering the 1st 16 characters. I can see why but I dont understand what I need to do to avoid this shortcomming. Ive searched the forums here and in google groups to no avail :(
<code>
sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Content", System.Data.SqlDbType.Text, 16, "Content")).Value = ftbContent.Text
</code>
How do I need to restructure the above line?
Any help would be appreciated.
TIA,Stue
View 5 Replies
View Related
May 27, 2006
Hi everyone,
Kindly tell me the size of database that SQL Express can handle.
Tks for your cooperation.
Brgds,
Adien
View 4 Replies
View Related
Dec 12, 2007
I have a asp.net 2.0 web application. In one of the modules I have following scenario. In the UI there are 3 pages to take the input from the user. On the 1st page, we are inserting data in the master table and with the same we are beginning new sql transaction with the isolation level READ UNCOMMITTED. so that uncommited master table data can be read. Master table has also has 4 detail tables. Then the user is navigated to 2nd and then to 3rd page where the user can enter multiple records in the detail tables. And only after finishing on the 3rd page, the transaction is commited.
I want to ask that is it the right way of doing this kind of functionality?
And is there any other way of doing this?
View 6 Replies
View Related
Mar 30, 2007
Hi everyone. I hope that my question isn't too broad, but here it goes...
I am trying to figure out the best way to scale a SQL Server database so that it can handle a billion simultaneous users querying the same tables, and can easily scale to handle many billions of simultaneous users. The database must also have 999.99% availability. The number of licences and amount of hardware needed is not an issue.
Thanks in advance.
View 15 Replies
View Related
Dec 3, 2007
Hi
I'm using service broker and keep getting errors in the log even though everythig is working as expected
SQL Server 2005
Two databases
Two end points - 1 in each database
Two stored procedures:
SP1 is activated when a message enters the sending queue. it insert a new row in a table
SP2 is activated when a response is sent from the receiving queue. it cleans up the sending queue.
I have a table with an update trigger
In that trigger, if the updted row meets a certain condition a dialogue is created and a message is sent to the sending queue.
I know that SP1 and SP2 are behaving properly because i get the expected result.
Sp1 is inserteding the expected data in the table
SP2 is cleaning up the sending queue.
In the Sql Server log however i'm getting errors on both of the stored procs.
error #1
The activated proc <SP 1 Name> running on queue Applications.dbo.ffreceiverQueue output the following: 'The conversation handle is missing. Specify a conversation handle.'
error #2
The activated proc <SP 2 Name> running on queue ADAPT_APP.dbo.ffsenderQueue output the following: 'The conversation handle is missing. Specify a conversation handle.'
I would appreceiate anybody's help into why i'm getting this. have i set up the stored procs in correctly?
i can provide code of the stored procs if that helps.
thanks.
View 10 Replies
View Related
Jan 18, 2008
We have implemented our service broker architecture using conversation handle reuse per MS/Remus's recommendations. We have all of the sudden started receiving the conversation handle not found errors in the sql log every hour or so (which makes perfect sense considering the dialog timer is set for 1 hour). My question is...is this expected behavior when you have employed conversation recycling? Should you expect to see these messages pop up every hour, but the logic in the queuing proc says to retry after deleting from your conversation handle table so the messages is enqueued as expected?
Second question...i think i know why we were not receiving these errors before and wanted to confirm this theory as well. In the queuing proc I was not initializing the variable @Counter to 0 so when it came down to the retry logic it could not add 1 to null so was never entering that part of the code...I am guessing with this set up it would actually output the error to the application calling the queueing proc and NOT into the SQL error logs...is this a correct assumption?
I have attached an example of one of the queuing procs below:
Code Block
DECLARE @conversationHandle UNIQUEIDENTIFIER,
@err int,
@counter int,
@DialogTimeOut int,
@Message nvarchar(max),
@SendType int,
@ConversationID uniqueidentifier
select @Counter = 0 -- THIS PART VERY IMPORTANT LOL :)
select @DialogTimeOut = Value
from dbo.tConfiguration with (nolock)
where keyvalue = 'ConversationEndpoints' and subvalue = 'DeleteAfterSec'
WHILE (1=1)
BEGIN
-- Lookup the current SPIDs handle
SELECT @conversationHandle = [handle] FROM tConversationSPID with (nolock)
WHERE spid = @@SPID and messagetype = 'TestQueueMsg';
IF @conversationHandle IS NULL
BEGIN
BEGIN DIALOG CONVERSATION @conversationHandle
FROM SERVICE [InitiatorQueue_SER]
TO SERVICE 'ReceiveTestQueue_SER'
ON CONTRACT [TestQueueMsg_CON]
WITH ENCRYPTION = OFF;
BEGIN CONVERSATION TIMER ( @conversationHandle )
TIMEOUT = @DialogTimeOut
-- insert the conversation in the association table
INSERT INTO tConversationSPID
([spid], MessageType,[handle])
VALUES
(@@SPID, 'TestQueueMsg', @conversationHandle);
SEND ON CONVERSATION @conversationHandle
MESSAGE TYPE [TestQueueMsg] (@Message)
END
ELSE IF @conversationHandle IS NOT NULL
BEGIN
SEND ON CONVERSATION @conversationHandle
MESSAGE TYPE [TestQueueMsg] (@Message)
END
SELECT @err = @@ERROR;
-- if succeeded, exit the loop now
IF (@err = 0)
BREAK;
SELECT @counter = @counter + 1;
IF @counter > 10
BEGIN
-- Refer to http://msdn2.microsoft.com/en-us/library/ms164086.aspx for severity levels
EXEC spLogMessageQueue 20002, 8, 'Failed to SEND on a conversation for more than 10 times. Error %i.'
BREAK;
END
-- We tried on the said conversation, but failed
-- remove the record from the association table, then
-- let the loop try again
DELETE FROM tConversationSPID
WHERE [spid] = @@SPID;
SELECT @conversationHandle = NULL;
END;
View 2 Replies
View Related
Dec 10, 2007
While attempting to set up sql replication in MSSQL 2005 one of my user databases is now in the systems database folder. I need to move it back to the user databases folder. Any help would be greatly appreciated.
View 16 Replies
View Related
Aug 21, 2006
I have created a windows library control that accesses a local sql database
I tried the following strings for connecting
Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Trusted_Connection = true"
Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Integrated Security=SSPI"
I am not running the webpage in a virtual directory but in
C:Inetpubwwwrootusercontrol
and I have a simple index.html that tries to read from an sql db but throws
the error
System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection,
etc etc
The action that failed was:
Demand
The type of the first permission that failed was:
System.Data.SqlClient.SqlClientPermission
The Zone of the assembly that failed was:
Trusted
I looked into the .net config utility but it says unrestricted and I tried adding it to the trusted internet zones in ie options security
I think that a windows form connecting to a sql database running in a webpage should be simple
to configure what am I missing?
View 28 Replies
View Related
May 6, 2008
hi,
I am getting a data in a dbf file and they have a StartDate and end Date for where the Statments are valid for.. How can i incorporate them into the database..
right now We are doing with PeriodId.. like while the user imports the data they select which period they want to import the data into.. But now if i have to get those details from the Database how do i store it in the Database..and i need to store them in multiple tables..
Thanks
Karen
View 6 Replies
View Related
Feb 22, 2008
By, system database are installed in C: drive and it is Production Server now. Is there a way to move system database to D: drive without affecting Server?
View 5 Replies
View Related
Mar 7, 2007
hi every one:
i want to build a HR system application ,any ideas how using sql server and asp.net
View 1 Replies
View Related
Feb 18, 2008
hi all,
i realy need quick help. i have windows 2003 enterprise edition 64 bit and i have 32bit SQL server 2005 32 bit. Recently i faced many troubles because of 32 bit and 64 bit so i have decided to change my SQL server 2005 to be 64 bit. I backup everthing in the server and i formatted my windows to have clear installation and i installed SQL 2005 server 64 bit. I restored everthing excpet Master database i couldn't i went to msdn site i got there some technics to move Master databes but it's not working with it's just worked if installed sql 32bit so i returned back to 32 bit. Now i want to format and install my Windows 2003 64bit and i want to install Sql server 64 bit and restore all the databases and system databases as it was before format.
View 3 Replies
View Related
Mar 11, 2008
Hello all,
I've been asked to build a .net web application, where users will be able to upload, search and view images. There will probably be about 2000 - 10000 users who will upload and view photos each day.
Each image that is uploaded, is saved as a thumbnail, a small image, and the original. So considering the possible amount of data being uploaded, stored, searched for and viewed, whats the best way to store the images? Database or File system? Whats would be the fastest option for a web application? Should I even be looking at a different solution?
cheers!
Matty
View 2 Replies
View Related
Jan 26, 2005
What is the correct order:
Should it be:
Master
Model
MSDB
Tempdb
I understand that the model should be before the MSDB database but as for master and tempdb I don't know the order.
Thanks
Lystra
View 10 Replies
View Related
Jul 16, 2013
company is developing a database system containing information about cities, towns, and villages in the country. The number of cities, towns, and villages are in thousands and the database program should allow users to search a particular place by name. Users should also be able to search all places that match a particular value or range of values for attributes such as location or population size. This particular feature is known as a range query.
If the database is meant to support range queries that can return many cities that match the query specification, the entire operation may be allowed to take longer. To meet this requirement, it will be necessary to support operations that process range queries efficiently by processing all cities in the range as a batch, rather than as a series of operations on individual cities.Different indexing methods can be used to perform this operation. What will be your choice if:
a) database is created once and has no change over a period of time
b) database is created once and database is changed over a period of time
View 2 Replies
View Related
Jan 21, 2008
I found out our system backup system database every week, which occupy a lot of space. Is it necessary?
Thank you.
View 2 Replies
View Related
Jun 29, 2007
I have a 2005 server that is upgraded to SP2 and the error log indicates it is version 9.00.3042.00. However, the system resource database for the same server is reporting as version 9.00.2047.00. From another post I have found out the some replication problems I am having are due to this discrepancy.
I have reapplied SP2 hoping it would change the resource db version, but it did not. Is there another way I can upgrade the resource db without re-installing SQL from scratch?
Thanks!
View 4 Replies
View Related
May 20, 2008
I want to use RAID 1 for System database with sQL Server 2005 64 bit.
Not including TEMPDB.
Is there any point(s) or fact that i should be aware of before I decide on space requirements for system databases(not including TEMPDB). and what should be recommended space keeping in mind the future growth for system databases.
or any factor(s) that can trigger size increase in them.....!
Many Thanks,
View 4 Replies
View Related
Mar 28, 2007
Hi, i use sql server 2005 express where i created several databases. When opening Management Studio, i can see, besides my databases, also Master, Model etc .. which manage the databases. Now i also use MDF files which are disseminated on the same server. I see that for one given user, there is also a Master, Model etc ... in c:document and settings hat user .....
My question is: are those local Master, Model etc ... related with the central Master, Model ... of the central database system or are they independant? What if i delete the MDF files and its related system files in c:.doc and settings.. ?
Thanks
View 2 Replies
View Related
Apr 20, 2007
Hi Guys,I've been thinking about a normalised schema for a folksonomy syetem for my site. I'm fairly sure this is a good way to do things, but I have a coupld of questions... firstly, here's a quick low down on planned schema: Usersuser_idetc.Itemsitem_iditem_descetc.Tagstag_idtag_textItemTagstag_iduser_iditem_id Okay, now here's the thing. Obviously this is quite a normalised schema. I can retrieve all of an item's / user's tags easily. What I'd need to be able to do is return the list of tags and count for each item (perhaps just an item at a time).I can't really see any problems with this right now. But what happens if I have millions or Billions of rows. What's the proper way to retrieve tag counts for a huuuge set of data. I don't neceserrily need to implement something, but I'd quite like to know how one would get around the performance aspect of such a huge table. Ideas are welcomed greatly..Thanks.
View 3 Replies
View Related
Jun 3, 2007
Hi, I m using ASP.NET with C#. I m having one field which should store the datetime of the system. The datetime should be automatically stored for that entry when the user submits that record on the click event.Then it should display the date time on the gridview from database.I m using sqlserver 2005 and i have created the stored procedure for the insert command.This
is the sample sp what should be written here to insert system date time
automatically when the user submits the asp.net form ?Is there any code for writing directly in stored procedure or asp.net coding page... ALTER PROCEDURE [dbo].[StoredProcedure1]@salesid INT OUTPUT,@salesdate datetime,@customername varchar(20)ASBEGINSET NOCOUNT ONBEGIN INSERT INTO sales (customername) VALUES (@customername) SELECT @companyid = SCOPE_IDENTITY()END SET NOCOUNT OFFEND Thanxs in advance...
View 2 Replies
View Related
Sep 17, 2001
I am new to SS7. We are planning to rearrange our system databases so that the logs are on one drive
and the data files are on a different drive. I found a really good white paper on this but just want to
verify that there is not a problem with doing this. In sybase there were some restrictions on doing this.
Any info you have would be appreciated.
View 3 Replies
View Related
Sep 19, 2002
Is this possible? If so, how is it done?
View 1 Replies
View Related
Oct 30, 1998
I got the following error msg last night, in fact running anything in a query window. My solution was to stop and restart the SQLServer, but not ideal in a production environment. Anyone know what the cause/solution could be?
TIA, Neil
sg 910, Level 17, State 1
Could not allocate a new object descriptor for required system catalog in database '1'. Another database must be closed or objects in another database dropped in order to open this database.
Msg 2812, Level 16, State 4
Stored procedure 'sp_who' not found.
View 1 Replies
View Related
Jul 13, 2004
I am trying to import tables from my access database.
1st trying simple table, In ent mgr i right clicked the db folder
all task
import data
data source : Microsoft access
file name : c:Data Management SystemDMS.mdb
User name : mike (same used for lonin in access)
password : (same used for lonin in access)
advanced button:
jet Oledb: System database c:Data Management SystemSecured1.mdw
windows authentication
server (local)
database New -> dms
copy tables
now i see the items in my access database so i am guessing every step so far was correct
hey it worked !
ha,, hope u dont mind if i leave this here for anyone else, i ansd my own ?
View 2 Replies
View Related
Feb 27, 2007
SImon writes "I'm unable to take a user database offline because there are system process using it and I can't identify or kill the system processes"
View 1 Replies
View Related
Nov 13, 2007
Hello to all out there
I want to design a database for an Email system.
Two options are coming to my mind
1) Whether I will go with a separate table for each user which will contain in each field information like MSGid, recipient, sender, subject, message.
2) or I will maintain the information in a single table for each user.
I am not able to comprehend the pros and cons of each solution above.
Please help.
View 3 Replies
View Related
Nov 29, 2007
Hi,
We have a situation where somehow several of the system databases are owned by an ID of a person no longer with the organization. This triggers a few questions: If I disable the user (it's a SQL account, not domain), will that cause any issue? What is the correct way to change the user of a system database?
View 2 Replies
View Related
Mar 31, 2008
I am creating a linked sever from Informix server to SQL server 2005.
And it is giving me the error of database not found or no system permission error. While my DSN is working find and test connection successed what could be the reason ?
can any body help. below is the error
Cannot initialize the data source object of OLE DB provider "Ifxoledbc" for linked server "LIBRARY".
OLE DB provider "Ifxoledbc" for linked server "LIBRARY" returned message "EIX000: (-329) Database not found or no system permission.". (Microsoft SQL Server, Error: 7303)
View 7 Replies
View Related
Dec 10, 2007
Hi All,Can anyone explain me, why we have Resource and Distribution SystemDatabase in SQL Server 2005. Whether they were also available inprevious versions also.Thanks in Advance.Regards,Om
View 1 Replies
View Related
Mar 19, 2007
Hi
We are using in our company an ERP system called iScala.
This software is using SQL server as DBMS.
We would like to use the SQL mirroring feature from SQL 2005.
The software is using the SQL server instance name to connect to databases and when the Main SQL server fails the application can't connect to the Mirror instance.
Unfortunatelly we can't change the connection string (the software is provided by another company).
Do you have a solution?
Thanks
View 7 Replies
View Related
Nov 22, 2006
Dear Friends,
I want to insert in my database, in a table field the system time value on that moment.
For example: I want to create the follow stored procedure:
CREATE PROCEDURE TEST
@ID INT
AS
UPDATE TABLE1 SET MyFieldTime=@MySystemTime WHERE MyFieldID=@ID
I want to save in my database th system time...
Thanks!!
View 4 Replies
View Related
