Recent content by jcaulder

Yes, I got with my network admin and he confirmed that "host files were not correctly delivered to those machines as part of their original image". It is a DNS issue and I am by no means an expert on that either. Since the IP address works, the problem is resolved and I at least can move...

We have different servers in our environment ranging from Windows XP, Windows Server 2003 and Windows Server 2008. The publisher or server I am trying to link to is Windows Server 2008. All subscribers are running the same SQL Server versions(SQL Express 2008) while publisher is running SQL...

I have an environment with 42 remote subscribers and am trying to create linked server connections from my subscribers to my publisher server so I can run queries from subscribers. I am able to successfully create linked servers from some subscribers but not others. All of the SQL Servers for...

Replication management requires an entirely different skill set to maintain than typical SQL Server maintenance. That's probably why you get the resistance. It isn't terribly difficult to set up but when things go wrong, you better know what you're doing. There are many DBAs with no...

I think this should do it: select table_a.B_ID from table_a left outer join table_b on table_a.B_ID = table_b.ID where table_b.ID IS NULL

I should first ask "where and how are you creating the query to return the login?" I think you probably have a stored procedure that you are passing in parameters for firstname and surname? If so, whatever your parameter names are should be inserted into the query. If your parameters are...

It is sometimes difficult to answer a question without having full background. I initially answered the simple question you had suspecting you needed a more robust solution but not wanting to confuse you by complex examples. My guess would be that you are probably binding your controls to a...

Create an event handler for each object you want to know when its text changes. Inside the event handler, take whatever action you would like to update the form level property or caption: 1)For a text box, while in design view, double click the text box. You can also go to code view, find the...

Something like the following is close to what you want: Dim c As Control For Each c In Me.Controls MsgBox(c.Name) Next However, I would probably create event handlers for the controls to handle textChanged event and let that set the property on the form or take whatever action necessary. J

Oops, you wouldn't need the UPPER in the second part of the condition since by default it is case insensitive: declare @name varchar(16) set @name = 'firstname' select * from myTable where (firstname = @name COLLATE Latin1_General_CS_AS AND ID >= 4) OR (firstname = @name AND ID < 4) Sorry...

I think you can just OR the conditions together to simplify the query and force the table and input parameter to upper case to ignore stored and entered values prior to ID = 4. No need for dynamic SQL... declare @name varchar(16) set @name = 'firstname' select * from myTable where (firstname =...

I assume you fixed this by now but when are you calling Items.Clear()?

Because services normally run without interaction from the user and whether or not anyone is logged on or not, it generally doesn't make sense to provide an interface. What I generally do is provide all of my business logic in a separate dll. I then reference this dll from my service and from...

It's hard for me to imagine what kind of task you would want to run a maximum number of times without being linked in anyway to a timer. Is a user or some other process going to make the task execute and you don't want them to be able to execute it more than 'n' times? A little more...

Disregard the post. The information provided to me and posted was inaccurate.