Viewing 15 posts - 346 through 360 (of 1,186 total)
It may be treating the 1st data row as FIRSTROW. Have you tried FIRSTROW = 1?
May 23, 2005 at 2:04 pm
You cannot "link" a stored-procedure this way. Access knows that sp's are recordsets and you will need to EXEC it via ADOCMD and ADORS to return the results into a...
May 23, 2005 at 8:17 am
The DEFAULT value can be found when you open the table in EM. Just DELETE the DEFAULT from the column and you should be good to go.
May 23, 2005 at 8:15 am
Research BOL for BCP should have what you need
May 23, 2005 at 6:01 am
IF the database is no longer being accessed it automatically closes until the next time it is needed. It then needs to "open" for business. If you have this turned...
May 20, 2005 at 7:07 am
Easiest way is to create an NT windows group, SQL role and assign the SQL role the permissions and have the "User" of that role be the NT group.
IF the...
May 20, 2005 at 7:05 am
If you use the Server Network utility you can "hide" SQL servers from being seen. Of course IF they know they are there they can still type it in but... ...
May 20, 2005 at 7:02 am
I guess #1 is how does your companies IS security team feel about a vendor having direct access to your companies information? Why not have a "honey pot" server that...
May 20, 2005 at 7:01 am
The only way that I know of would be to remove the tables/queries from the front-end make everything SQL calls to the back-end via stored-procedures and recordsets (modules) and then...
May 20, 2005 at 6:58 am
Another thing is can you provide what type of information you are looking for so we could possibly help you tailor the profiler??
May 20, 2005 at 5:29 am
Flavio,
Research BCP from BOL. Should be able to provide everything you need.
May 20, 2005 at 5:26 am
IF you only have 3 days and are having problems can you not just copy the MDF and LDF to your local PC??
May 19, 2005 at 10:18 am
I think the SETs have to come prior to the CREATE and must be sep. by GO??
May 19, 2005 at 10:17 am
Assumption: You want to return the @CONTADOR value to the calling procedure
Change the proc from DECLARING @CONTADOR to
CREATE PROC...
@CONTADOR OUTPUT = NULL
AS
ALSO, I would AVOID naming your created procedures...
May 19, 2005 at 6:22 am
I know that this thread could go on forever given the amount of times this is asked... Have you tried searching for array or split function from the search here? ...
May 17, 2005 at 4:16 pm
Viewing 15 posts - 346 through 360 (of 1,186 total)