No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
12 Posted Topics
 | G'd evening! In case you still need to change the table's column type from T-SQL , the sintax for MS SQL is: ALTER TABLE table ALTER COLUMN column_name new_data_type Ex. ALTER TABLE MyTable ALTER COLUMN MyColumn NVARCHAR(20) For more about the Alter Table sintax, read the books on line (BOL), …  |
| | G'd evening kitkatsavvy! I'm not aware of any SQL functionality that you can implement to block an IP address, nor i have any experience in web programming. With sql you can limit the privileges of any user assigning that user to a given roll or just to delete him from … |
 | G'd afternoon ahmed!! The error you get is because you need to initialize one or more of your variables before you use them. Something like this: [Code] Global db As NEW Database Global vn As New Recordset [/code] By the way, you should recheck if you need all those recordsets …  |
| | G'd evening All! Manish, in [B]my[/B] opinion SQL is not designed to work without a Front End, so, we can't expect sql to have all (same) functions that almost any other OOL have, insted we should take advantage from both ends.... i mean to use the right tool for the … |
| | G'd evening Dru! The sintax seems to be fine, but we don't know the values you are sending nor their types. I would sugest to store (just for tests purposes) the sql string in a varible and then write its content in the inmediate window. Good luck Estuardo |
| | G'd evening Sham! Here you may read all about adp's [URL=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msderoadmap.asp]Choosing and Using MSDE 2000 as the Database Engine for Your Application[/URL] Good luck Estuardo |
| | Hi Clonman! By this time i hope you have found the way to stop the security alert from access, but for other readers: In the main menu --> Tools ---> Macro --->Security In the popup window select LOW. Good luck Estuardo |
| | G'd evening helpwanted! Requeriments to be in the 1NF are: 1. The rows are not ordered. 2. The columns are not ordered. 3. There are no duplicate rows. 4. Every row/column intersection contains exactly one domain value and nothing else. 5. No irregular columns. At a glance your table is … |
| | G'd evening sqlchopper! If that happens often you should consider to run your sproc(s) within transactions. It will not just avoid your application hang, but also and more important it will keep the data integrity. |
| | G'd evening Jared! At a glance the problem might be in the WHERE sintax. What i left in blue is not valid in MS SQL: WHERE ( t_form_data_fish_hd.form_key [COLOR=BLUE][B]*=[/B][/COLOR] t_form_data_fish.form_key) and ( s_form_control.box_no [COLOR=BLUE][B]*=[/B][/COLOR] t_form_data_fish.box_no) and ( s_form_control.form_id = t_form_data_fish_hd.form_id ) and ( s_form_control.form_revised = t_form_data_fish_hd.form_revised ) and ( t_form_data_fish_hd.form_key[COLOR=BLUE] … |
| | G'd evening arron! For your first question the short answer is Yes. That's all what you have to do, the same as in win 2k server. For the second question...it is hard to say. First i would like to ask you to: first try the slow pcs with the fast … |
| | G'd evening pramodDR! It seems like the problem is not with the sql server, but with the domain controller, see or ask which property. Good luck Estuardo |