Bah humbug. Put'em in the db. They are secure, get backed up, etc. Ain't THAT much work!

Andy

I use the method of finding the job and then running it. Works pretty good. Drawback to using the exe's is that the logreader one requires a control-c to exit...

If you're using an ADO command object or passing the parameters directly in a connection.execute you typically do something like this: replace("Mary's","'","''"). If you assign the value to a field...

Not sure how much time you save by adding it to the model, but if you do attempt that pattern it would make sure you stayed consistent (or try to...

Sure. My article will show you how to avoid the snapshot.

http://www.sqlservercentral.com/columnists/awarren/alterreplicatedtable.asp

Andy

Nope. You can only have one null and still call it unique. Maybe an indexed view as a hack? Or how about moving all your null records to a separate...

By putting criteria in the where clause you essentially are changing the join to an inner join. Not sure if this is what you want, but maybe!

SELECT City_Id, City_Name, ...

I have not used it in production, we use transactional replication to move to a reporting server that doubles as the dr box. Have used it at home on a...

If they are fixed length rows you could subtract out the byte count for header and trailer, then divide remainder by the row length.

Andy

I typically set this in the client app based on what's running. Usually set the connection to time out in 30 seconds, occasionally commands will be longer if I know...

I think the trick here is to report off of one view, not do conditional branching to figure out where to get the data from. By using a view to...

Leon and I did some experimenting with Shape a few months ago, found out that basically it returns ALL rows for the child records, then filters the display for you...

How about using a distributed view? And probably adding the report period to the live db.

Andy

Can you post what you have tried so far?

Andy

You can also use OSQL.EXE to do this - see BOL for the parameters.

Andy