Related posts about sqlserver2005

• SqlServer2005 Enterprise Fast Recovery, SqlAgent Availability, and Replication

  as seen on Server Fault - Search for 'Server Fault'
  I have a database under SqlServer2005 Enterprise 64bit sp3, that is in phase 3 of 3 of recovery after a reboot without normal shutdown. It looks like with fast Recovery, the database became available when recovery moved into phase 3. However, it seems (based on message in SqlAgent log), that SqlAgent… >>> More

• "select * from table" vs "select colA,colB,etc from table" interesting behaviour in SqlServer2005

  as seen on Stack Overflow - Search for 'Stack Overflow'
  Apology for a lengthy post but I needed to post some code to illustrate the problem. Inspired by the question What is the reason not to use select * ? posted a few minutes ago, I decided to point out some observations of the select * behaviour that I noticed some time ago. So let's the code speak… >>> More

• deleting records from multiple tables at a time with a single query in sqlserver2005

  as seen on Stack Overflow - Search for 'Stack Overflow'
  Hi I wanna delete records from child tables as well as parent table with in a single query. please find the query given below. here response header is the primary table and responseid is the primary key. DELETE FROM responseheader FROM responseheader INNER JOIN responsepromotion ON responseheader… >>> More

• My log file is so big, after truncate it 2 days, it still big like before

  as seen on Server Fault - Search for 'Server Fault'
  I'm using sql server 2005 and the log is too big 23 gbs (if you compare with the data file only 8GB). I've already run the truncate, after that the log file is 24mb but after 2 days, it becomes 23gbs. My database is full backup mode. I have the maintain plan is 2 hours will have diff backup and 24hours… >>> More

• Facing problem in configuring Reporting Server

  as seen on Server Fault - Search for 'Server Fault'
  Dear All, I am unable to configure reporting server with sql server 2005 express edition. I have posted the link of a screen shot which shows the status.when ever i go to configure the reporting services it gives me the following errors(see screen shot)...also unable to start the reporting services… >>> More

Related posts about truncate

• SQL SERVER – Rollback TRUNCATE Command in Transaction

  as seen on SQL Authority - Search for 'SQL Authority'
  This is very common concept that truncate can not be rolled back. I always hear conversation between developer if truncate can be rolled back or not. If you use TRANSACTIONS in your code, TRUNCATE can be rolled back. If there is no transaction is used and TRUNCATE operation is committed, it can not… >>> More

• SQL SERVER – Securing TRUNCATE Permissions in SQL Server

  as seen on SQL Authority - Search for 'SQL Authority'
  Download the Script of this article from here. On December 11, 2010, Vinod Kumar, a Databases & BI technology evangelist from Microsoft Corporation, graced Ahmedabad by spending some time with the Community during the Community Tech Days (CTD) event. As he was running through a few demos, Vinod… >>> More

• Postgres: Reduce varchar size and truncate

  as seen on Stack Overflow - Search for 'Stack Overflow'
  I currently have a Postgres 8.4 database that contains a varchar(10000) column. I'd like to change this into a varchar(255) and truncate any data that happens to be too long. How can I do this? >>> More

• How to truncate a table with Spring JdbcTemplate?

  as seen on Stack Overflow - Search for 'Stack Overflow'
  I'm trying to truncate a table with Spring: jdbcTemplate.execute("TRUNCATE TABLE " + table); Get the error: Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [TRUNCATE TABLE RESULT_ACCOUNT]; nested exception is java.sql.SQLException: Unexpected … >>> More

• Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?

  as seen on Stack Overflow - Search for 'Stack Overflow'
  Using MSSQL2005, Can I truncate a table with a foreign key constraint if I first truncate the child table(the table with the primary key of the FK relationship)? I know I can use a DELETE without a where clause and then RESEED the identity OR Remove the FK, truncate and recreate but I thought as… >>> More