trying to decrease the size of the trans log for a sql7 db. In sql 2000 the dbcc shrinkfile seems to actually descrease the size of the file when run after using the truncate log, but in sql7 running that same command does not seem to descrease the physical size of the file on the hard drive...
I would like to be able to branch from a 'task' based on a result from the database. Is there such a task where i can query the DB and return a result such as 1 or 0 and be able to branch one way or the other based on the result?
thanks
I created a macro then deleted it. Now everytime the excel document is opened it propmts the message to Enable or Disable macros as if it detected one. Even though i deleted the macro and I can not see any macros available to run it still reacts as if there is one.
How can one completely...
I am trying to bcp ascii data into sql from a .txt file that has characters such as umlaut. running the bcp statement from cmd line using the argument "-c", the characters change from an "ä" to ',,' (double comma). other characters experience similar changes. the code_page...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.