Here you go USE Tempdb Go CREATE TABLE Inventory(idx int, fabidx int, coloridx int, qty int, isReserved CHAR(1)) INSERT INTO Inventory VALUES(1,1,1,15,'Y') ...
following 2 are the undocumented extended SP provided by Microsoft. pwdencrypty(‘stringname’) pwdcompare(‘input string name’,’stored input encrypted...
Hi folks, here is the solution,have implemented code in this way. cooooooool...... ProcedureResults pr =null; private DataSet actionMapping = null; pr =...
HI, i have sql server 2000 instance and outlook 2002 client support i want configure the sqlmail in my sqlserver and have to send the mails to anybady in my...
FYI Note: forwarded message attached. ... Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web Hi, Refering to your Resume we have...
Oops ... In SQL we can encrypt the whole SP , but i believe you want the encryption on the field level ..... Any one who can add some thing on this JeeLani...
Hi lourdhu, Please find the attached Zip. This gives some info Thanks & Regards Raja ... From: lourdhu79 [mailto:lourdhu@...] Sent: Wednesday, March 02,...
Raja Sekhar
rajasekhara@...
Mar 7, 2005 10:04 am
799
Hi Lourdhu, Please follow the foolowing steps to configure mail: 1) Create a mail profile: a) Start-->Control Panel -->Mail (Double click) --> Show profile -->...
Hi all, I have to execute a procedure and store the print statements in procedure to a file. For that purpose I am using: declare @str varchar(500) select...
Aditya, Can you send your code? Can you do changes to your sproc? Also let me know is there any restrictions if you create any tables or global temporary...
Jagan, I am not sure if the solution will work. When you Insert into Table..exc sproc, the result set of the proc would be inserted into the table and not the...
Hi Mitra I think the solution given by Jagan will work . I have checked this . --Create the Sp which to be called -- This will return one value as O/P which...
Hi, Can anyone pls help me with this problem..I need to call a .Net assembly from within a function, trigger or SP of SQL 2000. Is it possible. If so, can...
Ramesh, Murali Krishnan
murali-krishnan.rames...
Mar 10, 2005 8:54 am
805
As long as you know the methods called in the DLL and it si registered on the same box do something like this ..here we have CDONTS dll registered on Box...
Note: forwarded message attached. ... Do you Yahoo!? Yahoo! Small Business - Try our new resources site! QA Lead/Tester with 5-6 years exp with Unix background...
Hi Friends A Large IT Group company based in Noida looking for Senior SQL Server DBAs. Please send your resume to dbagurus@... The candidates should be...
Hi Our Client Specialized in Custom Software development,web design,Internet/Intranet Applications requires Java Programmer for their Off Shore development...
Hi folks, I would like to involve and effectively participate in this team. About me: I have been presented some tech presentations and KT in the emerging...
Hi All , Need a small information on data migration using DTS in SQL Server I have used Import/Export wizard of DTS and tried to insert data from Source ...
Raja Sekhar
rajasekhara@...
Mar 15, 2005 9:36 am
813
Hi himanshu, 1>> How many total rec are there 13 2>> What is the error you are getting ?? Error at Destination for row number 2. Errors encountered so far in...
Raja Sekhar
rajasekhara@...
Mar 15, 2005 12:40 pm
814
its a common error make sure the Date Datatype on both side is same... seems you must have selected the smalldatetime on one side and something on the other...
Hi Raja, Could you please try this... In DTS Wizard after configured your source, target and other stuffs, save it as a DTS package. Open the DTS package, edit...
hai guys i m new member to this group.i like get details or stratergy that are to followed during database design ie. any documented format.points to be...
Well there are lots of things we wmust consider before designing a Database... therea re no hard and fast rules but off course lots of recommendations and...
Hi vijay To doing database design .i write some important point go through this 1) you have to see your database configuration 2) declare of the datatype ,...
FYI Use the Employee code , T078 !!! Dear All, We will be conducting interviews this week in Bangalore at the following venue Date : 19th March 2005...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
