When I run this query below I get the error message below. The problem seems to have something to do with the fact that I entered a String as the date. Both fields are "datetime" and I'm using MSSQL7.0. Is there any way to insert a string as a date or am I going to need […]
2004-05-09
1 reads
You may be getting this error message when the file you transfer contains a DRI in this case a non clustered index. Regards
2004-05-07
Hi there,I'm using a master server to manage similar jobs on several SQL Servers, and this works fine. There is a nagging peculiarity which I find strange: these jobs for the targetserver should run on the masterserver as well. It seems I cannot designate the master as a target. Is this correct, or do I […]
2004-04-15
1 reads
Thanks Jack,As it turns out I'll be moving to SQL 2000 very soon now, so this will become useful almost immediately. I'm running tests this week.
2004-03-30
You know, this is a lot more than once that the proper answer is passed over. I guess the best thing I can say is that it's now just like the actual Microsoft Exams!
2004-02-06
Sorry, I gueas I shouldn't hit enter. -- anyway the query is something like select column1,column2 from openquery(EDACONN,'select column1,column2 from table') We can run it, it returns 78000 records. We can run it about 3 - 4 times then we'll get an error ... OLE DB provider 'EDAOLEDB.1' reported an error. The provider ran out […]
2004-02-04
1 reads
> select * from test where chkdate between '20040106' and dateadd(s, -1, '20040107')This might work with smalldatetime values, but it will possibly exclude some datetime values for that date. See my predicates using >= and < rather than BETWEEN.> select * from test where dbo.Dateonly(chkdate) = '2004-01-06'Three problems with this:By using a conversion style that uses only two digits […]
2004-01-28
1 reads
You can restore to an earlier point in time. Let's say you want to restore to 1 January. Restore a full backup from that day or a previous day (use WITH NORECOVERY). Then restore any transaction log backups that may have data up to 1 January (use WITH NORECOVERY on all but the last one). […]
2004-01-23
1 reads
Cheers Gary, Hmm..I haven't implemented a source control application yet.Something I have to look at.Do most people use Visual Source safe, or perhaps implement their own thru drawing up their own procedures?Maybe I should start up another thread for this dicussion?ta, yogi
2004-01-11
jxflagg, I just had to drive my wife to work and on my way there I realized that a cursor would be the tool to use. Thanks for confirming this. I appreciate it.
2003-12-18
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers