deepak.a (8/9/2011)

in the Query window i need to run sql script not by connecting another server in SSMS. I...

Freeing disk space could means many things :-

e,g simply backing up a db will free space , so will shrink db

you could even move a partition out, or delete unwanted...

SSIS

missing configuration files , incorrect deployment , missing permissions , networks issues during etl etc.

missing pre reqs

SSAS

Backups , warm cache , performance tuning and memory management during processing. Full...

run a trace

in SSMS you can directly connect to the target server , you could use Sqlcmd as well.

Is there is difference between shutting down from the MMC vs simply running the shutdown command in SSMS ?

Sheesh 😀

select SPECIFIC_NAME ,LAST_ALTERED from information_schema.routines

where SPECIFIC_NAME = procname

Look up ROW_NUMBER function

When you created the user what did you specify as the default schema

e.g

CREATE USER [ABCD] FOR LOGIN [ABCD] WITH DEFAULT_SCHEMA=[notdbo]

While the are used synonymously there is the basic difference Suresh has just pointed out.

Usually Locking is the cause of blocking. Ie. One process is locking certain rows with exclusive...

with cte as (

select ROW_NUMBER () Over (partition by (convert(varchar(256),eventtime ,103)) , eventid order by (convert(varchar(256),eventtime ,103) )) as rowid ,

convert(varchar(256),eventtime ,103) as dates , eventid from...

After reading your post I am still not sure where your getting the data to update the columns other than column 10 in the table.

But to summarize here's what i...

DBCompare is also a good tool. However it has trouble with collations.

I am thinking this should work for you

Select...