Hi I have created a project using C# and SQL SERVER 2005. I want to deploy the project so that I can create .msi file. Can anyone help me with the steps I should follow to create the setup file? Also in which editor I should add then database and how can I add it? Please somebody help me out! ...
When I execute a T-SQL query it executes in 15s on sql 2005. SSRS was working fine until yesterday. I had to crash it after 30min. I made no changes to anything in SSRS. Any ideas? Where do I start looking? ...
I have a job which has a stored procedure that copies data from one server to another.But problem is that there are two servers,in one i've to copy data in batch of 50 and other in the batch of 10.So,i need to check ip addresses in that case ...
In classic asp page, i need to catch the error description and insert into a table in the database. when i use 'on error resume next', i am getting a timeout error as follows: The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTime...
I have a job setup in SQL Server 2005 which has an Operating System (CmdExec) step. The step calls a program which can take a long time to run. I see that if the program takes longer than 1 minute 40 seconds to respond the step fails with an error message "The operation has timed out". The program actually continues to run and generate...
I need to create a function that takes a table (or table variable) as an input parameter and returns a table-value as a parameter. Is this possible with the following constraints: SQL Server 2005 CLR function is not an option (should be TSQL-only) Any example code as a starter would be helpful. ...
I have a table in SQL Server 2005 with the following structure: fname | id ---------- aaa | bbb | ccc | I need a query that will fill the id column with sequential numbers (eg, 1-3 for this example data). I need this to update the table itself, not just a query that shows this in the results. ...
Is there a way to query SQL Server XML type so that for an element with xsi:nil="true", return null instead of default datetime value, which is 1900-01-01 00:00:00.000? here is a code snippet declare @data xml set @data = '<DOD xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />' select Value1 = @data.value('/...
How do you get the identity column value after an insert in SQL Server Compact 3.5? ...
I currently have a SQL Server 2005 instance installed on my local machine, and at the time of installation I named the instance 'localhost\sql05' Can I easily change this to just 'localhost' ...
How do you call an SSIS package using a Web Application? I'm using SQL Server 2005. I prefer a solution in C#2.0 above. Any help will be greatly appreciated. Thanks in advance. ...
1.While con to dbserver it comes error,sql doesnot allow remote connection(provider Named pipes(erro40). 2.how to uninstall named instance. pls answer me...... emailid:[email protected] ...
In a single SQL Server instance, I have the following databases: Headquarters Branch001 Branch002 Branch003 ... Branch*nnn* In each Branch DB is a procedure called usp_ComputeDailySales that does some computation and writes daily sales figures to the Headquarters DB. How do I write a single stored procedure in the Headquarters DB...
My SQl Server data base is located in another machine and WCF service and client is on another machine. While I consume this service ,which in turn access the Sql server to fetch data and return to the client, it gives following error : Login failed for user ''. The user is not associated with a trusted SQL Server connection. This err...
I'm looking for a way to check SQL Server availability like this MySQL solution, unless there is a better method. My plan is to check if the SQL Server instance is up/down, and if it is down then display a message to the user, all via a try/catch. ...
My goal is to maximise performance. The basics of the scenario are: I read some data from SQL Server 2005 into a DataTable (1000 records x 10 columns) I do some processing in .NET of the data, all records have at least 1 field changed in the DataTable, but potentially all 10 fields could be changed I also add some new records in to the...
How do you discover the name of the unique table index a full text index references? SQL to generate the response would be most useful, but GUI (SSMS) solution will work too. ...
I think the question explains itself ...
I have a column which looks something like this: CASE WHEN col1 > col2 THEN SUM(col3*col4) ELSE 0 END AS some_product And I would like to put it in my GROUP BY clause, but this seems to cause problems because there is an aggregate function in column. Is there a way to GROUP BY a column alias such as some_product in this case,...
I often get the errors: Msg 208, Level 16, State 0, Line 1 Invalid object name '#foo'. Msg 3701, Level 11, State 5, Line 1 Cannot drop the table '#foo', because it does not exist in the system catalog. How do I know what temporary tables there are in scope? They obviosly don't show up in SSMS like base tables do. ...