In most companies the sql server service ( under services.msc) is run under a service account such as the one you mentioned above.

The aim here is to have sql server...

http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-433&locale=en-us#tab3

Here is a good place to start, also I would recommend reading up

http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-433&locale=en-us#tab2

to know what skills are required.

There are also some exam simulators out there but they are...

I tried the following and hers what i found, please feel free to commet

I created a schema sampler and a table called sampler.sysobjects with the schema.

I then created a login...

whats the error you get when the connection fails. How are you trying to connect to the server. via SSMS or thru code ?

Firewalls ?

Eugene Elutin (8/10/2011)

It's not...

I dont think there is any benefit if all objects belong to the dbo schema. I read somewhere if the schema name if not provided usually it searches all sys...

select * from sys.dm_os_performance_counters

where counter_name like '%memory%'

Could you post the result for the above query?

An other approach would be to add an identity column and then make it part of the primary key. This wa you can avoid the issue of the fragmentation since...

Do you have to use only SQL tools ? There are a few easy to use DB compare tools available online.

Other than TableDiff you could also try generating a Script...

sp_msforeachtable '

with cte as (

select row_number() Over (partition by CHECKSUM(*) order by CHECKSUM(*)) as rowcount1 ,* from ?

)

select * from cte

where rowcount1 >1'

I think this should...

Look up

http://msdn.microsoft.com/en-us/library/ms180965.aspx

lookup group by and having

it should look like

select a , b, c from tb1

where something

group by a,b,c having count(*) > 1

Oops , my mistake . I tried running Backup Log with truncate only and it didnt bring the size down.

However MSDN state the following

NO_LOG | TRUNCATE_ONLY

Removes the inactive part...

Aah i see where the problem is , the post mentions 2000 in the header. I went by the Post category being SQL Server 2008.

Hi Jeff

I looked up the def for routines view in SQL 2005 and here' what i found ,

o.create_date AS CREATED,

o.modify_date...