Search Results

Search found 31 results on 2 pages for 'sqlserver2005'.

Page 1/2 | 1 2  | Next Page >

• SqlServer2005 Enterprise Fast Recovery, SqlAgent Availability, and Replication

  - by automatic

  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 is "started" but not available to run jobs…

  Read the article

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

  - by kristof

  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 for itself: IF EXISTS (SELECT * FROM…

  Read the article

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

  - by sudhavamsikiran

  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.responseid =…

  Read the article

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

  - by tranvinhnt

  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 will have full…

  Read the article

• Facing problem in configuring Reporting Server

  - by idrees99

  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.It starts and…

  Read the article

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

  - by tranvinhnt

  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 will have…

  Read the article

• DataTable identity column not set after DataAdapter.Update/Refresh on table with "instead of"-trigge

  - by Arno

  Within our unit tests we use plain ADO.NET (DataTable, DataAdapter) for preparing the database resp. checking the results, while the tested components themselves run under NHibernate 2.1. .NET version is 3.5, SqlServer version is 2005. The database tables have identity columns as primary keys. Some tables apply…

  Read the article

• SQL Server, temporary tables with truncate vs table variable with delete

  - by Richard

  I have a stored procedure inside which I create a temporary table that typically contains between 1 and 10 rows. This table is truncated and filled many times during the stored procedure. It is truncated as this is faster than delete. Do I get any performance increase by replacing this temporary table with a…

  Read the article

• How can I manage SQL CE databases in SQL Server Management Studio?

  - by Arul

  Dear all, I have Sqlserver 2005 Express Edition only. and VS 2005. How to i create my .sdf file. and how to create tables in that file... I am developing a SmartDevice Application. if any possible to access the Sql server 2000 DataBase without using .SDF file. Note: in my system i have VS 2005, SQL SERVER…

  Read the article

• Filling the missing gaps(Sql Server 2005) [Set based using recursive CTE]

  - by Thinking

  I have a table MissingData 1 10 NULL NULL 22 NULL The desired output will be MissingData 1 10 10 10 22 22 i.e. the nulls will be filled up by the previous value until a new value is appearing. I can solve this by using loop but my requirement is to solve it by CTE in which I am not so comfortable as…

  Read the article

• Timeout expired in sql server problem

  - by Avinash

  set con2=server.CreateObject("ADODB.Connection") con2.ConnectionTimeout =1200 con2.open "Driver={SQL Server};server=111.111.111.11;user id=xx;pwd=xxx;Database=xxx" con2.execute("DELETE FROM tablename WHERE fieldid NOT IN(SELECT fieldid FROM tablename2)") con2.close set con2=nothing when i running this…

  Read the article

• database importing problem with sql server

  - by tibin mathew

  Hi, I have a database working in mu local sql server 2005 express edition. I have to import my local dtabase to a remote servr database. For that i established connection to that remote server, and i can now see that database . but when i tried to restore database fro my local machine i'm getting an…

  Read the article

• SQL Self Join Query Help

  - by hdoe123

  Hi All, I'm trying to work out a query that self join itself on a table using the eventnumber. I've never done a self join before. What i'm trying to query is when a client has started off in a city which is chester to see what city they moved to. But I dont want to be able to see if they started…

  Read the article

• how to use conditional select query ? in sqlserver

  - by Arunachalam

  how to use conditional select query ? in sqlserver i have a column in which i store date type variable .now i should retrieve one value from that column and find the difference with the curent_timestamp and if the difference is less than 10 mins i should a return 1 and if more than 10 mins i…

  Read the article

• .Net installation issue with SqlServerPipelineHost and SqlServer.DtsMsg

  - by Melody Friedenthal

  I added a web service consumer to a vb 2005 Windows app and tried to install it on another computer, which had an earlier version already installed (ClickOnce deployment). An error came up saying I needed to install Microsoft.SqlServer.PipelineHist in the GAC. I added PipelineHost to the list…

  Read the article

• retrieving description item from sql server table column

  - by Pablo

  is it possible to retrieve by using connection.getschema() the description item from a sql server table column, just like it's possible to retrieve the column name, data type, is nullable, column default value, etc?

  Read the article

• connecting sql server 2008 from sqlserver 2005

  - by raj

  I am not able to connecting to the sqlserver 2008 from my sqlserver 2005....Is it really not possible to connect or there is some way.. please suggest me..if there is some thing.. Thanks.

  Read the article

• how to store a value returned from a sql query in a variable in batch programming ?

  - by Arunachalam

  how to store a value returned from a sql query in a variable in batch programming ? i can invoke sqlserver queries from my cmd prompt using sqlcmd server name then the qwery this is query statement i m going to use SELECT CASE WHEN DATEDIFF(minute, record_timestamp,…

  Read the article

• Storing images in a Microsoft SQL Server 2005 database

  - by Rekreativc

  Hello! I have a question about storing an image in a database. I know this topic has been discussed before, however I feel that in my case this is actually a good idea - the images will be small (none should be as large as 1MB) and there shouldn't be too many. I like the idea of not…

  Read the article

• Facing problem in configuring Reporting Server

  - by idrees99

  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…

  Read the article

• c# with mssql server 2005

  - by Raj

  How to calculate the customer age automatically by using their Date of Birth using c# and sqlserver2005

  Read the article

• JavaScript call to page method: error 500. JSON

  - by Ryan Ternier

  I'm using the auto complete control here:http://www.ramirezcobos.com/labs/autocomplete-for-jquery-js/comment-page-2/ And i've modified it as: var json_options; json_options = { script:'ReportSearch.aspx/GetUserList?json=true&limit=6&', …

  Read the article

• Set the property hibernate.dialect error message

  - by user281180

  I am having the following error when configuring mvc3 and Nhibernate. Can anyone guide me what I have missed please. the dialect was not set. Set the property hibernate.dialect. Description: An unhandled exception occurred during the execution of the current web…

  Read the article

• How can I set up port forwarding for SQL Server 2005?

  - by Manish

  Hello Subject :how to use port forwarding Internet------> Router in my network ------->LocalMachine (Windows 2003) -->Sqlserver2005 How can I access SQL Server through the internet via a router in the local network? My router IP Address is =192.168.1.86; …

  Read the article

• How to send broadcast message using c# application

  - by Udayanga Gamage

  hi, I have some C# form application.I'm using some central data base which is developed on SQLServer2005.According to my application there are several user levels such as admin,reception,... problem There is a requirement that if someone has changed the database(eg:…

  Read the article

1 2  | Next Page >