Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MAK9974

    Updating windows group policy

    Perfecto. worked like a champ. thanks a bunch
  2. MAK9974

    Updating windows group policy

    Agree. But I still need the script that would modify the local group policy with no add ins. it could be WMI or just a VB Script etc.
  3. MAK9974

    Updating windows group policy

    True. But I still need the script that would modifyu the group policy. That is our standard.
  4. MAK9974

    Updating windows group policy

    I like to create a vb script that would updates the Local COmputer Policy Computer Configuration Windows settings Scripts Startup with C:\windows\abc.bat, so that i dont have to open gpedit.msc GUI. I googled and i didnt get any relevant answers...
  5. MAK9974

    UDF over linked server?

    select * from openquery(DOTNET,'select northwind.dbo.xyz(100)')
  6. MAK9974

    Query sysObject to find last modified date

    Nope you cant.
  7. MAK9974

    Where can I set the collation during setup?

    Yes. In SQL 2000, you can setup collation at server level, database level, table level and column level. You dont have to fear that you have to rebuild the master if you use default collation for the box. You can create a database/tabl/column in a different collation. Awesome is'nt it?
  8. MAK9974

    why are my records copied twice"

    see whether you have trigger on table2 which inserts value into table1
  9. MAK9974

    MS SQL errorlog -

    Claire. You are right, when model database is set to autoclose all the database created has the autoclose option turned on. Thanks for the info.
  10. MAK9974

    How to generate passwords with T-SQL

    select newid()
  11. MAK9974

    transfering data between two servers.

    the best way i can suggest is they can give you the backup of the database + zip it and FTP it to your companys FTP site. or they can backup + zip it and put that in their ftp site and you can download it.
  12. MAK9974

    NEWID() function

    YES
  13. MAK9974

    Dynamic folder generation at run time

    --This will create a folder (if it is not already exist) with today's date as suffix in the format c:\MyFolder_yyyy_mm_dd. '********************************************************************** ' Visual Basic ActiveX Script...
  14. MAK9974

    Internet Connection Being Killed

    what SP did you install?
  15. MAK9974

    Need to find Size of All stored procedured in a SQL DB

    select b.name,datalength(a.ctext)+ datalength(a.text) from syscomments a,sysobjects b where a.id=b.id and b.type='p'
  16. MAK9974

    Sql count distinct funtion

    very nice
  17. MAK9974

    Distinguishing between a string full of spaces and an empty string

    did you consider using DATALENGTH ( expression ) and isnull() ?
  18. MAK9974

    How do I limit the number of users?

    Your interface can check for the below statment everytime when the user logs in to the application. select count(dbid) from sysprocesses where dbid in (select dbid from sysdatabases where name ='pubs')
  19. MAK9974

    how to delete data from all the table

    1. script all the objects 2. drop the database 3. create database 4. run the script
  20. MAK9974

    BCP to Excel question?

    basically when you double click XL imports it to XL format. even .csv file can be opened in Excel application, it doesnt mean that it is an XL file

Part and Inventory Search

Back
Top