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 Chriss Miller 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: *

  • Users: cpitc
  • Order by date
  1. cpitc

    adding users using sript

    Hi This works fine for SQL log in -- Code to create a SQL login CREATE LOGIN [cp] WITH PASSWORD='leeds', CHECK_EXPIRATION=ON, CHECK_POLICY=ON, DEFAULT_DATABASE=[cpmonday], DEFAULT_LANGUAGE=[English]; but what can I use for Windows log in credentials Thanks
  2. cpitc

    create user logins using script

    Hi I used this example to add a user log in. it worked ok on my SQL epxpress query analyser, but on some colleagues it didnt and would nt allow the script. It appears there can be script for Windows log in and SQL log in. Could someone please explain what the N is and also explain (perhaps...
  3. cpitc

    adding users using sript

    Hi I cannot get this script to work. If I ahve a database called CPMonday and I want to add a user called Colin with password colin01 what would the script look like. I have tired changing it where I logically think it should be looking at your script (as below) but I get variouse error...
  4. cpitc

    Clustered and Non Clustered Indexes

    Ok thanks that makes perfect sense now. Thanks for your help and good explanations.
  5. cpitc

    Clustered and Non Clustered Indexes

    ok thanks for the answers, so if I am understanding correct you can have only have one clustered index in a table and the rest of the indexes must be non clustered. Or if im wrong why would you use a non clustered index if a clustered is better? Thanks
  6. cpitc

    adding users using sript

    Hi I used this example to add a user log in. it worked ok on my SQL epxpress query analyser, but on some colleagues it didnt and would nt allow the script. It appears there can be script for Windows log in and SQL log in. We took the N out and this worked. Could someone please explain what...
  7. cpitc

    Clustered and Non Clustered Indexes

    Could someone explain in simple terms the difference between a clustered and a non clustered Index, and why you would use one or the other. What advantages do they have against each other. Thanks
  8. cpitc

    Foreign Key problem

    Ok thanks thats perfect. Found the problem and sorted thanks.
  9. cpitc

    Foreign Key problem

    I am running a sql script to try and create a FK in a table. I am using this script ALTER TABLE employee ADD FOREIGN KEY (JobNum) REFERENCES Emp_Jobs (JobNum) but no matter what I do it keeps giving me this error message, Msg 547, Level 16, State 0, Line 1 The ALTER TABLE statement conflicted...
  10. cpitc

    Import data from Excel

    Ok I managed to get the download and now I ahve the import and export tool. I managed to get one excel spreadsheet into SQL, but on my second one, when I go into edit the mappings it is only giving me the option to Create Destination Table. The table already exisits in the databse so I just...
  11. cpitc

    Import data from Excel

    Im afraid I cannot see it on mine (2005 version. If I right mouse click on my database name under Tasks I only have the options for Detach Shrink Backup Restore Genrate Scripts The Iport /Export does not show anywhere elas on the menus. Any ideas? Thanks
  12. cpitc

    Import data from Excel

    Thanks for the link. The problem is SqL Server Management Studio Express does not have the Import and Export routines. Therefore I am trying to find another way, perhaps through scirpt that can do this routine. Thanks
  13. cpitc

    Import data from Excel

    I am using SqL Server Management Studio Express and want to import some data into a table from an excel spreadsheet. I dont have the import facility due to me using Studio express. Does anyone know how I can import this small spreadsheet into the table please.
  14. cpitc

    Import from excel

    I am using SqL Server Management Studio Express and want to import some data into a table from an excel spreadsheet. I dont have the import facility due to me using Studio express. Does anyone know how I can import this small spreadsheet into the table please. Thanks
  15. cpitc

    Dat format

    I have created a table using this small script CREATE TABLE Employee ( Empid smallint not null, Lname nvarchar(50) null, Fname nvarchar(50)null, City nvarchar(50) null, DOB datetime null, JobNum smallint not null ) I then have created a record using this script INSERT INTO Employee (Empid...
  16. cpitc

    code to add a user

    Of course, thanks it works well now.
  17. cpitc

    code to add a user

    Thanks for the reply I have entered this code CREATE LOGIN [CP] WITH PASSWORD=N'leeds', CHECK_EXPIRATION=ON, CHECK_POLICY=ON, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[English]; Use Adventurworks EXEC sp_grantdbaccess 'CP' When I run the EXEC I ma getting this error message Msg 911...
  18. cpitc

    code to add a user

    Hi I am running SQL Express (SSMS) under the server name Colin\SQLExpress If I use this script I cannot log into the SSMS using the SQL login created. CREATE LOGIN [colinp] WITH PASSWORD=N'leeds' , CHECK_EXPIRATION=ON, CHECK_POLICY=ON, DEFAULT_DATABASE=[Adventureworks]...
  19. cpitc

    Registering New Local Server

    Hi Is there a way I can have 2 local servers. Presently when I log in I use this server name COLIN\SQLEXPRESS. I would like to demo connecting to another server but can only do this locally. I tried the Register Option but this automatically gives me the local one I alreay attached to. is...
  20. cpitc

    Making new query window smaller

    Its ok I found under the window menu you can reset the windows to default, this did the trick. Thanks

Part and Inventory Search

Back
Top