Search results for query: *

(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...

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...

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...

(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

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

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...

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...

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...

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...

(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

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)...

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...

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...

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...

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...

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...

(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...

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

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...

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...