Search results for query: *

I am using linked server to execute an SP on one server from another. It works fine if on server A i am calling the SP on server B from within a stored proc. I get the above error when if on server A i call the SP on server B from within a trigger. Dont know why this call to a SP on another...

I am using linked server to execute an SP on one server from another. It works fine if on server A i am calling the SP on server B from within a stored proc. I get the above error when if on server A i call the SP on server B from within a trigger. Dont know why this call to a SP on another...

There has to be a way to store a datatype in a variable and then use that variable in a conversion/cast. I tried to do it this way but i keep getting this error: "Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near '@DATATYPE'." DECLARE @DATATYPE VARCHAR(25) SELECT...

i have this stored proc that accepts a parameter called @spParam which is of type char(40) and i have a variable called @SQL_TEXT which holds a select stmt 'select prog_NAME from tblArea where area = ' This select stmt btw is stored in a table that i am retrieving in the SP. when i try to...

working with a webform that has a radio button list ... when one of the buttons is clicked, i would like a certain action taken without having to use a submit button. does anyone have any code on this or can u point me to where i can find some. for simplicity sake, lets say that you want a...

i created a dts package called Nef_Projects which moves data from an excel file to table1 in BLA database - it works fine when executed. i created a job in sql server agent with step1 deleting data from table1 in BLA database and step2 runs the above DTS package. the problem i am having is...

i have a grid that gets loaded with data from db and i would like to give the user the ability to add a record to the grid. cmdCreateNew_Click event has this line of code that adds a row to the grid just fine: grdPaysched.Rows = grdPaysched.Rows + 1 i however am having dificulty highlighting...

I have a question about carriage returns. txtOutput.text = &quot;1&quot; & vbcrlf & &quot;2&quot; & vbcrlf & &quot;3&quot; When i use the above code in a vb.net web application, the output is displayed in 1 line: 123 instead of the expected 3 lines: 1 2 3 I tried to use &quot;<br/>&quot; as...

I have a question about carriage returns. txtOutput.text = &quot;1&quot; & vbcrlf & &quot;2&quot; & vbcrlf & &quot;3&quot; When i use the above code in a vb.net web application, the output is displayed in 1 line: 123 instead of the expected 3 lines: 1 2 3 I tried to use &quot;<br/>&quot; as...

I have this array that gets emptied every time i do a page submit and i would like to retain the information in the array. One solution is to create a hidden text box and to store the contents of the array in the textbox each time the page gets sumbitted then load the textbox contents back into...

Form1 has a richtextbox with some menu items including 'Find' Form2 is called when form1's find menu item is clicked. The word that i am looking for in the find dialog box is highlighted in the richtexbox only when i close the find dialog box - is there a way to have the word in the...

We have this problem where our users are using several vb application created by an ex employee who withheld the source code from the company. So bascially we are trying to find a way to hack into the application to get the source code as it would be much easier and less time consuming than...

i have this ascii text file and i have this excel template. i need to convert and move the data in the ascii text file to the excel spreadsheet. can anyone point me to where i can get help and instructions on how to do this? thanks!

i would like to do the following and was wondering of anyone could direct me to code on the web that would help me accomplish the task: we maintain several databases on a sql server 7.0 --lets call them db1, db2, db3 db1 is the primary db we use and we add users there and then associate them...

i have a column named trandate that is of datatype datetime and i need to do a sum function - grouping with several columns inluding the trandate column. my numbers are off because of the time portion in the trandate column so i was wondering if there was a way to convert the time portion to...

hi, i get an error message from the following stmt when i run in an asp.net page - the problem is w/ the 3rd column name: SELECT ProductID,ProductName,[Units In Stock],Desc FROM Products putting brackets around the 3rd column name does not help and i get an error message - i have tried single...

Does anyone know if you can run sql server 2000 on windows xp professsional.

doe snayone know how i can get the column headings to show up in the drill down tab? thanks

i keep getting this error message that data member was not found for the mapi object when i try to compile a VB exe. i tried to unregister the mapi32 dll and re-register it on my machine using the command line but i get the following message: &quot;C:/windows/system32/mapi32.dll was loaded but...

I am using sourcesafe for the first time here and i am having a bit of a problem so would appreciate any help.... -I checked out Project1 -Added form1 to Project1 -Saved form1 Need to start coding form1 and add controls to it but i get an error message when try to check out form1 or check in...