Search results for query: *

My boss set up transactional replication from one SQL Server 2008 instance to another. When he set it up it created a snapshot job that runs once an hour, and every time it runs it causes deadlocks. He's doesn't know much about replication and neither do I... can't we just disable the job? I've...

Thanks michbar, that's exactly what I was looking for!

I can't figure out if there's a way to get the pane with the subjects and flags, etc., to show all the fields it's supposed to in multiline view. I know they're all there because they show up if I stretch out the pane horizontally.

The slowness was just temporary, but now I'm having problems accessing variables from user controls. I have one ascx inside another inside the aspx page, and I can access variables in the outer one (e.g. ascx1.table1.color=red) but not in the inner ascx (e.g. ascx1.ascx2.textbox1="text")...

My solution works, but when selecting items in the dropdowns I put in the ascx files, it's quite slow. And the dropdowns are only date selectors (month, day, year), so it's not even like they have a long list of values. Maybe it's the viewstate that's slowing it down, I have no idea.

I think I thought of a good solution. I'll turn each item group (eight textboxes) into one ascx class. That should be a lot easier if it works the way I think it will.

I'm working on a form that will have several textboxes for each item entered, e.g. item#, description, size, etc., for up to ten items, so let's say 8 textboxes per item for a total of 80 on the form. I'd like to be able to do something like a repeater and/or a control array so that I can...

In case that's hard to read, you're replacing the single quote with two single quotes.

Depends. Do you want to handle it in the VB code or the SQL code? If VB, then: Replace(<name as string>, "'", "''")

I'm trying to create an ODBC data source programmatically, and it's not working. I'm using the SQLInstallerError API call, and it's returning zero every time, and not placing any error information in the Stringbuilder string I'm passing it. Has anybody else had this problem? Dim nErrorCode...