Which File Store Startup Parameters?
Jul 20, 2005or in registry? where?
View 8 Replies
ADVERTISEMENT
Startup Parameters...
Sep 3, 2003We have a STD SQL2000 with 2GB memory, which has around 800 databases and is planed to have 1500 databases.
From Microsoft Knowledge Base Q316749, <<By using the -g startup parameter, you can instruct SQL Server to leave additional virtual memory available so that the combination of these log-related allocations and other normal allocations does not run out of virtual address space.>>
but we are not quite sure the correct sytax, so we added -g392 and -g 392 as two new startup parameters. After reboot, in the error log, "initdata: Warning: could not set working set size to 765696 KB.
1. Is this a good way to increase the virtural memory?
2. which system table contains the -g value? and how to fix this error?
thanks
-D
Startup Parameters
Sep 25, 2003Please Advice
I started my SQL SERVER 2000 (SP 3)in single user mode using EM with the purpose of doing a test restore of the Master database. Can i remove the startup parameters as I cannot login using sa or similar login using ISQL/W utility.
Thanks for your help. Urgent.
Regards
Question On Changing Startup Parameters
Sep 22, 2006I'm new to SQL Server....running SQL Server 2000. Had to move the system database logs to a different drive. Used EM, Server properties, Startup parameters. Changed the transaction log designation. Closed that window. Stopped the server.
Server won't start as I messed up and did not include the file name in the new designated path....just down to directory level.
From what I've seen, I have to be able to start the server service to change the parameters and the server won't start.
Is there a file that contains these parameters I may edit or should I try using the command line options.
Many thanks in advance.
SQL Server 2005 - Change Startup Parameters
Oct 6, 2007Hi,
I installed SQL Server 2005 Enterprise Edition and then executed SP2. So, when I try to move master database to another place, I don't obtain to change the Startup Parameters, because the instance SQL Server (MSSQLSERVER) in SQL Server 2005 Services in the SQL Server Configuration Manager isn't shown. I observed that if not execute the SP2 the instance SQL Server (MSSQLSERVER) is shown.
What it can is happening ?
Somebody knows some thing on this?
Please, somebody could help me ?
Thanks,
Antonio
Server Startup / 100 % Cpu Utilization While Recovering Database @ Startup
Dec 7, 2000database : MS SQL server ver 6.50.201
problem: server startup / server time out
details
SQL server shows usage of 100 % CPU utilization, if started automatically / manually. and does not proceed / hangs up(server time out), but win nt operates extremely slow.
The background of the situation in brief is as stated below.
The errorlog was found to have the messages
warning : OPEN OBJECTS parameter may be too low.
Attempt was made to free up descriptors in localdes()
Run sp_configure to increase parameter value.
Error : 644, severity : 21, state; state 1
the non clustered leaf row entry for page 2 row 1 was not found in index page 40 indexid 2 database 'tempdb'
Error : 2620 severity 21 state 3
the offset of the row number at offset 32 does not match the entry in the offset table of the follwoing page : page pointer = 0x1395800, page no= 40, status = 0x2, objectid = 1, indexid = 2
Action taken
I used the sp_option to increase the open objects from default 500 to 1000, and the LE threshold maximum value to 400 from the default 200.
after which I used reconfigure go and restarted the computer to take the effect. The following did work fine and server was working ok. But then from yesterday I am having the problem that the MS SQL sever is utilizing the cpu to 98 - 99 % and I am not able to connect to the server.
I tried to start the server with the minimal configuration by specifying the -f option in the service manager start up options, it showed the following message
00/12/07 10:40:49.73 ods Unable to connect. The maximum number of '5' configured user connections are already connected. System Administrator can configure to a higher value with sp_configure.
00/12/07 10:40:50.02 ods Unable to connect. The maximum number of '5' configured user connections are already connected. System Administrator can configure to a higher value with sp_configure.
afterwhich I tried with the option of starting the sql server with the option -c -f
which in the event detail of the win nt shows
"mesg 18109: Recovery dbid 6 ckpt(55813,8) oldest tras= (55813,0)"
The open procedure for service "MSSQLServer" in DLL "SQLCTR60.DLL" has taken longer than the established wait time to complete. The wait time in milliseconds is shown in the data.
DB-LIBRARY error - SQL Server connection timed out.
and in the errorlog present in MSSQLLOG directory
00/12/07 15:06:43.24 spid1 Recovering Database 'master'
00/12/07 15:06:43.31 spid1 Recovery dbid 1 ckpt (7944,28) oldest tran=(7944,0)
00/12/07 15:06:43.41 spid1 1 transactions rolled forward
00/12/07 15:06:43.49 spid1 Activating disk 'AM'
00/12/07 15:06:43.49 kernel initializing virtual device 1, D:MSSQLDATAAM.DAT
00/12/07 15:06:43.50 spid1 Activating disk 'AMLOG'
00/12/07 15:06:43.50 kernel initializing virtual device 2, D:MSSQLDATAAMLOG.DAT
The dbid is / was 6 for both the instances, the database which is having this dbid is database name "AM" and is having above 1300 tables (approx)
what could be the problem and solution for it?
kindly help me out of this situation.
If any more information is needed please contact me on devendrakulkarni@yahoo.com / devendra@me.iitb.ernet.in
Regards
Devendra
Run Batch File At Server Startup
Oct 10, 2014how do I schedule a batch file I've created to run at the startup of the server? Windows 2003 server.
View 3 Replies View RelatedProblem With Store Procedure - Too Much Parameters
Jan 2, 2008Hi,I actualy have another problem with a store procedure. By runnuing a aspx-Site I was toldthat there were to much parameters given for transfering data to the store procedure. Thisparamter I have:ArtikelID, NewsID, Ueberschrift_D, Ueberschrift_E, Text_D, Text_E all are defined within a <asp:SQLDatasource> as <asp:parameter..> within <UpdateParameters>When I kill all parameters I was told that the @ArtikelID-Parameter was not declarated. If I havedefined all parameters expect the Text_E I was told that the @Text_E-Parameter was not declarated.When I declarate the Text_E-Parameter as last parameter that should be nessessary I get the abovementioned error-message.What can be wrong?Regards
View 6 Replies View RelatedHow To Get Store Procedure's Return Value And Output Parameters From BLL?
Oct 10, 2007ex:
myprocedure(@Cusname varchar(50), @Cusid int output)as
Insert into Customer(Cusname) values (@Cusname)SELECT @cusid = @@IDENTITY
i add the query to my adapter called CreatCustomer (@Cusnam,@Cusid)private Merp_CusListTableAdapter _CuslistAdapter = null;protected Merp_CusListTableAdapter Adapter
{
get
{if (_CuslistAdapter == null)
_CuslistAdapter = new Merp_CusListTableAdapter();return _CuslistAdapter;
}
}
Now how i write function in BLL to receive output paramter from creatcustomer function?
Store Into Database Report Parameters Values?
Feb 3, 2007Hallo
is it possible to perform an insert/update query upon the execution of a report, using the report Visual Basic expressions?
I mean, the user enters some values for the report parameters, and i would like to store them, along with the resulting recordset data, into a dedicated table in the database.
SQL 2012 :: Max Size Of File Which Store To DB By File Stream
Dec 5, 2014is there limitation for size of file to store in db by filestream in sql server 2008?or it accept all sizes?
View 1 Replies View RelatedTransact SQL :: Generic Store Procedure Call Without Output Parameters But Catching Output
Sep 21, 2015Inside some TSQL programmable object (a SP/or a query in Management Studio)I have a parameter containing the name of a StoreProcedure+The required Argument for these SP. (for example it's between the brackets [])
EX1 : @SPToCall : [sp_ChooseTypeOfResult 'Water type']
EX2 : @SPToCall : [sp_ChooseTypeOfXMLResult 'TABLE type', 'NODE XML']
EX3 : @SPToCall : [sp_GetSomeResult]
I can't change thoses SP, (and i don't have a nice output param to cach, as i would need to change the SP Definition)All these SP 'return' a 'select' of 1 record the same datatype ie: NVARCHAR. Unfortunately there is no output param (it would have been so easy otherwise. So I am working on something like this but I 'can't find anything working
DECLARE @myFinalVarFilledWithCachedOutput
NVARCHAR(MAX);
DECLARE @SPToCall NVARCHAR(MAX) = N'sp_ChooseTypeOfXMLResult
''TABLE type'', ''NODE XML'';'
DECLARE @paramsDefintion = N'@CatchedOutput NVARCHAR(MAX) OUTPUT'
[code]...
How To Store File In SQL DataBase
May 8, 2007please tell the steps
How to store File in SQL DataBase
How To Store And Retrive .DOC File In Sql
May 28, 2007Hi frds,
My question is how should i store a .DOC file in sql 2005 as image field and how to retrive the Doc stored in Image format
Thanks & regards
Sithender.s
Store A File Upload Into DB
Sep 10, 2007Can someone please direct me to a discussion on which version of SQL Server allows a file to be stored in a db field and how this is accomplished as well as how the file is then retrieved with asp.net VB from the DBthanksMilton
View 16 Replies View RelatedI Want A Suggestion How Store This File
May 11, 2008Dear all,,
I used a program that convert from powerpoint to flash
the output of this program is a folder that contain 2 folders and a HTML page
How can I store those in my database?
note: I have to use all of these folders to preview the flash
Thanks in advance
Store DOC/PDF File In SQLServer Using ASP.NET(with Vb.net)_
Jan 21, 2004Hi!
I want to store doc/pdf/image file in my SQL server2000 database. I have taken the field datatype in SQL SErver2k as "text".
Now I want to select a file in my project & want to store it in the DB using asp.net commands.
Can anybody tell me the procedure with a small example?
I have used FileInput to select the file .
thnx.....
Store HTML File In Sql
May 11, 2006How to store the html file in sql server data.
Converting SQL Qry Into XML And Store As XML File
Nov 22, 2001Hi There,
My requirement is to read from a table in SQL 2000 and need to export the
data in a XML format with .XML in a flat file.
I don't want to do to use ADO or VB or any other external tools to do this. I want it to be purely done using SQL server within enviroment.
How to generate this kind of XML files from
SQL server?.
Kindest regards,
Chris.G
What Directory Would Be Best To Store The .SDF File In?
Jan 13, 2006I am creating some applications for Windows Mobile 5.0 devices to be used internally at our company. Each device will run several home grown applications that will all share the same common SQL Mobile database.
What I am wondering is whether or not there is a standard path where such a database is typically stored in Windows Mobile 5.0. I see a folder called Application Data. Is that what it is for, or is that one for something else? I'm not real familiar with the layout of the Pocket PC in general. Could someone tell me where vendors normally put their database file(s)?
Thanks,
Brad
Store The Data From A Database Into A File.
Mar 22, 2008how to use class iDataReader's function getbytes(...............) to read binary data?
using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;using System.Data.Common;using System.IO;
public partial class uploadFileToDatabase : System.Web.UI.Page{ string strUser; protected void Page_Load(object sender, EventArgs e) { strUser=Request.QueryString["download"]; if(strUser!=null) { string strConn="Data Source=hao-pc;Initial Catalog=simpleBBS;Persist Security Info=True;User ID=sa;Password=123;Pooling=False"; SqlDataAdapter sda=new SqlDataAdapter(); DbProviderFactory dbProviderFactory=DbProviderFactories.GetFactory("System.Data.SqlClient"); DbConnection dbConn=dbProviderFactory.CreateConnection(); dbConn.ConnectionString=strConn; dbConn.Open(); DbCommand dbComm=dbProviderFactory.CreateCommand(); dbComm.Connection=dbConn; dbComm.CommandText="select * from userFiles2 where fileisn='"+strUser+"'"; IDataReader myReader=dbComm.ExecuteReader(); int strFileLen=0; if(myReader.Read()) { strFileLen=Convert.ToInt32(myReader.GetString(3)); FileStream afs; string fPath; fPath = Server.MapPath(Request.ApplicationPath) + "\upLoadFiles\" + myReader.GetString(1); afs = new FileStream(fPath, FileMode.OpenOrCreate, FileAccess.Write); Byte[] filedata = new Byte[strFileLen]; afs.Write(filedata, 0, strFileLen); BinaryWriter abw; int iBufferSize=1000; Byte[] outbyte=new Byte[iBufferSize-1]; long retval; long starIndex=0; abw=new BinaryWriter(afs); starIndex=0; int itemNum=4; retval=myReader.GetBytes(itemNum,starIndex,outbyte,0,iBufferSize); //when i store large data into a file it display an error such as "Buffer offset '0' plus the bytes '82452' is greater than the length of the passed in buffer. abw.Write(outbyte); starIndex+=iBufferSize; retval=myReader.GetBytes(itemNum,starIndex,outbyte,0,iBufferSize); } abw.Write(outbyte); abw.Flush(); abw.Close(); afs.Close(); myReader.Close(); dbComm.Dispose(); } } } protected void Button1_Click(object sender, EventArgs e) { string strFileName; string strFileType; int strFileLen; Random ran=new Random(); string strFileISN=DateTime.Now.ToString("yyyyMMddhhmmss")+ran.Next(0,999); if(FileUpload1.PostedFile.FileName!=null) { strFileName=FileUpload1.PostedFile.FileName; strFileType=strFileName.Substring(strFileName.LastIndexOf(".")+1); strFileName=strFileName.Substring(strFileName.LastIndexOf("\")+1); strFileLen=FileUpload1.PostedFile.ContentLength; string strConn="Data Source=hao-pc;Initial Catalog=simpleBBS;Persist Security Info=True;User ID=sa;Password=123;Pooling=False"; SqlDataAdapter sda=new SqlDataAdapter(); DbProviderFactory dbProviderFactory=DbProviderFactories.GetFactory("System.Data.SqlClient"); DbConnection dbConn=dbProviderFactory.CreateConnection(); dbConn.ConnectionString=strConn; dbConn.Open(); DbCommand dbComm=dbProviderFactory.CreateCommand(); dbComm.Connection=dbConn; string dateTime=DateTime.Now.ToString(); Stream fs=FileUpload1.PostedFile.InputStream; Byte[] filedata=new Byte[strFileLen]; fs.Read(filedata,0,strFileLen); dbComm.CommandText="insert into userFiles2 (fileisn,filename,filetype,filesize,filecontent,uploadTime) values (@fileisn,@filename,@filetype,@filesize,@filecontent,@uploadTime)"; dbComm.Parameters.Add(new SqlParameter("@fileisn", (object)strFileISN)); dbComm.Parameters.Add(new SqlParameter("@filename",(object)strFileName)); dbComm.Parameters.Add(new SqlParameter("@filetype",(object)strFileType)); dbComm.Parameters.Add(new SqlParameter("@filesize",(object)strFileLen.ToString())); dbComm.Parameters.Add(new SqlParameter("@filecontent",(object)filedata)); dbComm.Parameters.Add(new SqlParameter("@uploadTime",(object)dateTime)); dbComm.ExecuteNonQuery(); fs.Close(); dbConn.Close(); dbComm.Dispose(); dbConn.Close(); } } }
How Can I Store A Text File Into SQL Server?
Apr 6, 2004Hi,
Can some one give me some suggest?
Thanks!
How To Store And Read .doc File In A Table
May 10, 2006I would like to store and read .doc file in a table of sql server using C#.
Can some body help me on this? my id is padam76@gmail.com.
Thanks & Regard,Padam Kumar Tripathi
Store Proc & File System
Dec 21, 2001I was wondering if anybody can help me in a storeProc for SQL 7 which can get the realational tables frm a database and put them into filesystem...
Cheers
--Nik
Store File Prirefix With Date Value.
Sep 22, 2005Hi,
I need to export data from sql server into flat file. The file sould be generated with current date and table anem.
for example yyyymmddhhmmsstablename.txt.
Do you have any solution for this.
Thanks,
How To Store File Binary Content
Dec 3, 2007Hi,
I have never use sql server to store binary data. Now, I need to store a .doc file into it. Which column type I should adopt?
In addition, could you provide me related articles to study?
Thanks,
Ricky.
Store T-SQL Messages Inside A File
Nov 24, 2006Hi All,
I am writing a automated backup script using job scheduler of the management studio and would like to know how can i copy the output messages given by the SQL Server to an external file automatically.
Thanks in Advance
Mitesh
Import A Store Xml File Which Has Dtd Into Sql 2005
Jan 22, 2008I am trying to import a store xml file which has dtd into sql. The file is 97,211 kb. I want to get the data and columns into sql 2005. So far I have tried this:
DECLARE @xml XML;
use yahoostore
CREATE TABLE Products(xmlCol XML)
INSERT INTO Products(XmlCol)
SELECT
CONVERT(XML, BulkColumn, 2)
FROM OPENROWSET (BULK 'C:databasexmldtdyahoostore.xml', SINGLE_BLOB)AS X
This creates the table and only one column which takes a while to open, but I do not see anything in it.
Could someone please help with this problem. I have used openrowset and openxml and I am getting no where.
Thanks
Dee
Whats The Best Way To Store Filename / File Path?
Jan 20, 2004I'm guessing the best way / only way to store a filename is to store it as a varchar?
I'm using it as a reference to pictures wefor a gallery
How To Store File Attachments (text And Binary).
Nov 9, 2006I need to store several different types of documents (text, MS Word, PDF, etc.) in SQL Server 2005. What is the best way to store file attachments that have different MIME types?
Currently I'm using a table with a varbinary(max) column which works for binary files but not for text files. Do I need to have multiple columns in the table for different file types? Thanks in advance for your help.
CREATE TABLE dbo.[CM_Attachment] (
[Id] int IDENTITY (1, 1) NOT NULL ,
[Change_Request_Id] int NOT NULL ,
[Attachment] varbinary(max) not null,
[Created_Date] datetime NOT NULL DEFAULT GetDate() ,
[Created_By] varchar(30) NOT NULL ,
[Modified_Date] datetime NOT NULL ,
[Modified_By] varchar(30) NOT NULL
)
GO
INSERT INTO CM_Attachment(Change_Request_Id, Attachment, Created_By, Modified_Date, Modified_By)
SELECT 6, BulkColumn , '', GetDate(), ''
FROM Openrowset( Bulk 'C:TestingTest Doc #1.txt', SINGLE_CLOB) -- Does not work
-- FROM Openrowset( Bulk 'C:TestingTest Doc #2.xls', Single_Blob) -- Works
-- FROM Openrowset( Bulk 'C:TestingTest Doc #3.jpg', Single_Blob) -- Works
as ChangeRequestAttachment
IS There A Way To Store List Of Errors In Text File
Apr 4, 2007I want to attach a error list to my email task and i want my email task to send email only if there is an error...IS this possible..
View 8 Replies View RelatedStore Webservice Task Output To File
Feb 14, 2007Hi
I have designed a package that reads in rows from an Excel file into a recordset then loops through the recordset sending two parameters to a webservice task. This works fine however I now need to output the results of the webservice task to a file or recordset - I have tried outputting to a file however it only stores the last result as the file is overwritten each time - I am new to SSIS and am sure there must be a really simple way to do this but cannot find an help on how to do it !
Thanks in advance K
Images - Store In A Database Or File System?
Jun 19, 2007I have recently designed and built my first database using SQL server 2005 express. I have included an image (BLOB) column in one of the database tables. This is a bad idea according to some experts, and some say it is OK!
I am currently carrying out a trial with just 3 pictures via Visual Basic 2005 express forms, and there is no problem so far as the images are displayed for each record. But I anticipate between 300 - 1000 images for the table, and this could pose real problems for SQL server 2005 express and Visual Basic 2005 express, I guess.
I have just been reading that the cost of storing large images in the database is too high! I have also read it's better to store images (BLOB) into the file system because it is cheaper to store them no matter how many there are.
But the question is how I can reference an image in this path: C:PictureProductGrocery 0052745.jpg in the database table, so that when I select a record Visual Basic 2005 forms the image is displayed accordingly, similar as when stored directly in the database table? Your help very much appreciated.