My understanding is some Administrator has to give me the rights ? Correct ?

Who can that be ?

So you are saying I do have SQL sever locally installed and out...

Luis:

See attached.

I tried "local", "." and my Computer Name.

I think its a right issue. What am I missing here ? What should I tell the help desk folks to...

I didn't mean to .. The previous post suddenly stopped. Probably Lowell gave up on me. No one was interested anymore. So had to add another post to get someone's...

Ed:

I agree, But I do not know how to connect. I mean I know how to open SSMS and then connect to other servers, run sql statements.

In this case what...

Lowell: The script did not prompt me.

Looking at the attached ( in one of the previous posts ) image it is clear that SQLSERVER is running as a service....

Lowell

Here is the new Program Icon I mentioned in my previous reply.

See attached.

I know it is something related to SQLServer. I have never seen that before

Lowell

Before I run the script for a second time..

I also noticed a new icon appearing in windows, Attached in the icon and the program it launches. May be you might...

Lowell

It did not prompt me.

Just to make sure we are in the same page, I have attached the script. I gave it a txt extension purposely so that I...

Lowell

Please see attached

Good Answer, Can you help me check whether I have SQL Server installed or not ?

Where do I start this ?Suggestions Please

Thx for the reply....

Jon.Morisi:

BTW More than your reply I was taken by the changing ICON you were using. That is cool!

May I wask what tool you used to create the...

Makes sense.! Thanks for the perfect answer

Nice syntax...

I was just playing with the SQl and ran the following

exec sp_MSforeachdb 'SELECT top 1 ''?'' As DatabaseName FROM [?].sys.tables '

However it only listed about 6...

Thx to

Sergiy

create table a ( x datetime );

alter table a

add date_char as convert(char(10), x, 112 );

😛

insert into a ( x ) VALUES ( '05/12/2005' );

select *...

Anyone,

I like the idea of a computed column.

Can you share the syntax for that please ?

ALTER TABLE a

ADD dd_date CHAR(8) and then ??????