I need a database tool where i can easily add information to it. Example: I have 2 tables, customers and invoices. The database tool must show me input fields of the customer and invoices. invoice has a foreign key to customer. The input fields of invoices must have a dropdown where i can select the customer so i won't have to copy pas...
Should I be scared of upgrading the database to SQL Server 2008? Is it a simple auto-upgrade and everything works? Is it worth it? ...
I am very embarrassed but I cannot remember the name of the MS SQL Server SP that searches your DB for a specified text string and returns all the table names, functions, stored procedures etc that contain that string. And I can't look it up in the help, because in order to get help on it, you need to know its name! It was something li...
Hi, I am using asp.net 3.5 and SQL server 2008 and want to setup a very simple web farm. I have purchased 2 VIRTUAL servers, I DO NOT use viewstate or sessions on my webpages, just cookies so all I need to do is have 2 versions of the same database, on each virtual server (I assume) and 2 versions of the binaries/webpages on each server...
I have a table delivery_history which is populated by a trigger: id(guid) order_number delivery_number haulier timestamp(getdate()) 1 1234 haulier1 2009-10-08 8:34:00 2 1235 haulier1 2009-10-09 9:15:00 1 1234 haulier2 2009-...
In my current project, the DB is SQL 2005 and the load is around 35 transactions/second. The client is expecting more business and are planning for 300 transactions/second. Currently even with good infrastructure, DB is having performance issues. A typical transaction will have at least one update/insert and a couple of selects. Have yo...
What is difference between 3 type of replication? Is replication suitable for data archiving? What is the replication steps? ...
What is deference between Microsoft Sync Framework and Replication? which one is better? ...
Here is what I am trying to do. I have a perl script that browses a website, fills out a form, and submits the form. This process takes about 1 minute to complete and will initiate an asynchronous process on the website to create a report and drop it to an FTP site. After the form is submitted I would like to kill the process and repo...
Hi there, I'm troubleshooting a nasty stored procedure and noticed that after running it, and I have closed my session, lots of temp tables are still left in tempdb. They have names like the following: #000E262B #002334C4 #004E1D4D #00583EEE #00783A7F #00832777 #00CD403A #00E24ED3 #00F75D6C If I run this code: if object_id('tempdb.....
Hi, Whats the purpose of having single column table (identity column)..? is there a good usecase available?? is it really a good practise.?? Cheers Ramesh Vel ...
I have the following code SELECT tA.FieldName As [Field Name], COALESCE(tO_A.[desc], tO_B.[desc], tO_C.Name, tA.OldVAlue) AS [Old Value], COALESCE(tN_A.[desc], tN_B.[desc], tN_C.Name, tA.NewValue) AS [New Value], U.UserName AS [User Name], CONVERT(varchar, tA.ChangeDate) AS [Change Date] FROM D tA JOIN [DRTS].[dbo].[User] U ON tA.UserI...
Hello, I'm trying to archive records from a table in a database to an identical table in an archive database. I need to be able to do an insert for all records with a date greater than three years ago, and then delete those rows. However, this table has millions of records which are live, so I want to run this in a loop of roughly 100 ...
I have a table that looks something like the following : PropertyID Amount Type EndDate -------------------------------------------- 1 100 RENT null 1 50 WATER null 1 60 ELEC null 1 10 ...
I'm thinking of designing a database schema similar to the following: Person ( PersonID int primary key, PrimaryAddressID int not null, ... ) Address ( AddressID int primary key, PersonID int not null, ... ) Person.PrimaryAddressID and Address.PersonID would be foreign keys to the corresponding tables. The obvious proble...
I have a table that has a Trigger associated with it for Update, Insert and Delete. The Trigger works fine and executes. Here is the code for my trigger: CREATE trigger [dbo].[trg_audit_TableName] ON [dbo].viewLayers FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON declare @inputbuffer table (EventType nvarchar(30),Parameters int,EventInf...
I am using the Send Mail Task in SSIS 2008 to send out an email. I am using SMTP. I have SMTP set up in the IIS manager. I have set it to use windows authentication. The From and To mail address both exist. When i configure the task to send an email, i get an error "[Send Mail Task] Error: An error occurred with the following error ...
I need to include several stored procedure in a single transaction in a single database, if any of stored procedure fail then roll back transaction of all stored procedure procesed in the scope. I work with SQL-SERVER 2008 ...
I'm VPNed into the office which has a SQL Server. I'm running IIS 7 on my local machine (at home) to serve an asp.net 2.0 web application. If I put localhost as the my db server, aspx pages load fine (but no db connectivity since I'm not running SQL Server). If I point to the remote server, my app never loads. Even pages that don't ...
Got a strange problem created a little stored proc which need to execute a couple of other stored procs to get some values before executing the main select statement see below, set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[usp_get_ApplicationUserServiceRoles] @UserId int, @ApplicationName varchar(50), ...