Search results for query: *

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

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

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

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

Hi I am using SSMS 2005 studio express and I cannot make my SQl Query window resize. If I click New Query it is the full screen and my objext explorer covers the left hand side of the Query window. I would like to have the Object explorer on the left and the SQL window next ot it on the right...

Hi I am trying to attach the Adventure Works DB into SQL 2005 Express Studio. But when I attach the DB I ma getting this error message (below) any ideas how to get round this and get the DB loaded. Thanks TITLE: Microsoft SQL Server Management Studio Express ------------------------------...

I have a cross tab report that uses a maximum to calculate a fixed planned budget figures. When the colum is added into a Graph the colum just goes to the highes amount and not the real amount. For example January figure is 227,000.00 but on the graph the bar fills the entire column (axes...

Does anyone know where I can find some free downloads for SQL 2005 Management Studio tutorials. I am searching the internet and have come across E-Books but cant quite find a simple step by step guide on how to do things. I have some experience but would like to ahve some further guidance...

I have a laptop with SQL Enterprisr manager loaded. My log ins only relate to my work place. Is there a way where I can open it open locally so i can make my own databses and perhaps load the Northwind databse. Please advise anyone, Thanks

I have created a report using Crystal Reports 2008. I am linking to SQL server 2005 database. I ahve 2 small problems. 1. When I refresh the report it always asks for the SA password, is there a way I can get the report to remember the password. 2. I have attached this report into our ERP...

When running a function in our ERP system we are getting this error message The message could not be sent to the SMTP server. The transport error code was 0x80070057. The server response was not available The error that initially was the problem is now fixed, but now when we go into this...

I have 2 columns in Excel. They are list of Invoice numbers. In one column I have a difference of 5 numbers in total rows(Column A as 2270 rows and Column B as 2275 rows). How can I tell which ones are different without having to go through nearly 3000 rows Thanks

Hi When I try and run a restore from our production to the test database I am getting this error message. Does anyone know what it is and how I can solve it. Thanks ITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'DB01'...

I have created a crosst tab report which show totals for monthly periods with the Total of all figures. My problem is the Cross Tab pout the Total at the beginning of the report before all the periods so I have this Total P1 P2 P3 etc.... Rows 1200 1000 1000 1000 I want...

I have two fields, Invoice amount and Period which come from our database. periods are from 1 to 12. I can bring through the field amount and total this no problem. I can use selct expert to use it to just see Period 1. What I need is a way to Have 1 to 12 totals looking at just the correct...