Search results for query: *

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

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...

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...

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

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

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...

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

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

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...

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...

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

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

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.

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

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...

Of course, thanks it works well now.

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...

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]...

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...

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