i am using mapi in my application to send mail to different locations of our company . It is working absolutely fine but the problem is everytime it tries to send a mail outlook presents a dialog do you want to send mail (yes or no) i want to avoid this dialog how can i do this...more >>

i want to create a cursor inside a procedure which takes parameters and i want the cursor to produce a customised error if the user inputs a null i want short code for it ...more >>

Hi, 1. I have a text column which is suppose to hold long text data with multiple paragraphs, indents and bullets. I use Update statement to input data which I copy/paste from MSWord document. I would like to keep those formats when I retrieve data. My question: should I conduct any sp...more >>

How can I truncate a DATETIME to the previous whole hour? Assume I have the DATETIME value "1/18/2004 9:43:26 PM", then I would like to create a new DATETIME value "1/18/2004 9:00:00 PM". I want to fo this for GETDATE(). Olav ...more >>

This is probably a really simple problem, but here goes: I have a stored procedure. Within this stored procedure I am executing another stored procedure for the purpose of retrieving data from 2 output variables. The trouble is, it also returns a resultset which I would like to ignore as I wis...more >>

Please help me create a TSQL that I can use to backup my production SQL Server database nightly. Nightly I would like to restore the development SQL Server database from the production SQL Server backup. The path to Production SQL Server database to backup is \\Gvb_Houston\k$\pharmacy.(Pro...more >>

Hi, I'm using the t-sql script below to get the indexes, unique constraints and PK in my db. My problem is: How can i distince between Index, Unique, Primary Key? Thanks, Hagay The script: --------------- select o.name, i.name, c.name from sysobjects pk inner join sysobjects o on p...more >>

Hello Let's say an INSERT statement raises an error of a duplicate key Is it legal to identify an error by reading the error code and searching the error message for the table name and the constraint name? I mean is it guaranted that the codes will be the same and the table/constraint names w...more >>

I am trying to make a trigger on a table that will pass a value from the insert to a stored procedure , the stored procedure then would update a 2nd table. I've noticed that if the stored procedure fails the insert on the origianal table fails as well. Is there any way around this? ...more >>

Hi, I am updating a dimension table (30 columns, most with varchar(30) datatype) from a staging table using the numeric key as join between table. ===== update cs_customer_dim set col1=. .... from cs_customer_staging cs join cs_customer_dim cd on (cs.customer_key =cd.customer_key) ===== b...more >>

I am a indian telugu guy who works with sp, triggers, and with backend object all the time. Recently somebody asked me the diff between ODBC and oLEDB and which is better and why? How do i find which one i am using. Any help is appreciated. ...more >>

I which scenario's we should use trigger for ref. integraity, and which scenario's rule,check etc. ...more >>

Hi: I am writing rows from VB6 into t-SQL. I like to create a Trigger (I know creating primary keys might be better but I like to create a trigger). I like not to insert the duplicate records and just insert the new records. So far that's what I have: create trigger insertduplication on dbo.empl...more >>

We are using VSS for vesion management. I want to know, is there any database where all these objects( or files) are stored, or version management is managed. what is that database. Thanks a lot. ...more >>

Is it possible and how would I go about setting a trigger on or calling another sp when a logon passward is changed. Im thinging of calling a sp that emails admin when any login password is changed,. Would this be valid request and what would be the best way of attempting this. Regards Don ...more >>

Recently in a interview one of the manager asked me something like this. select * from tablea where name in ( select name from tableb) Now tableb does and exist and this query should not not give any error. IT may/may not produce output but no error. Any thoughts. Thanks a lot. ...more >>

Can anybody give a good example how can I simulate deadlocks. Thanka alot. ...more >>

What is a surrogate key? thanks. ...more >>

I have seen some people talking about pre prod. and post prod. environments. what are they. can somebody give me the ccomplete chain in which a software generally passes. e.g. dev ->qa -> uat ->prod. I also want to know who actually tests in UAT testing. Thnaks a lot. ...more >>

I am a new bee and want to know that we do the stress testing before pushing to production or after pushing to production. Thanks a lot. ...more >>

Hi I am a developer. I just want to know when we generate the script for tables should we include (ON PRIMARY) or not for generating scripts. Thanks, sam if exists (select * from sysobjects where id = object_id ('dbo.discounts') and sysstat & 0xf = 3) drop table dbo.discounts ...more >>

OK, I've lost it. :- Here's my story, and I'm stick'n to it...I hope I have these tables with these columns a_Data.....................Revenue, Income, etc...., Lookup to a_Name_Symbol, Lookup to a_Hyperlinks, Lookup to a_Year, Lookup to a_Quarter, Lookup to a_Quarter_Inde a_Name_Symbol.......more >>

Dear Friends i want to take the backup of some important table of the dabase. How i can do the same. Please also suggest how i can restore the same. Best regards Shal...more >>

Dear Friend I have two servers Matrix and Crash. The Matix server is the main Transaction server having database PurchaseSales. In this database i have tables Cutomer and Supplier. which are updated normally once in three hours with new records by the users The other server Crash is server for ...more >>

I'm simply trying to divide each close1 column by 20, then insert that value into the twentydayMA field. The query keeps on running without finishing, even if I'm only using a single page of data. What could be making this hang? To execute, I'm using exec tad778. I thought about using another cu...more >>

Hello could you guys tell me how to rebuild a primarykey identity(1,1)? /Lasse ...more >>