Viewing 15 posts - 5,866 through 5,880 (of 7,429 total)
You could also create a script that checks for the existance of the table and does this then use sp_MSForEachDB to speed you along.
"Don't roll your eyes at me. I...
May 15, 2002 at 3:28 pm
Not really a good practice per se, as when you change these you can run into a lot of issues working with ownership chains of views and stored procedures.
"Don't...
May 15, 2002 at 3:27 pm
What kind of datatype is b?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 15, 2002 at 3:21 pm
Take a look at this thread (near bttom especially), should help you out.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 15, 2002 at 2:51 pm
Can you give me an example please? You can use a dynamic SQL statement to build the query and do a SELECT with column the columsn in order. SOmething like...
May 15, 2002 at 10:12 am
Not sure where to go from here, cannot find anything reported like this before and cannot think of anything specific. Can you post a section of relevant code maybe something...
May 15, 2002 at 9:45 am
Have you tried regsvr32 -u to unregister and then regsvr32 to reregister? If so I am not sure, can you send me you code for you dll so I can...
May 15, 2002 at 9:40 am
You could try sp_detach_db then delete the transaction log (or rename) and use sp_attach_single_file_db to attach the DB itself, the only issue is this has to be a single file...
May 15, 2002 at 9:36 am
So you are entering "admin" for the username on the Access connection screen? If so try without it and see what happens. Also do not use a password for that...
May 15, 2002 at 8:23 am
There are just so many things to consider. Hard to say exaxctly what. I suggest you check thru the articles here and forums previous threads. Lots of specific questions previously....
May 15, 2002 at 7:57 am
Sorry xTest is where you should sub your table name.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 15, 2002 at 7:10 am
This should do the trick. There are comments thru the code to explain what is happening and 2 notes you need to look at before running.
---------------------------------BEGIN CODE---------------------------------
/* Output the original...
May 15, 2002 at 7:09 am
Sorry not seen this happen before. What service pack are you running as SP 1 makes serveral fixes related FTP Task?
"Don't roll your eyes at me. I will tape them...
May 15, 2002 at 5:51 am
You state FILERELOCATE , do you mean RelocateFiles?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 15, 2002 at 5:42 am
Can you post your steps. I get no issue with doing this in any of my test servers using the SA account. Also what is the exact text of the...
May 15, 2002 at 5:30 am
Viewing 15 posts - 5,866 through 5,880 (of 7,429 total)