problem with loging in

I installed a default instance of Enterprise edittion and

didn't face any error during the instalation process.

In Management Studio in the Server Name section for loging in I wrote the name of the local system.

but I couldn't log in.

in

Control Panel \ administrative tools\services

there is no SQL Server service at all.

should I install any thing extra just like Express Edition which I used to install SQL Express in Visual Studio 2005 pakage or like MSDE in SQL Server 2000?

please tell me what to do

thanks.

pooyan

Hello,

It would seem that the core dbms has not been installed correctly - did you perhaps only select client tools during the install?

Reinstall the server components (make sure you run setup from the server, not tools folder).

Cheers,

Rob

Problem with job history. sql server 2005

HI

I found some issue with job history. My server name length is 32 charecters. and when we view the job history in sql management studio, some back ground script is running, there microsoft has defined servername as 30, due to this smaller definition for server server variable, i am getting error when i tried to view the job history.

what wil be the solution for this issue?

thanks

kiran

rename the server. hahaha. joke

|||

Hi Kiran,

Thanks for reporting this problem. Please file a bug using the following link https://connect.microsoft.com/SQLServer/Feedback.

Workaround:

Use the following stored procedure to get the job history

exec msdb.dbo.sp_help_jobhistory @.mode='FULL'

Link for more help on the above stored procedure:

http://msdn2.microsoft.com/en-us/library/ms188025.aspx

Regards

Rajesh Basa

Problem with job history. sql server 2005

HI

I found some issue with job history. My server name length is 32 charecters. and when we view the job history in sql management studio, some back ground script is running, there microsoft has defined servername as 30, due to this smaller definition for server server variable, i am getting error when i tried to view the job history.

what wil be the solution for this issue?

thanks

kiran

rename the server. hahaha. joke

|||

Hi Kiran,

Thanks for reporting this problem. Please file a bug using the following linkhttps://connect.microsoft.com/SQLServer/Feedback.

Workaround:

Use the following stored procedure to get the job history

exec msdb.dbo.sp_help_jobhistory @.mode='FULL'

Link for more help on the above stored procedure:

http://msdn2.microsoft.com/en-us/library/ms188025.aspx

Regards

Rajesh Basa

Problem with formula input with SQL Server Management Studio Express

Hi all,

I'm creating a database using SQL Server Management Studio Express and have a problem. I've got 4 columns: Surface, Rent, MonthlyIncome and AnnualIncome. Surface and Rent are inputed by user, MonthlyIncome is straight calculation Rent*Surface using Computed Column Formula. But, when I want to calculate AnnualIncome SQL SMSE doesn't allow me to input formula like this MonthlyIncome*12. Where I can read about limitations in formula field?

TIA.

Przemek

hi,

computed columns can not include other computed columns in their definition..

http://msdn2.microsoft.com/en-us/library/ms191250.aspx

but, as the definition of your AnnualIncom column is not that heavy ( ) you can define it on the base columns without problems as

SET NOCOUNT ON;

USE tempdb;

GO

CREATE TABLE dbo.t1 (

Id int NOT NULL PRIMARY KEY,

Surface int NOT NULL DEFAULT 0,

Rent decimal(18,4) NOT NULL DEFAULT 0,

MonthlyIncome AS (Surface * Rent),

AnnualIncome AS ((Surface * Rent) * 12 )

);

GO

INSERT INTO dbo.t1 VALUES ( 1 , 10, 1.8 );

SELECT * FROM dbo.t1;

GO

DROP TABLE dbo.t1;

--<-

Id Surface Rent MonthlyIncome AnnualIncome

-- -- --

1 10 1.8000 18.0000 216.0000

regards|||Hi Andrea, thank you very much for help. I shoul read msdn more carefully.

Przemek