Hello Friends, I am having a web server with install of WINDOWS 2003 Server and SQL SERVER 2005 Currently and i try to do a job schedule with the use of some control that i created. every thing is working properly but when it starts the job (in job i have written T-SQL Command for Backup Database) it will gives following error. i alread...
We have a very large table (> 77M records and growing) runing on SQL Server 2005 64bit Standard edition and we are seeing some performance issues. There are up to a hundred thousand records added daily. Does anyone know if there is a limit to the number of records SQL server Standard edition can handle? Should be be considering moving t...
Where do I find a complete list of new T-SQL features in sql server 2005 comparing with 2000? A few ones that I know: Pivot, Output, Try..Catch. Anything else? Thank you. ...
I wrote this sql query to search in a table: Select * from TableName where Name Like '%spa%' The table contain these row for example: 1 Space Company. 2 Spa resort. 3 Spa hotel. 4 Spare Parts. 5 WithoutTheKeyword. I want to know how to edit this query so it return the results sorted like this: 2 Spa resort 3 Spa hotel 1 Space Compa...
Hi, I've got a rendering extension for reporting services which uses the ReportExecution2005.asmx service to execute a number of "subreports" and then puts the results in a powerpoint presentation. A typical usage scenario would be to go to the Report Manager, select my "Powerpoint" report, which is used only as a placeholder for param...
I have the following Query in SQL Server 2005: SELECT PRODUCT_ID FROM PRODUCTS P WHERE SUPPLIER_ORGANIZATION_ID = 13225 AND ACTIVE_FLAG = 'Y' AND CONTAINS(*, 'FORMSOF(Inflectional, "%clip%") ') What's interesting is that using this generates a Hash Match whereas if I use a different SUPPLIER_ORGANIZATION_ID (older supplie...
We have an ASP.NET application with an InfoPath forms component, delivering InfoPath forms to the browser using InfoPath Forms Server. Rather than save the forms in SharePoint, we submit the XML form data to a ASP.NET web service, which saves the data as an XML data type in SQL Server 2005. This is working fine, and we have no issues l...
My company has an application developed for SQL Server 2005 (among others), and a potential client is attempting to install it on SQL Server 2000. Naturally, installation failed. Specifically, it failed with syntax errors in our CREATE TABLE statements. Is there a summary of the language differences between these two databases? ...
In my table, I have a nullable bit column (legacy system...) and another developer recently made a change to a stored procedure to only show values where the bit column was not true (1). Because this is a nullable column, we noticed that if the column was NULL, the record was not being picked up. WHY is this? Both the other develope...
In SQL Server 2005, how do you read an image from the Categories table in Northwind? I can upload my image to my own database and display it from there, but I can't display an image from Categories table in Northwind. Can someone please show me how to do this? ...
Hi, How do I delete a record from a table? For example, the table has two columns: eno and ename. I want to delete one value in ename from the table: Eno Ename 1 asha 2 bimal I want to delete the value 'bimal'. ...
Hi what is the SQL 2005 version that i can install on Win XP ? I need DataBase and to create tables,query.... thank's in advance ...
I often find myself in the following situation: The customer reports corrupt data in his database. We investige the problem, sometimes by try and error. We try to solve the problem by using our application or one or two repair tools we ship with our product. (Only in bad cases we write a repair script for individually addressing a spec...
We have a database currently sitting on 15000 RPM drives that is simply a logging database and we want to move it to 10000 RPM drives. While we can easily detach the database, move the files and reattach, that would cause a minor outage that we're trying to avoid. So we're considering using DBCC ShrinkFile with EMPTYFILE. We'll create a...
SQL Server Edition: SQL Server 2005 w/ SP3 and 2008 Is there a built-in SQL Server stored procedures that will retrieve following information? Or a DMV (Dynamic Management View) would be great as well. I am interested mainly on how to find out FILEGROUP data of a table specifically. But it'd be better if there was a sproc that will ret...
Im working on this large DB which has a lot of the business knowledge embedded in the SPs[I know!] and there is a lot of chaining between the SPs. i.e one stored proc calling another. Im want to find out a list of stored procedures which update a particular column. How would I do that. Using showplan_All as outlined in http://stacko...
I have a table with a couple thousand rows. The description and summary fields are NTEXT, and sometimes have non-ASCII chars in them. How can I locate all of the rows with non ASCII characters? ...
So I have a stored procedure in a SQLServer 2005 database, which retrieves data from a table, format the data as a string and put it into a varchar(max) output variable. However, I notice that although len(s) reports the string to be > 8,000, the actual string I receive (via SQLServer output window) is always truncated to < 8,000 bytes....
We are using Replication and seem to be having endless problems with it. It seems to shut down for unknown reasons. It needs to be shut down to remove a column and only starts back up half the time. Does anyone have any advice on how to properly use replication or some alternatives to it. Edit: We are using Sql Server 2005, We cannot ...
I am creating a select statement on the fly because the column names and table name can change, but they all need to go into the same data destination. There are other commonalities that make this viable, if I need to later I will go into them. So, what it comes down to is this: I am creating the select statement with 16 columns, there w...