do both databases have same auto-growth settings ?

is the fill factor of indexes on both tables same ?

shannon, you need to define 'nearest' zone - is it seconds or hours or days ? does near mean both later and earlier in time ?

then, change the 0.001 in...

It shows up if you select 'Show All Columns' in Events Selection Tab...

Great!

1. Ran a trace and got a Login Failed. These were the interesting columns :

GroupId - BLANK (was 1 when it succeeded when i manually put default db)

LoginSid - BLANK...

How do I suspend (Pause) replication onto Server B, and Resume it afterwards, safely ?

Specs:

Server A (2005, OLTP, Publisher + Distributer) . Company DB (250 GB)

--transactional,push-->

Server B (2005, Reporting, 200...

I'm not changing the schema.

Only changing index type between clustered and non-clustered

Tried to convert it to varchar (chinese output) and XML (parsing error) - both don't work.

great! thanks

thought of something similar, but didn't know how/why the min(), max() aggregates would be relevant for strings.

yes, the column names must be dynamic.

Actually, they must come from somewhere else...

Each project (represented by column 'number') has one or more people (column 'name') working, who have their opinion of the project ('comment')

At a glance, management would like to see all...

any ideas?

getting below error when deploying reports from Visual Studio:

Could not load file or assembly 'Microsoft.ReportingServices.RdlObjectModel, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

I tried both:

- restarting sql...

that was just a simple query example.

but for a complex one with functions:

select x,y,z, min(..), max(..), substring(..)

from ...

?

killed the tran.

that should have caused a checkpoint - log file space used dropped.

then shrank it.

all good.

A coworker who sits next to me calls my name "Calvo" and I respond with "What?".

No big deal, right? Well, apparently this coworker thinks it is rude to answer with...

<bump>

thanks jeff.. (& others) who voted on https://connect.microsoft.com/SQLServer/feedback/details/555557/ssms-open-file-with-active-connection-or-prompt-connect-to-database-engine

but no response from M$ yet..

to remind people of issue: when you work on multiple servers and double-click an .sql script, SSMS...