Auto Close And Auto Shrink
what is Auto Close and Auto Shrink used for?
these can be used for large web sites? like portal?
View Complete Forum Thread with Replies
Related Forum Messages:
Why Msde Db Auto Shrink?
I am using MSDE in sql server 2000. When the database data file size exceed 2G limit, I tried to shrink the db and it reduced by about 100MB. 2 days later, I checked the db data file size and it was reduced to 550MB, which is 1/4 of the original db size! Please kindly explain the reason of this case, and how can it be monitored effectively? Thank you.
View Replies !
Scripting The Auto-shrink To Value 0
I would like to do an update statement to set auto shrinks to zero. A value of one means they are on. I have been using this select statement and manually changing them, but can't use it in a where clause. select name, databasepropertyex(name, 'isautoshrink') shrink from master.dbo.sysdatabases I would like to do "where shrink = 1", but it won't work. Any suggestions?
View Replies !
Log File Auto Shrink Question
Hi, I am trying to automate shrinking the transaction log file on SQL server. Every so often we get errors with our application using SQL server, in which I resolve by running the backup log and shrink log commands. However, recently I got the error: Could not allocate space for object 'table_name' in database 'database_name' because the 'Primary' file group is full. To resolve this I had to create another transaction log and then run the backup log and shrink log commands. I know need to automate the process of shrinking the log file. I have checked and the Auto Shrink checkbox is ticked but these errors still occur. How can I delete the additional log file I created and automate this task of shrinking the log file within SQL server? Any help would be appreciated...Thanks
View Replies !
Setting The Auto Shrink Flag
Hi, I recieved an alert that says 'The Auto Shrink flag for database is not set according to best practice.' Can anyone tell me where I can find this flag and what it shoul dbe set to? Thanks Af.
View Replies !
Torn Page Detection And Auto Shrink: Performance?
Hello everybody,First: SQL Server 2000 sp3a, HP cluster server, MS 2003 server,database recovery model simpleTorn page detection:When I have this option turned on, processes conected with updating andwriting in database, was MUCH more slower, than if I've this optionturned off.It seams to me, that when this option is turned on, the sqlserver ismuch more slower by any operation connected with writing, than withoutthis option.This option is required for ensurance, that the data are writtenproperly on the media.My question is:if I have my database running under cluster, with RAID hd system, whichcontains write cache, with additional checking, that the data will bewritten correctly, is it necessary for me to keep this option turnedon?Auto shrink:When it is turned on, does it affect performance?Personaly, I don't think so, but somebody is insysting on it, and Iwould like to have an information from independent source about that.Best regardsMatik
View Replies !
Ssrs - Auto Time And Auto Updates In Report
My report in SSRS does update only when i run that query in MS access. I migrate the 97 database to 2003 ms access database. I imported that report in ssrs using import tool in ssrs. i have set up shared data sources using odbc connection to ms access database. auto refresh works only when i manually run query in ms access. Here's my query....it has several table. SELECT Call_Completed_by_Engineer_Daily.FullName, Call_Completed_by_Engineer_Daily.[Remaining Calls], Call_Completed_by_Engineer_Daily.[Fairfax Calls], Call_Completed_by_Engineer_Daily.[SystemS Calls], Call_Completed_by_Engineer_Daily.[AACPS Calls], Call_Completed_by_Engineer_Daily.[NSN Calls], Call_Completed_by_Engineer_Daily.[MVA Calls], Call_Completed_by_Engineer_Daily.[Other Calls], Call_Completed_by_Engineer_Daily.[Total Calls], Call_Completed_by_Engineer_Daily.[All Tech], Call_Completed_by_Engineer_Daily.Department FROM Call_Completed_by_Engineer_Daily WHERE (((Call_Completed_by_Engineer_Daily.FullName) Not Like 'Jim Rowland*' And (Call_Completed_by_Engineer_Daily.FullName) Not Like 'Bill Bockmiller*' And (Call_Completed_by_Engineer_Daily.FullName) Not Like 'Hong Nguyen*' And (Call_Completed_by_Engineer_Daily.FullName) Not Like 'Hossein Talaei*' And (Call_Completed_by_Engineer_Daily.FullName) Not Like 'James Hawkins*' And (Call_Completed_by_Engineer_Daily.FullName) Not Like 'Joe Cooley*' And (Call_Completed_by_Engineer_Daily.FullName) Not Like 'Peter Threatt*')); This is a final query that i am getting report from. They are other queries that grab the information from table. For example, FullName query - Remaining Calls - Fairfax Calls...... FullName Remaining Calls Fairfax Calls SystemS Calls AACPS Calls NSN Calls MVA Calls Other Calls Total Calls All Tech Department Jay Brittain 10 4 4 JB DC Jeremy Ditto 2 2 1 3 JD DC Jing Kenny Hu 8 1 1 1 3 JKH DC Phone Soe 11 1 2 3 PS DC This is datasheet view of that query. I imported access report to sql reporting service. i can see it that report in web server too. However, i have to hit refresh every time. Can you tell me where to set up time? i want autorefresh time with all auto updates information. can anybody tell me plz?
View Replies !
Default &"Auto Close&" To No For Entire Server?
I was having this problem:http://groups.google.com/group/micr...78?dmode=sourcewith it taking an inordinate amount of time to enumerate the databaseson my local SQL Server instance, so I went through all the localdatabases and unchecked "Auto Close" on the "Options" tab of theDatabase properties in Enterprise Manager.This cleared up the problem nicely. In EM or through SQL-DMO, thedatabases on the local server enumerate quite quickly now. However, anynew databases that are created have "Auto Close" checked, so eventuallythe original problem will resurface.Is there some way to tell SQL Server to create any new databases with"Auto Close" set to No?
View Replies !
SQL XML - Using FOR XML AUTO
In SQL Server 2000, is it possible to create an xml document in memory within a stored procedure (say, with FOR XML AUTO)? The resulting xml from such a call is not a string, so you can't use it as the input parameter for sp_xml_preparedocument. Any ideas?
View Replies !
Using For Xml Auto
Does anyone know how to use for xml auto that will format an xml response to show the parent/child relationships? I currently have the parents and children in a temp table and can only get a formatting so that each one is returned at a parent. how can i select the results from the temp table so for xml auto will return the properly formatted xml file? this is also for the TreeVeiw control.
View Replies !
FOR XML AUTO SQL 2K Vs 2K5
The upgrade adviser for for 2k5 says something about derived tables being handled differently between 2k and 2K5 and it says to query the tables directly but this does not seem to make much sense because I thought FOR XML AUTO just created some generic XML for presentation purposes. These 2 stored procedures that it is complaining about do query the tables directly and they use the FOR XML AUTO to control the output.Does anyone know if I have to worry about this? I am tempted to let this slide and check out this part of the application after the migration happens tomorrow for QA to start testing.Yes I have been googling, checking my books and digging around in BOL. I am not seeing anything.DISREGARD: I found my derived table. It appears to change the output of the XML. Perfect.
View Replies !
For Xml Auto
I know that you cannot insert into a table the result of a select query where you have a for xml auto instruction, I run this query in the query analyzer tool and there is the output I need to save in somewhere in the database, The documentation of the beta 2 of SQL Server 2k say that it is impossible, so I want to know 2 things: first, How can I store somewhere the result of a select .. for xml auto and second if it is impossible for what is this feature installed in SQL Server 2k Thanks
View Replies !
Auto Increment
DIAGID is the field in database which is integer. i want to increment this when page is loaded.but it is not working.. plz find mistake ... thanks in advance SqlCommand sqlCmd = new SqlCommand("Select max(DIAGID) from tblDxactual", sqlCon); SqlDataReader sqlDr; sqlCon.Open(); sqlDr = sqlCmd.ExecuteReader(); if (sqlDr.Read()) { txtbxDiagID.Text = sqlDr[0].ToString()+ "1" ; } else txtbxDiagID.Text="1"; sqlCon.Close();
View Replies !
Auto Delete?
is there a way to auto delete all the record that is more than 1 month old compare to the date field in that table.
View Replies !
Auto Counting In SQL
Hi all, I would like to have my SQL statement result to return an additional "column", automatically adding an "auto-increasing" number with it. So if I for example select all Dates older than today's date, I would want something like this: 1 10/12/2006 2 10/18/2006 3 10/20/2006 4 10/22/2006 5 10/30/2006 Keep in mind that it's not my intention to fysically insert the "counting" column into the table, but rather do it "virtually". Is this possible? And if yes, how ? :) Thanks in advance Nick
View Replies !
Auto SQL Mail
Hi, I have to generate mails automatically based on databse (SQL SERVER) table,In that table we have expirydate as one column and based on expirydate I have to generate the mails automatically,Please guide me to solve this issue. where we have to run the stored procedure. Do we have to use jobscheduler? please guide me how to use it Thanks in avance regards, Raja.
View Replies !
Format Of For Xml Auto
I am using sql server 2000 and want to know how to get xml out of the database that looks like this using for xml auto <Clients> <Client ID="1"> <Employer="Company1" /> <Employer="Company2" /> <Contact type="phone"> <contact type="email" value="test@test.com"> <contact type="phone" value="555-5555"> </Client> <Client ID="2"> <Employer="Company3" /> <Employer="Company4" /> <Contact type="phone"> <contact type="email" value="test@test.com"> <contact type="phone" value="555-5555"> </Client></Clients> The problem I am having is that Contact is nested inside employer when I select Employer before Contact and the opposite happens when I select Contact first. They both join to the Client table so I would assume they both should nest directly under Client. How do I get different fields to nest directly under the same element like above?
View Replies !
MS SQL 05 Auto Increment
Hello, Firstly Hello to everyone I'm new the forum and fairly new to .net I'm working on web datbase application using visual studios 05 and MS SQL05 I've used 2003 (briefly) before but 2005 is very new to me. To my problem I download the GUI interface from microsoft so I can now setup a local database and do my own testing. I have created the table and fields with in it however on a particular table i have made a primary Key and left it as an INT but I would like to set it as auto increment ! I dont know how to select that option as i was used to mysql way of doing things or does this have to be done as a stored procedure ? Any assistance much appreciated.
View Replies !
Auto Email
Hi All, I want to write a console application to send email. There is a Date field in the SQL Server and I need to send email 2 weeks before that date.I have no idea how to write a console application and make it work.Does anybody have code for this? If so please post it. Thanks a lot, Kumar.
View Replies !
MS-SQL: Where's Auto Increment?
It's been a long time since I've had to check an index for the highest value, then add 1, to create a new unique key. These past few years, it seems this is usually done for you. But now that I'm working with MS-SQL, I don't see it. Is it there? It's doesn't seem to be inherent in the definition.
View Replies !
Auto Numbering
Hello,For analyses and reporting I would like to add a 'ranking' to atable/view.Example:Using the 'order by desc' clause in query I get a list of Customersordered by Turnover (descending). I would like to add that rankingnumbers (same as recordnumbers) in the query. I would like to have thefollowing result:Cust_nr Cust_Name Turnover_2004 Ranking002234 Bayer 139.000 1003456 Rentokill 123.456 2001231 Air France 105.000 3etc.When the 'ranking' is part of the query/table I can use this ranking inan other query.Important: This questions is not about making an (empty) table structurefor filling in by an application and generating a new unique number eachtime a record is added.I hope you can help me.Thanks,Hans*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View Replies !
Auto Number
Hi,I want to create a random unique auto generated number. dont wantto use GUIDs. Any other way to create it in isert statement itself,apart from storing a number in a table and increment while inserting.Help me!
View Replies !
Auto Documenter
I was wondering if sql server 2000 has an auto documenter utility thatcan dump information about a database into a word, excel, or textfile. I would not need anything to complicated just table, fields,types, sizes, and maybe indexes.Currently I am just exporting my tables into access, and then usingthe auto documenter in access to get at this information. This worksbut the field types do not match exactly, and when the tables getlarge this is no longer a valid solution.Thanks,Charlie
View Replies !
Auto E-mails
Hello, I have a SQL server though a hosting company and I am trying to send autoemails using xp_sendmail. The permissions were set and I used the following command to test it. EXEC master.dbo.xp_sendmail @recipients='tracey@yahoo.com',@subject='test',@me ssage='testing sql stored procedure' It gave me a message saying "Mail sent" but there none in my e-mail box. How do I set yp the SQL Mail server, right? Please help. I don't know what is happening. Thanks, Tracey
View Replies !
Auto Increment
I would like to avoid using a cursor. I am updating several rows in a table with sequential numbers starting at a number I pass into the Stored Procedure. Is there a way to do this with one update statement? Thanks, Ken Nicholson Sara Lee Corporation
View Replies !
Auto Number
can anyone give suggestions how to generating a number starting with certain numbers, example 33###, because when i insert new record into datatabase i want the number start 33111, or something and next record is 33112 thanks
View Replies !
Getting The Auto Value From Trigger
Hi all, My requirement is to get the autoincrement column once a new row is inserted, we need the autoincrement value to update other tables, at present I am using an insert trigger in which I am extracting the autoincrement column from the 'inserted' table, but how far this work perfectly when multiple users insert simultaneously. Can any of you suggest me the best way to extract the actual value inserted. Now the scenario is : sp which insert a row Begin tran insert ... select @returnKey = (select retkey from #temptab) drop #temptab Commit Tran Trigger on insert insert idcolumn into #temptab select autokey from inserted If user A & B inserts row exactly at same time, will this method return the exact auto value what A and B have inserted to them respectively. Thanks in Anticipation Raj
View Replies !
Auto Increment.... Key's... Etc..
I am very new to using SQL server 7. I've always used mysql in the past. I cant figure out howto create a autoincrementing key for my tables... is it possible to do in SQL7?? If so.. how.. i thought you just set the datatype to auto increment etc... sorry for any oversights... dave
View Replies !
Help! Log Is Auto Shrinking Itself
HiRunning SQL 7 sp3 on NT 4 I have a database that has the auto shrink option turned OFF. However, the log file seems to auto shrink after the user runs bulk insert. The log file is not setup to auto grow either.Any ideas. Thanks, Tariq
View Replies !
Auto-Increment
Hey, Here is what happened: Users for a long time have been able to post new topics in our forums. However, a short time ago, the some users began to experience problems. What I have narrowed it down to is that upon inserting into the table, sometimes id value for the topic is the same as an id that is already in the table, so it fails to insert the record (due to a constraint). However, the topic id column is an auto-increment column and should just assign the next number for the id value. Any ideas?
View Replies !
Auto Incrementing
Hi I'm using a insert into fuction kind of like below INSERT INTO table1( col1 col2 col3 col4 ) SELECT col2 col3 col4 FROM ............... I'd like to auto-increment col1 so it counts how many rows are being added any help is very appreciated
View Replies !
Auto Increment
Hi, I have one table: Appid | Cols 1 | xx 2 3 In this table Appid is the primary key. I want to change the Appid column as Auto increment column. How to change the appid to Auto increment with data in that column. Is it possible? Thanks in advance
View Replies !
Auto Stats
Hi all, I have an dtsx (SSIS) for "clone" manually Sql server database to another. How I copy all stats from one database to another ? I have problem with "auto stats". When I try DROP statitics for auto stats I get this error: No se puede DROP el Ãndice 'dbo.ACTIVIDAD_PROVEEDOR.PK_ACTIVIDAD_PROVEEDOR'. No es una colección de estadÃsticas. Cannot DROP index 'dbo.ACTIVIDAD_PROVEEDOR.PK_ACTIVIDAD_PROVEEDOR'. Not statitics collection. What can I do ?? -- Get Stats list SELECT '[' + SCHEMA_NAME(tbl.schema_id) + '].[' + tbl.name + ']' AS [Table_Name_With_Schema], '[' + st.name + ']' AS [Name], '' + SCHEMA_NAME(tbl.schema_id) + '.' + tbl.name + '' + '.' + st.name + '' AS [Estadistica] FROM sys.tables AS tbl INNER JOIN sys.stats st ON st.object_id=tbl.object_id ORDER BY [Table_Name_With_Schema] ASC,[Name] ASC Thanks in advance, any help will be appreciated, regards, greetings
View Replies !
Auto Stats
Hi all, I have an dtsx (SSIS) for "clone" manually Sql server database to another. How I copy all stats from one database to another ? I have problem with "auto stats". When I try DROP statitics for auto stats I get this error: No se puede DROP el Ãndice 'dbo.ACTIVIDAD_PROVEEDOR.PK_ACTIVIDAD_PROVEEDOR'. No es una colección de estadÃsticas. Cannot DROP index 'dbo.ACTIVIDAD_PROVEEDOR.PK_ACTIVIDAD_PROVEEDOR'. Not statitics collection. What can I do ?? -- Get Stats list SELECT '[' + SCHEMA_NAME(tbl.schema_id) + '].[' + tbl.name + ']' AS [Table_Name_With_Schema], '[' + st.name + ']' AS [Name], '' + SCHEMA_NAME(tbl.schema_id) + '.' + tbl.name + '' + '.' + st.name + '' AS [Estadistica] FROM sys.tables AS tbl INNER JOIN sys.stats st ON st.object_id=tbl.object_id ORDER BY [Table_Name_With_Schema] ASC,[Name] ASC Thanks in advance, any help will be appreciated, regards, greetings
View Replies !
Auto Key Generation
Hi, Can any one tell me how can I create auto number (similar feature to MS Access) i.e. autmatic increament by 1 in MS SQL 2005 (without using any script)
View Replies !
Auto Run Report
Hello Anyone know if any of the following are possible: Change the icon for a report in the report manager. I want a report to have a folder icon, so it therefore looks like a folder. When a user opens a folder, have a report automatically run and display. Have a report automatically open when the user opens the report manager. Cheers
View Replies !
Auto Numbering
I have created an ID column for auto numbering, but in the properties, they didn't have the option of setting it to auto numbering, and how am i suppose to set or code it to autonumbering. Please and thankyou
View Replies !
Auto Install
Hi, I distribute a VB application that uses an SQL Express database. Can anyone recommend some installation software that will install .NET, msxml6, SQLExpr & SQL Management Studio, whilst allowing configuration of SQLExpr?
View Replies !
Auto Increment In SQL
Hi. Am creating a database in SQL and one of the field of my table is customer_id. I want this customer_id to be auto generated and auto increment. I was reading about Identity but it was too complicated to grasp. So how can that be done in a very simple way. Thanks
View Replies !
Auto Delete
Hi, I want to delete automatically all the fridays 11 Pm the complete content of my table. How do I to do this? Sorry my stupid question but I dont have idea how to do this. Mjolnir.
View Replies !
Create Auto ID
I created a table with a field called myID. I set the data type as "uniqueidentifier", but it won't auto generate. How do I create a field to auto generate a unique number? I'm working with SQL Server 2000 and I'm creating the table from Enterprise Manager.
View Replies !
|
TRACKER
