Search results for query: *

ok thank you very much for the help...

sorry but i dont see the import option in SQL 2000 enterprise manager, after following your suggestion...

Hi all, I have 100 server group by location: State1 servername1 servername2 State2 servername1 I need to move all those groups and server registration to another pc. I exported the list but how do I imported on the other pc? I found 1 solution involving exporting the REGISTERED SERVER X...

wow thanks perfect, Aditionally is there a way to view the access that a role have? I mean for example: Rolename: RoleSelectOnly Has: Select on TABLENAME1 Select on TABLENAME2 etc. Im a rookie at this sorry and thanks in advanced

Hi everyone, Is there a way to create a script that can give you the following? username, what database is using, what role it has, what access have thanks in advanced

thats what i was trying to avoid... thas why i wanted the prompt so for each loop it will ask me for the new value nontheless thank you very much for your comments

thanks guy, The script is for me to run not the user, I dont want to hard code a lot of parameters every time i ran it thats why i wanted a prompt on the analyzer for me to use so first run i input "jjj" next run i input "aaaa" and so on. is there a way without using SP, or aditional...

hi, Im trying to do a simple thing, waiting for a user to input a value so i can pass it to a sql statement and do a select according to their input like: Declare @USERINPUT varchar(50) Select * from MYTABLE where MYFIELD = @USERINPUT But the trick is I can't use it on a store procedure...

well my plan worked the import with 8/31 was inserted inteir correct partitions and I also used the insert into solution for data that was in other tables. thanks guys

well i let you know my results

Thank you santamufasa, I tought of doing that but This is a datawarehouse, where we don't backup using the export utility and then passing it on to tape. this is done every once a week: 1- We shutdown the database 2- Backup the physical files of the database 3- startup the database now my...

also, this table is partitioned if i extract a subset of data and imported back again will it be located in the correct partition?

thank you for the response, Im trying to backup just the End of month data of 8/31 instead of the whole table and then imported to oracle again. I lost some data and i need to do a restore that is old and doesnt have the 8/31 data, so i wanted to export out the data i need so after restoring...

Hi, I'm trying to export a subset of data using a date field using this: exp user/pass file=flename.dmp log=filename.log tables=MY_TABLE query=\"where as_of_dt='08-31-2007'\" and this is the error it gave me: EXP-00056: ORACLE error 932 encountered ORA-00932: inconsistent datatypes Export...

well after all your suggestions everything worked. the owner of the job on some cases was another user. thanks for the help!!

thanks for yuor inputs, i'll check on this and let you know the results. So far the user on both enviorments have the same security level... let you know more during the day.

HI, I have a Database Called PRODDB the owner is USER1 and a table called MYTABLE that was created by USER1 and also USER1 is owner of the table. I have setup the exact same database and user in TEST enviorment. In test a DTS that reads a file and upload it in a table and do a simple select...

Hi guys, i want to do transaction log backup for an audit but my software conflicts with the directory of the transaction log in prod so I want to schedule another backup after 30 minutes from the original transaction backup in prod to capture the data from my new directory. Qustion if i have...

Hi , I'm looking for a way to deny users from droping tables in the BOL i cant find a revoke statement if i write this: revoke drop table to test i get thios error privilige DROP <object> may not ber granted or revoke is there a way to to do this? thanks in advanced

ok, the data that should be there are telephone numbers (123)123-3454 etc... and extentions 3434 etc.. the problem was tha the extensions when converted they look like this 3434.0 so i need to get rid of only the records that have .0 so i came up with this from all your suggetsions update...