Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: LFCfan
  • Content: Threads
  • Order by date
  1. LFCfan

    "thou shall" vs "thou shalt"

    (Not quite modern grammar, but I have no doubt that someone on MAI will know the answer!) Does anyone know whether the two are interchangeable in Middle English, or whether there are rules deciding when you'd use one over the other? I'm struggling to google this, all that comes up is biblical...
  2. LFCfan

    What to do with the commas here?

    This is what I have I think the "when I want but feel" is a little confusing with no comma after "when I want". Also I don't think the comma is necessary after "what I want" The above looks better to me, but then the subject is the same in both parts... Without a comma the sentence might run...
  3. LFCfan

    "He was still sat there an hour later"

    Hello folks I wrote a little story the other day and included the sentence: One of my readers has very kindly sent me a message saying it sounds wrong to them. Should it be "He was still sitting there..." instead? I've been rolling both sentences around in my head too much and now...
  4. LFCfan

    Out of the mouths of recruitment agents...

    (In homage to Santa's thread) I got an email from a recruiter today: I hope the poor client isn't a financial institution ~LFCfan
  5. LFCfan

    SqlTransction, Insert Parent + child -> Foreign Key errors

    I have the following (in semi-pseudo code) using (SqlTransaction transaction = connection.BeginTransaction()) { try { int newid = InsertParent(transaction, ...)...
  6. LFCfan

    Casting objects that inherit from List<T>

    I have a class Workers as below public class Workers : List<Worker> { public static Workers GetAll() { WorkersReader reader = new WorkersReader(); -- return (Workers)reader.ExecuteReader(); List<Worker> workerlist = reader.ExecuteReader(); Workers...
  7. LFCfan

    usercontrol works fine in dev environ website, not in prod website

    Hi folks I have a usercontrol which works fine in my dev environment (which is just a website with one page that has the usercontrol in it). The usercontrol contains 3 dropdownlists, ddl1, ddl2 and ddl3. When the selected index of ddl1 changes, ddl2 and ddl3 are re-populated from the database...
  8. LFCfan

    ASP.NET Membership - quick question

    Forms based authentication, ASP.NET 2.0 Using Sql Server Membership Provider I know you can set passwords to expire every month or whatever, but can you set up membership so that it doesn't let users re-use passwords for a certain amount of password change periods? So, for example a user has...
  9. LFCfan

    Storing web.config connectionStrings section centrally

    ASP.NET 2.0 environment. I have to change connection strings in all of our websites' web.config files... and it's a lot of files! I was hoping to be able to use an external config file for this, and place it somewhere where all apps could read it, but it turns out that something like...
  10. LFCfan

    Backing up DTS packages

    (Sql Server 2000 environment) As far as I can tell, in order to be able to restore all DTS packages on my sql server instance, all I need to do is have a backup of msdb - is this correct, or should any other actions be taken on top of that? Many thanks ~LFCfan
  11. LFCfan

    OLEDBSource-&gt;FlatFileDestination: datetime problems

    My OLEDBSource is a Sql Server table, which has some varchar columns. These columns all contain "dd-mm-yyyy hh:mm:ss" data, which is how I would like them exported to the flatfile. The problem is that despite the table columns being varchar, the dataflow task (the green arrow between the two)...
  12. LFCfan

    Oracle OLEDB Source, not recognising (+) join syntax, decode, to_char.

    Hi all I'm trying to import some data into Sql Server 2005 from Oracle 10g, using a Sql Command which has the (+) outer join syntax as below from s, c, d, o where s.KEYVAL = c.MDKEYVAL and s.SRCLOSEACT = d.CODEVALUE(+) and d.LISTNAME(+) = 'SRCLOSEACT' and also various standard Oracle...
  13. LFCfan

    SQL Profiler oddity

    I was running a trace (Sql Server 2005), and noticed that when a particular stored proc is executed, that takes two smalldatetime parameters, the execution statement shown by Profiler was exec dbo.GetAvailableDates @start=''2008-10-01 00:00:00:000'',@end=''2008-10-31 00:00:00:000'' ... with...
  14. LFCfan

    Bizarre error on ALTER TRIGGER

    SQL2K5 The error is: Msg 208, Level 16, State 6, Procedure tr_myTable_INSERT, Line 33 Invalid object name 'tr_myTable_INSERT'. ALTER TRIGGER tr_myTable_INSERT ON [mySchema].[myTable] FOR INSERT AS ..... (line 33) INSERT INTO mySchema.myOtherTable SELECT ... ..... Now, myOtherTable has no...
  15. LFCfan

    VS thinks I am my colleague

    My colleague (SI) and I (MP) are both working on the same solution, using VSS. For some reason, whenever I check out a file, it shows in sourcesafe as being checked out to SI rather than MP. Does anyone know where Visual Studio keeps information locally about which Sourcesafe user it thinks...
  16. LFCfan

    Sourcesafe issue/mystery

    My colleague (SI) and I (MP) are both working on the same solution, using VSS. For some reason, whenever I check out a file, it shows in sourcesafe as being checked out to SI rather than MP. If I restart my machine without checking all my work in, when I reload Visual Studio, I can't keep...
  17. LFCfan

    Help - is my spid rolling back or not?

    (SQL Server 2005) I have a process that was killed. sp_who2 'active' now shows this spid with a status of suspended, and a command of KILLED/ROLLBACK. The DiskIO figure is changing on each refresh of sp_who2. The LastBatch timestamp isn't changing - it's displaying a time of 3 hours ago. The...
  18. LFCfan

    Free Rice

    http://www.freerice.com/index.php For each word you get right, they donate 10 grains fo rice through the United Nations to end world hunger. And it's fun too :-) ~LFCfan
  19. LFCfan

    Auto-start SQLAgent service when SQLServer service starts?

    Hi folks, As far as I can tell from googling, while it is possible to set the SQLAgent service to start automatically after a server reboot, it doesn't appear that you can set it to start automatically when the SQLServer service starts (or restarts). Is anyone able to confirm this? We had an...
  20. LFCfan

    Linked Server - query MS Indexing Services on different machine

    Does anyone know if it's possible to set up a linked server for Index Service running on a different machine to the Sql Server? I have set up the linked server, with Location and Datasource both pointing to the other box, and it hasn't errored on creation. However running a query against the...

Part and Inventory Search

Back
Top