We have a SSIS 2005 package that is installed on a central server and is called from multiple locations. This package uses a script task to call a .NET DLL which I wrote in c# and installed into the GAC on the central server. When I call the SSIS package from that server on which the package is installed everything is fine. When I call ...
I have two tables, a contacts table and an addresses table. The addresses table contains a contact id, and 4 address lines. I wish to update the contacts table with the information from the addresses table. For simplicity's sake let the tables be as follows: addresses( . contact int not null, . address1 varchar(32) not null, . address2 ...
Hi all I'm reasonably new to SQL Server Reporting Services and Report Manager, and completely new to SSRS's Subscriptions. We're running SSRS 2008. Out of the box it seems that a user with the Browser role can create a Subscription to a report and schedule it to run at any time they choose. As an admin I have setup a schedule called "...
I have a series of questions about Keys, Indexes and Constraints in SQL, SQL 2005 in particular. I have been working with SQL for about 4 years but I have never been able to get definitive answers on this topic and there is always contradictory info on blog posts, etc. Most of the time tables I create and use just have an Identity colu...
Hi, I tried to follow the steps from: http://technet.microsoft.com/en-us/library/cc281307.aspx To create a scale out report server with a network load balancer. Followed every step, nlb/reportserver works fine, but I could not access nlb/reports, I am getting 401 error, what should I do to start debugging it? This is the error that I g...
I have an example in C# code, but it is using streamWriter. It must be involving with FileSystemObject rite. If yes, what are methods should I use? I want to code using VBScript WSH, and my database is MS SQL Server 2005. Any solution, references, or guide are helpful. using (StreamWriter tw = File.AppendText("c:\\INMS.txt")) { us...
I have a table with three columns that I need to display on a ASP.NET page. (SQL Server 2005, ASP.NET 2.0) id int value varchar(50) tstamp timestamp I use the timestamp field to handle concurrency validation so it's for internal use only and will never be displayed to the end user. But I need to store it somewhere in order to do prope...
For example, I need to fill lots of DataTables with SQLDataAdapter's Fill() method: DataAdapter1.Fill(DataTable1); DataAdapter2.Fill(DataTable2); DataAdapter3.Fill(DataTable3); DataAdapter4.Fill(DataTable4); DataAdapter5.Fill(DataTable5); .... .... Even all the dataadapter objects use the same SQLConnection, each Fill method will open...
Is it posible to replicate or copy the stored procedure easy from one SQL Server to an other? ...
We have a sql 2000 db that has some replicated tables (from another server) We're using full text indexing Sometimes, network connectivity stops replication, requiring us to restart it, which isn't a problem- however, this seems to remove the replicated tables from the full text catalogs, which causes problems Any ideas how i can fix t...
what is the difference (system resource wise) between using views and temporary tables? I have a complex report that will be built from numerous tables. I am trying to determine if I should use a series of views or temp tables (SQL 2008). Is there a difference? ...
Hi everyone, As an exercise (read:interview question) in index optimisation, I need a query which is slow on the standard AdventureWorks database in SQL2005. All the queries I've tried take about 1 second and I would prefer to have a query which takes multiple seconds so that it can be optimised effectively. Can anyone here create such...
Hi there, I'm building a website for property agents and tenants. Tenants can sign up and fill in their desired locations for properties, including Street, Town and Postcode. Once they sign up, this automatically emails agents who have properties that match those search criteria. At present I have the query set up as follows so that it...
Hi, I am using SQL Server 2008 and I have the following SQL script: Select o.CustomerId as CustomerNoId, OrderValue, OrderDate From dbo.Orders as o Inner Join ( Select Top (10) CustomerId From dbo.Customers where Age < 60 ) As c On c.CustomerId = o.CustomerId This works as desired when used with dbo.Customers and dbo.Orde...
Hi, I am developing an asp.net application where user inputs set of document number in excel sheet and my application should search for the particular records in the database and return the records which contains the value that was made as an input. For example if the document number which was given as input is "2245678" In database t...
I have a SQL Server 2000 database with approximately 220 tables. These tables have a number foreign key relationships between them. Through performance analysis, we've discovered a number of these foreign key relationships are missing indexes. Instead of being reactive to performance problems, I'd like to be pro-active and find all fo...
Disclaimer: I have figured out the problem (I think), but I wanted to add this issue to Stack Overflow since I couldn't (easily) find it anywhere. Also, someone might have a better answer than I do. I have a database where one table "Common" is referenced by several other tables. I wanted to see what records in the Common table were o...
I'm trying to determine if there is a way to accomplish this elegantly. I have a query: SELECT TASK.*, PROJCOST.act_cost, PROJCOST.target_cost FROM task LEFT OUTER JOIN projcost ON task.task_id = projcost.task_id I just found out that PROJCOST.target_cost and act_cost are not 1 to 1 and need to be summed. I understand how to use SUM ...
Hello Everyone, I currently have mirroring setup between three computers, principle, mirror, and witness. During the day, all these systems are fine; they failover with the failover command, and the failover when unplugging any of the stations. My problem is at night I lose Quorum between the three stations, and the only way to get it b...
Is there a way to do a conditional insert in the compact edition? I've tried two ways that I think would work on SqlServer: INSERT INTO CUSTQUOTE (QTE_ID) VALUES (1) WHERE EXISTS(SELECT * FROM JOB WHERE JOB_NUMBER = 'EW090800345') There was an error parsing the query. [ Token line number = 2,Token line offset = 1,Token in error = WHERE...