Mirroring will copy the permissions, etc. You will have to set up the mirroring for each db as it won't automatically mirror a new database when you create it. The...

Could you give them no permissions to the tables themselves so that they do everything through the views?

For views that need to support insert/update/delete you can create instead of triggers...

You want to use a "Derived column" transformation.

So this is one of those cases where you have to play with the system tables.

But what does job_id relate to? Is it the package ID in SSIS?

That's what I was looking into, as it seems I can't script the maintenance plans. Thus it seems like I don't want to use them anymore, but instead script the...

I was trying to avoid having to perform things like restores on failover so that the other server is ready to stand in almost right away.

That's what I thought, seems simpler than trying to get the maintenance plan copied, found a way to get the script the maintenance plan generates the other day, so that...

Can you please avoid crossposting otherwise it confuses things.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=334992

"osql -?" for list of options, check books online for more information on each one ( http://msdn2.microsoft.com/en-us/library/ms162806.aspx&nbsp.

I belive the option you're after though is:

-i...

I find those filter systems more anoying usually, since they often stop people name 'Dick' from posting, or such sentences as 'careful you don't prick yourself'. At the end of...

It seems that checking if a parameter is null is not supported by SQL Mobile.

Also SQL Mobile doesn't support timestamps.

Thus the only two simple solutions I can think of were:

Having a...

If you're not returning thousands of rows it may be better just to have the client calculate this.

Something as simple as using System.Collections.Specialized.BitVector32, this will effectivly give you 32 boolean...

It can, you just have to set up the table styles, and set each column style's visible property to false for the ones you don't want to show up. That...

Ah, so if the entire column (not row) doesn't have any values for that field then you wan't to hide the column, that sounds more like something that should be...

How about:

Where SessionTypeID = 1

And tl.Date = '01/16/2006'

AND (

    col1 IS NOT null

    OR col2 IS NOT null

    ....

    OR col20 IS NOT null

)